6,935 questions with Azure SQL Database tags

Sort by: Updated
1 answer

Unable to connect to SQL 2022 instance with Entra MFA after successfully implementing Entra MFA on Azure ARC

We are unable to connect to SQL 2022 instance with Entra MFA after successfully implementing Entra MFA on Azure ARC Upon checking the on-prem SQL server logins, the Entra Admin account is still not added under logins. There is no Federated Authentication…

Azure SQL Database
asked 2026-08-05T20:39:59.5033333+00:00
Lalitha Kothuru 0 Reputation points
commented 2026-08-09T03:47:00.16+00:00
Ganesh Chelluri 190 Reputation points Microsoft External Staff Moderator
0 answers

Soft-deleted Azure SQL logical server cannot be restored - deletedServers API returns the record but restore fails with SubscriptionDoesNotHaveServer

Summary I accidentally deleted an Azure SQL logical server and cannot restore it, despite the soft-deleted record existing and being well inside its retention window. Environment Server: actually-split-db-server Region: UK South Resource group:…

Azure SQL Database
asked 2026-08-03T21:54:17.81+00:00
Cameron Fullilove 0 Reputation points
commented 2026-08-09T03:45:12.7233333+00:00
Ganesh Chelluri 190 Reputation points Microsoft External Staff Moderator
1 answer

Unable to create technical support request with active Developer Support plan

We recently upgraded our Azure support plan from Basic to Developer. I am an Owner of the affected Azure subscription. However, when I try to create a technical support request, either from the affected Azure SQL resource/alert or through Help + support,…

Azure SQL Database
asked 2026-08-07T18:22:20.9166667+00:00
Bohdan Zaiats 0 Reputation points
commented 2026-08-07T19:42:30.9466667+00:00
Pilladi Padma Sai Manisha 11,620 Reputation points Microsoft External Staff Moderator
2 answers

I am locked out of my Azure account.

I am locked out of my Azure account. I am the only person that uses it. Azure tells me to contact my admin to get permissions but I am the only person in my company. How do I contact a human at Azure to fix this?

Azure SQL Database
asked 2026-08-07T16:21:14.27+00:00
Allan Warren 0 Reputation points
answered 2026-08-07T19:02:03.33+00:00
Erland Sommarskog 136.2K Reputation points MVP Volunteer Moderator
0 answers

Problem: Sync-Gruppe ist "invalid" (Fehler beim Lesen), Löschversuch hängt seit >30 Min in "InProgress"

Subscription-ID: f3e2736f-fcd9-4d84-ba44-8bd8e098d43c Resourcengruppe: Kalibrierung Server: kaldat-2020 Datenbank (Hub): Kaldat2022 Sync-Gruppen-Name: MW Async-Operation-ID: 7beb56ca-a3a5-4d1e-a4f7-570a0a9b24f3

Azure SQL Database
asked 2026-08-07T16:35:13.8233333+00:00
M. Weißberg 21 Reputation points
commented 2026-08-07T16:46:11.0666667+00:00
M. Weißberg 21 Reputation points
1 answer

How do I fix a connection access issue to my database server on azure?

|System.Data.SqlClient.SqlException: Database 'GetSketchy_QA' on server 'getsketchy-serverqa.database.windows.net' is not currently available. Please retry the connection later. If the problem persists, contact customer support, and provide them the…

Azure SQL Database
asked 2026-07-19T21:19:28.1233333+00:00
Beth J 0 Reputation points
edited the question 2026-08-07T07:56:51.87+00:00
Ana Mihaila (BLUEHAWK LLC) 0 Reputation points Microsoft External Staff Moderator
2 answers

Cannot access Azure SQL database from SSMS.

I have created an Azure SQL DB with Entra ID authentication. I cannot access the database from my Windows workstation using SSMS. I need somebody to help me get all the settings set up correctly so that I have smooth access to the database from SSMS.

Azure SQL Database
asked 2026-08-05T18:30:06.5366667+00:00
Warren Pickell 0 Reputation points
answered 2026-08-07T04:22:43.32+00:00
Deepesh Dhake 820 Reputation points
2 answers

Getting Issue with CES unable to connect with Azure Event Hub

Earlier CES working with Destination Type = AzureEventHubsAmqp this was working with same Credentials and everything but now my Azure SQL Database update and not accepting above destination type and restrict to pass AzureEventHubs only then it is not…

Azure SQL Database
asked 2026-07-28T09:55:08.9733333+00:00
Ajay Agrahari 0 Reputation points
commented 2026-08-06T11:00:50.8566667+00:00
Ganesh Chelluri 190 Reputation points Microsoft External Staff Moderator
2 answers

IP communication to Azure SQL server suddenly 10 times slower than usual.

IP communication from our office (data centre) to Azure SQL server suddenly 10 times slower than usual. psping usually take 10 msec or less but now 70 - 100msec resulting some apps very slow. I can send you psping / tracert results over email. Regards,

Azure SQL Database
asked 2026-08-03T15:06:18.37+00:00
Takahiro Yoshida 0 Reputation points
recommended 2026-08-06T09:18:10.64+00:00
Erland Sommarskog 136.2K Reputation points MVP Volunteer Moderator
1 answer

Billing question

My DB invoice was too high last month. I need to understand the reason so that I can proactively manage it. I do have budget set up but I didn't get any notification and received a high invoice. My database and usage are not high to be charged $180…

Azure SQL Database
asked 2026-07-14T12:23:30.2+00:00
Bhaskar Kumar Chowdhury 0 Reputation points
commented 2026-08-06T06:24:42.4633333+00:00
Venkatanaidu Madamanchi 0 Reputation points Microsoft External Staff Moderator
1 answer

I'm unable to delete the DataSync table

I have been unable to delete the DataSync table, the sync metadata database, which we are not using anymore as we moved away from DataSync groups. The data sync group was deleted, and then I've applied all cleanup scripts so we don't have any of the data…

Azure SQL Database
asked 2026-08-05T17:43:14.46+00:00
Jean Rodriguez 0 Reputation points
answered 2026-08-06T02:58:17.8733333+00:00
Ravi Kiran Pagidi 170 Reputation points
1 answer

How to set Azure SQL Database default_database to NewDatabase

How do we change the default database for a new user to our [new database] instead of master. we are using Azure SQL/ SQL database and getting the error 'Keyword or statement option 'default_database' is not supported in this version of SQL Server.' …

Azure SQL Database
asked 2026-08-04T16:49:32.11+00:00
Robert Lang 0 Reputation points
commented 2026-08-05T22:05:43.84+00:00
Allan Solomon Mejia 2,760 Reputation points
1 answer

All Azure resources missing after subscription reactivation — backend investigation required before retention deadline

My Azure Pay-As-You-Go subscription was cancelled and subsequently reactivated. The subscription now displays Active, but all resources that previously existed under it are missing. This includes: Resource groups Azure SQL databases Storage Accounts …

Azure SQL Database
asked 2026-08-02T20:00:26.8433333+00:00
Danie prinsloo 0 Reputation points
commented 2026-08-04T18:36:08.1233333+00:00
Danie prinsloo 0 Reputation points
1 answer One of the answers was accepted by the question author.

Sending SQLSecurityAudit logs to multiple Log Analytics workspaces

We're trying to get logging (SQL Security Audit specifically) to both an "Operations" LAW as well as Sentinel workspace. Scenario; Create SQL Server, set SQL Auditing to send to Sentinel workspace Create sample DB Create diagnostics…

Azure SQL Database
asked 2026-08-03T15:53:39.1133333+00:00
Knock, William 20 Reputation points
accepted 2026-08-04T09:01:38.9766667+00:00
Knock, William 20 Reputation points
1 answer

Data Sync - Adding On Prem DB is "AdAzure SQL Data Sync – Unable to Add New On-Premises Databases After Unregistering Previous Databasesd Failed"

We are facing an issue with our Azure SQL Data Sync configuration. The previous on-premises databases/members were unregistered and removed, and we also performed cleanup and restarted the Data Sync Agent. However, we are still unable to add the new…

Azure SQL Database
asked 2026-08-01T05:00:00.39+00:00
Murugesh Perumal 0 Reputation points
answered 2026-08-02T07:46:53.1733333+00:00
Murugesh Perumal 0 Reputation points
2 answers One of the answers was accepted by the question author.

Azure SQL Database login fails with error 916 for least-privilege SQL user and managed identity, but admin login works

I am trying to connect an Azure App Service application to Azure SQL Database using a least-privilege account. The admin SQL login can connect successfully, but non-admin access fails. Environment: Azure App Service connecting to Azure SQL Database …

Azure SQL Database
asked 2026-07-31T09:39:38.6433333+00:00
Mark S 25 Reputation points
commented 2026-08-02T07:24:59.5266667+00:00
Smaran Thoomu 170 Reputation points Microsoft External Staff Moderator
1 answer One of the answers was accepted by the question author.

Azure SQL Database: Managed identity login fails with error 18456

I have a user-assigned managed identity with an existing contained database user in an Azure SQL Database that cannot log in via Azure AD authentication. Every attempt fails with a login error naming a token-identified principal as unable to log in. I…

Azure SQL Database
asked 2026-07-31T11:38:38.5333333+00:00
Brad-3588 20 Reputation points
commented 2026-08-01T01:29:17.69+00:00
David philip 0 Reputation points
3 answers

Point-in-time restore (RESTORE LOG phase) extremely slow on SQL Managed Instance - stuck in IO_COMPLETION for 4+ hours

Problem summary: A point-in-time restore of a 34 GB database is taking over 4 hours and has not completed. The operation is active (not failed) but progressing extremely slowly. It appears to be I/O-bound on the remote storage rather than CPU- or…

Azure SQL Database
asked 2026-07-24T14:05:14.4033333+00:00
Iu Donadeu Renau 45 Reputation points
answered 2026-07-31T16:34:22.71+00:00
Deepesh Dhake 820 Reputation points
0 answers

Data Sync - Adding On Prem DB is "Add Failed"

Adding On Prem DB is "Add Failed" Failed to perform data sync operation: Cannot create sync member 'XXX_1' because the maximum number of on-premise database as sync member can be created under a sync group is 5 for Basic sync group, But i have…

Azure SQL Database
asked 2026-07-31T03:52:19.2166667+00:00
Murugesh Perumal 0 Reputation points
commented 2026-07-31T04:30:18.25+00:00
Srikanth Chavithina 265 Reputation points Microsoft External Staff Moderator
2 answers

How to set up new SQL server database

I am using enterprise SQL at work and would like to practise my coding from a home laptop. With no previous experience, how do I configure my azure account to create a simple SQL database that I can load data to and use SSMS?

Azure SQL Database
asked 2026-06-28T17:21:09.24+00:00
RCS 0 Reputation points
commented 2026-07-30T21:26:45.0833333+00:00
Erland Sommarskog 136.2K Reputation points MVP Volunteer Moderator