Questions tagged [azure-sql-managed-instance]
258 questions
1
vote
0 answers
Azure managed instance connecting using ssh tunnelling
I am connecting to the Azure SQL managed instance using PUBLIC ENDPOINT by JDBC connection. It is connecting properly. I can able to read the data using JDBC.
But If I tried to connect the public endpoint of azure sql using SSH tunneling, I am…
SUBHASH V K
- 11
- 3
1
vote
2 answers
Azure Managed instance failover with transnational replication
I have two azure SQL managed instances in different region and configured fail-over group between the same MI instances. Also configured the transactional replication between on-prem sql \ Azure IaaS VM to primary managed instance. Now want to test…
ravi kumar
- 11
- 1
1
vote
2 answers
How we connect read only intent in azure sql manage instance?
I want to connect a Read-Only replica for reporting purpose in Azure SQL managed instance. For this, I tried to add an ApplicationIntent=ReadOnly parameter.
But it is still it not connecting the Read-Only replica. So is there any configuration…
NP007
- 659
- 8
- 21
1
vote
1 answer
Product version of Azure SQL Managed Instance
xp_msver[ProductVersion] and SERVERPROPERTY('ProductVersion') do not return same version for Azure SQL Managed Instance. Shouldn't those two be the same?
user3037556
- 13
- 7
1
vote
1 answer
migrate "Azure sql server" data to "Azure managed instance"
What are different options to move database from "Azure sql server" to "Azure sql managed instance", Looks like below options are not possible 1) Azure migration service - Not supporting azure sql server as source 2) bacpac and use sqlpackage to…
Dyaneshwaran S
- 69
- 1
- 7
1
vote
0 answers
The semaphore timeout period has expired
I've tried to upload my records from excel to azure managed instance using Import Export Wizard SSMS 12. Below are the error I faced while upload the data. I tried 5 times to upload with using 5 same records. only 1 time the data inserted. another 4…
user12549357
- 11
- 2
1
vote
2 answers
How to connect an Azure SQL Managed Instance to an Azure App Service (written in .NET Core 2.2)
I have a .NET Core 2.2 web app deployed to Azure App Service which I'm connecting to an Azure SQL managed instance. What should be the connection string that is to be written in Appsettings.json. I tried the below connection string which I found out…
Rahul Dev
- 141
- 2
- 17
1
vote
1 answer
Get actual execution plan for query taking more than hours?
While performing analysis observed that particular procedure was running in 10 mins on SQL VM, however for some reason it is taking 1 min in SQL Managed instance. This is happening in production environment.
To analyze further trying to get actual…
Vikrant More
- 5,182
- 23
- 58
- 90
1
vote
0 answers
How to fix the ALTER TABLE statement conflicted with the FOREIGN KEY constraint
Unable to create a relationship 'FK_Sales_Date'.
The ALTER TABLE statement conflicted with the FOREIGN KEY constraint "FK_Sales_Date". The conflict occurred in database "SalesDataWarehouse", table "dbo.Date", column 'DateKey'.
1
vote
1 answer
Does SSRS in an Azure Virtual VM support Report Server Databases as Azure SQL Database and/or Azure SQL MAnaged Instance?
I installed SSRS into an Azure VM (IaaS). In the ssrs configuration manager, I tried the report server databases point to an Azure SQL Managed Instance database, but the connection didn't work. I would like to know if SSRS in an Azure VM support…
GMVS
- 11
- 1
1
vote
1 answer
Connectivity to Azure Managed SQL Instance from local SSMS
I have created a Azure managed sql instance. We have peered the vnet of both managed instance and the local VM vnet. Our organization doesnot allow installing Point-to-site vpn on current VM.
Please advice, how can we connect to managed sql instance…
Asitkool
- 13
- 2
1
vote
1 answer
Why is my managed instance database encryption is not being disabled?
I am trying to disable encryption on a database which is hosted inside Azure managed instance. I am not able to disable the encryption for it. Any help would be highly appreciated.
I have tried this alter database query:
ALTER DATABASE…
Moulshree Suhas
- 27
- 10
1
vote
1 answer
How to check how long a DB restore took on Azure SQL Managed Instance?
I have just completed a DR test overnight to run a PITR on Azure SQL Managed Instance. This was for a fairly large DB (4TB). I did this by using the Azure CLI. Once I executed the command (see below) and made sure there were no errors, I exited the…
Font_writing_code
- 65
- 9
1
vote
2 answers
Why Managed instance is taking more time to create?
why managed instance taking more time to create?
It has been almost two days managed instance creation started and it is still showing deployment under progress. This is the first time I'm creating MI. Does anyone know how long will it take to…
DBA
- 11
- 2
1
vote
1 answer
Connecting Azure WebApp Service to SQL Managed Instance via Private Endpoint
Is it possible to connect an Azure Web App to a SQL Managed Instance via the private endpoint for the MI?
Following the documentation here https://learn.microsoft.com/en-us/azure/sql-database/sql-database-managed-instance-connect-app it seems to be…
ThomasTheDankEngine
- 11
- 2