6,830 questions with Azure SQL Database tags

Sort by: Updated
1 answer

Problemi performance DB dopo attività Microsoft del 21/04

Salve, il 21 Aprile microsoft ha effettuato delle attività sul Database di una nostra app di Produzione, da quel momento in poi le risorse del database e le performance del database sono peggiorate. Si nota un rallentamento e un’occupazione significativa…

Azure SQL Database
asked 2026-04-25T06:34:04.41+00:00
Roberto Marino 0 Reputation points
commented 2026-04-25T08:56:04.5966667+00:00
Erland Sommarskog 133.7K Reputation points MVP Volunteer Moderator
0 answers

How to enable connection witrh ms entra id using ssms and azure sql db

I am trying to connect to the sql server using ms entra managed identity but it isn't working. I've exhausted every path that I know to attempt to make this work. I am also trying to create databases on this sever and they keep failing.

Azure SQL Database
asked 2026-04-23T22:10:13.0433333+00:00
Comfort Olorunlero 0 Reputation points Microsoft Employee
commented 2026-04-24T20:20:18.58+00:00
Manoj Kumar Boyini 12,810 Reputation points Microsoft External Staff Moderator
3 answers

Azure Database Link Server

On the on-prem SQL server we can sue link server to connect to the table in different database. Can we make simillar way to connecting between table on the on-prem to azure sql db?

Azure SQL Database
asked 2026-04-23T12:34:32.5533333+00:00
Handian Sudianto 6,926 Reputation points
commented 2026-04-24T20:10:12.6333333+00:00
Manoj Kumar Boyini 12,810 Reputation points Microsoft External Staff Moderator
2 answers

Stop Azure SQL imports into Log Analytics

What are the exact click by click steps to I stop Azure SQL imports into Log Analytics? I have this info below, but I need more direction to determine if Azure SQL is what is writing excessively to Log Analytics and I need exact directions on how to stop…

Azure SQL Database
asked 2026-04-20T13:55:54.51+00:00
Jeff Cochand 0 Reputation points
commented 2026-04-24T15:13:51.8866667+00:00
Santhosh Kumar Machukuri 0 Reputation points Microsoft External Staff Moderator
1 answer

Azure Recovery Service Vault | Move Sql Database

Hello everyone, I need to move the backup of sql databases from a recovery service vault to another. I know that we cannot move data but is there the possibility to preserve backup on the old vault? Does it apply the soft delete state after moving or…

Azure SQL Database
asked 2026-04-21T11:06:47.8666667+00:00
Andrea Longhitano 180 Reputation points
commented 2026-04-24T13:11:05.43+00:00
Pilladi Padma Sai Manisha 7,055 Reputation points Microsoft External Staff Moderator
2 answers

Azure SQL server DB is not pausing automatically even though there are no active connections.

Azure SQL server DB is not pausing automatically even though there are no active connections. And its costing us heavy price. Can someone please help me out with solution and will Azure refund the amount?

Azure SQL Database
asked 2026-04-23T08:38:28.69+00:00
Gururaj Karthik 0 Reputation points
commented 2026-04-24T10:01:08.6166667+00:00
Pilladi Padma Sai Manisha 7,055 Reputation points Microsoft External Staff Moderator
1 answer

Azure SQL Database Query Performance, misleading as it includes primary and standby data

Query Performance is including information for primary and secondary (note this is a business critical read-only replica, not a geo). Take a query ID provided, go to query store, it shows on Secondary, not Primary. This gives misleading information as…

Azure SQL Database
asked 2026-04-09T15:16:48.2833333+00:00
Nancy Wotawa 0 Reputation points
commented 2026-04-24T05:47:57.1866667+00:00
Anuradha 0 Reputation points Microsoft Employee
2 answers

Some tables and views timing out in Power Apps connecting to Azure SQL Server

Hi Today we've been experiencing a timeout issues in a Power App which connects to Azure SQL Server. Below is the error message on one of the queries. This connection has been setup for roughly 3 years without issues but today these errors. Note that…

Azure SQL Database
asked 2026-04-21T15:58:01.91+00:00
AY 36 Reputation points
commented 2026-04-23T21:23:24.8+00:00
Erland Sommarskog 133.7K Reputation points MVP Volunteer Moderator
2 answers

how to allow others to connect to database

doing a group project, first time using azure DB, my group cannot connect to my set up database with my sql authentication user and password. I have set firewall rules with their IP, I've assigned roles, they just cant log in for whatever reason. No…

Azure SQL Database
asked 2026-04-22T17:18:08.2866667+00:00
helpm 0 Reputation points
commented 2026-04-23T20:24:32.9833333+00:00
Manoj Kumar Boyini 12,810 Reputation points Microsoft External Staff Moderator
2 answers

Database transfer to my local system

I need to transfer a database from Azure to my local system, but I’m facing some issues. Could you please help me with this?

Azure SQL Database
asked 2026-04-22T07:26:59.3766667+00:00
Ajay Prajapati 0 Reputation points
commented 2026-04-23T20:23:32.49+00:00
Manoj Kumar Boyini 12,810 Reputation points Microsoft External Staff Moderator
1 answer One of the answers was accepted by the question author.

Unable to disable Microsoft Entra-only authentication on SQL Managed Instance. Met with InvalidParameterValue error

We are unable to disable Microsoft Entra-only authentication on a SQL Managed Instance. Behavior: The API accepts the PUT request (HTTP 202 Accepted) but the async operation fails with:…

Azure SQL Database
asked 2026-04-15T20:05:34.18+00:00
Daniel Sanchez 20 Reputation points Microsoft Employee
accepted 2026-04-23T20:20:06.32+00:00
Daniel Sanchez 20 Reputation points Microsoft Employee
1 answer

Azure SQL Managed Instance database not visible in sys.databases but name still appears to exist

We ran into an issue on Azure SQL Managed Instance after a database drop operation. The database no longer appears in sys.databases, so from the normal catalog view it looks like it has already been removed. However: CREATE DATABASE using the same name…

Azure SQL Database
asked 2026-04-14T16:04:38.1133333+00:00
João Paixão 0 Reputation points
commented 2026-04-23T20:01:21.6866667+00:00
Manoj Kumar Boyini 12,810 Reputation points Microsoft External Staff Moderator
2 answers

Why does my Azure SQL Database with auto-pause enabled show recurring CPU spikes every 5 minutes overnight and is it generating billable compute time?

I have two Azure SQL Databases across two separate development stages: Dev 1 (serverless tier, auto-pause enabled) and Dev 2 (auto-pause disabled). Both databases are configured identically apart from the auto-pause setting. Both receive traffic from…

Azure SQL Database
asked 2026-04-16T20:57:22.55+00:00
Daniel-4204 230 Reputation points
answered 2026-04-22T06:25:52.2666667+00:00
Saraswathi Devadula 15,930 Reputation points Microsoft External Staff Moderator
2 answers

How to adjust the TimeZone of AzureDataBase

Currently, we are using Azure Database in Japan. In our tables, fields like UpdateTime and InsertTime are being recorded, but the times are stored in U.S. time. Is there a setting to make them match Japan Standard Time?

Azure SQL Database
asked 2026-04-16T07:45:02.3433333+00:00
髙村 陸 20 Reputation points
commented 2026-04-22T00:53:00.9666667+00:00
Santhosh Kumar Machukuri 0 Reputation points Microsoft External Staff Moderator
1 answer

Azure SQL: Adding a new data sync group fails

I try to add a new data sync group (currently no exist). However, i get the error Failed to perform data sync operation: Cannot find the user 'DataSync_executor', because it does not exist or you do not have permission. Creating certificate Creating…

Azure SQL Database
asked 2026-04-20T13:07:29.79+00:00
Georg Sieber 25 Reputation points
commented 2026-04-21T17:11:33.8+00:00
Georg Sieber 25 Reputation points
1 answer One of the answers was accepted by the question author.

Best approach to restore an azure sql db from one subscription top another subscription

Hello I have this scenario: I have a susbcription A whihc has az azure sql db server and inside we have two sql db DEV and UAT db. Each have their own user to access/setup. I am creating anothe env on a different subscription B under the same…

Azure SQL Database
asked 2026-04-20T10:52:37.69+00:00
Xhevahir Mehalla 45 Reputation points
accepted 2026-04-21T09:11:12.3333333+00:00
Xhevahir Mehalla 45 Reputation points
2 answers

Azure SQL Server Region Migration (Central India to South India) – Production Latency Issue

I need to migrate my Azure SQL Server and all databases from Central India to South India due to high latency affecting production applications. Current setup: Azure SQL Server with Elastic Pool ~60 databases Connected to 500+ client machines using…

Azure SQL Database
asked 2026-04-12T06:07:42.75+00:00
Ferax AI Labs 0 Reputation points
answered 2026-04-21T05:13:52.8533333+00:00
Saraswathi Devadula 15,930 Reputation points Microsoft External Staff Moderator
0 answers

Migration from Azure SQL Database to SQL Managed Instance on Azure

We have around 100 database in Azure SQL database in an elastic pool. We want to switch for various reasons to SQL Managed Instance like better support for cross database queries. Our conditions are the following: We can only afford a short downtime…

Azure SQL Database
asked 2026-04-16T07:16:14.2933333+00:00
Georg Sieber 25 Reputation points
commented 2026-04-20T15:00:02.7766667+00:00
SAI JAGADEESH KUDIPUDI 2,365 Reputation points Microsoft External Staff Moderator
2 answers One of the answers was accepted by the question author.

Azure SQL logical server create/update stuck: Microsoft.Sql/servers/write failing repeatedly with InternalServerError (HTTP 500) in uksouth

Hi team, I am blocked on Azure SQL server provisioning and need guidance. I am deploying with Terraform, and Azure SQL logical server create/update keeps failing in a loop. In Activity Log, I continuously see: Update SQL server -> Started Update…

Azure SQL Database
asked 2026-04-15T08:39:20.6733333+00:00
Ayush Gupta 25 Reputation points
commented 2026-04-20T11:23:51.85+00:00
Ayush Gupta 25 Reputation points
3 answers One of the answers was accepted by the question author.

ExportDatabase stuck in CancelInProgress state for 2+ days — cannot trigger new export

Hi, I have an Azure SQL Database export operation that has been stuck in "CancelInProgress" state for over 2 days and I cannot trigger a new export. Operation: ExportDatabase - Status: CancelInProgress - Started: 2026-04-11 15:04:47 UTC -…

Azure SQL Database
asked 2026-04-13T17:34:32.2466667+00:00
Ahmed alkhairy 20 Reputation points
answered 2026-04-14T11:02:34.58+00:00
Ahmed alkhairy 20 Reputation points