Stack Overflow
Stack Overflow

Questions tagged [azure-sql-managed-instance]

258 questions
1
vote
1 answer

Pulumi stack update failed due to operation timed out error

I am trying to create Azure SQL Managed Instance using C# (Pulumi Azure Native). When executing pulumi up -s dev, getting operation timed out error as following: (provisioning Managed Instance is a long running operation and in case of Pulumi, it…
MD TAREQ HASSAN
  • 1,188
  • 20
  • 46
1
vote
0 answers

Connecting Microsoft Access to Sql Managed Instance

So we have a writable database that a lot of our product / data people use. This database has recently been migrated to Managed Instance. We're working on getting them connected to be able to write/update DB records via Access, a functionality…
Daniel Williams
  • 167
  • 1
  • 10
1
vote
1 answer

Can I use an Azure SQL Database as the source for a replication publication?

Due to reasons (I've been told it's a networking issue with MIs; regardless, we can't fix it, we're waiting on a solution from MS that may or may not come out this year), we cannot talk from on-prem to managed instances. However, we can reach Azure…
mbourgon
  • 1,286
  • 2
  • 17
  • 35
1
vote
2 answers

Publishing dacpac to Azure SQL Managed Instance from on prem SQL Server 2016 via PowerShell failing "cannot publish to SQL Server 2014"

I'm trying to publish a dacpac extracted from a SQL Server 2016 on prem server to an Azure SQL Managed Instance using the below PowerShell, but this fails to the error below. SqlPackage.exe /SourceFile:$DacPacFilePathName /Action:Publish…
Matt B
  • 11
  • 1
1
vote
1 answer

cannot delete virtual cluster from azure portal ,it takes long time but still exists

I deleted an SQL managed instance before and also want to deleted related resource ,but they cannot be deleted due to virtual cluster ,I try to delete it, but it takes long time for deleting as below screenshot ,but the virtual cluster still…
Alex Wang
  • 103
  • 1
  • 10
1
vote
1 answer

Azure free account - does it cover SQL Managed Instance?

I have started using my free Azure account and I found out that I cannot create SQL Managed Instance. I get a cryptic error message telling me to change subscription or region, no clear information. The list of free services does not include SQL MI…
Peter
  • 23
  • 2
1
vote
1 answer

Entity Framework Core 5 tries to insert value for computed column

Using Entity Framework 5 and EF Core Power Tools (whith the setting to generate ef 5 code enabled) we get something like the following code generated for each computed column: ...HasComputedColumnSql("([LastName]+isnull(' '+[FirstName],''))",…
George Mavritsakis
  • 6,829
  • 2
  • 35
  • 42
1
vote
1 answer

How can I run multiple instances of a SQL Server stored procedure in parallel

I need to run a stored procedure with different parameters each time - there is no data overlap but some temp tables are being created and dropped inside the procedure. I am calling it via ADF stored procedure activity which is being called in a for…
user12823830
1
vote
1 answer

How do I disconnect open connections to an Azure SQL Managed Instance?

I am working on a process for restoring a database to my Azure SQL Managed instance which involves dropping the existing database and restoring a backup in its place (since Managed Instance doesn't support WITH REPLACE). I am, however, running into…
dingdangdowney
  • 501
  • 1
  • 8
  • 22
1
vote
2 answers

Azure Database Migration Service stuck at "log shipping in progress"

I have a super small (no data, just a few single column tables, I'm just testing) on premise SQL server database that I'm trying to do an online migration for, to a SQL Managed Instance. As far as I know I've configured everything as it should be -…
David_001
  • 5,703
  • 4
  • 29
  • 55
1
vote
0 answers

Best practices for managing connections for database polling using pyodbc?

I need to run a stored procedure on an Azure SQL Managed Instance every 10 seconds from a Python application. The specific call to cursor.execute() happens in a class that extends threading.Thread like so: class Parser(threading.Thread): def…
George
  • 343
  • 2
  • 15
1
vote
1 answer

Should we have to use Failover Group server name or Primary server name in SQL Server managed instance connection string

We have configured a failover group for our SQL Server Managed Instance in Azure portal: Primary Managed Instance : myprod01.asbcdef.database.windows.net Failover Group Name : failover-myprod01.asbcdef.database.windows.net My current connection…
Pரதீப்
  • 91,748
  • 19
  • 131
  • 172
1
vote
2 answers

See history of sql statements run by user in Azure SQL

Is there a way to see a list of statements run by a specific user in Azure SQL? I have a user that complains about query performance. The queries are generated by a tool so he doesn't know the actual query text. If I look in Azure Portal on that…
johanrex
  • 389
  • 5
  • 18
1
vote
2 answers

How do I connect Power BI to my Azure SQL Managed Instance on an Azure VNET?

I have an Azure SQL Managed instance with public endpoint disabled (we store sensitive data and do not want an exposed endpoint on the DB). We have a VNET and when we need to access our SQL managed instance from an administrator's machine, we use a…
R2Bleep2
  • 77
  • 1
  • 7
1
vote
1 answer

Azure SQL Managed Instance error "Could not load the DLL odsole70.dll, or one of the DLLs it references"

I am trying to call the API service from Azure SQL Managed Instance database and I am getting the error below. However, when I execute from my local SQL server, it works fine. I used the queries below: USE MASTER GO sp_configure 'show advanced…
Hemant Sudehely
  • 49
  • 1
  • 10
1 2 3
…
17 18