6,881 questions with Azure SQL Database tags

Sort by: Updated
1 answer

After I turn off the auto-pause delay for my azure sql database

I just created my first Azure SQL database. It is on the free tier. I want to reduce my auto-pause-delay, but I want to stay on the free tier. I read through some of the information on this site and found that if I turn off the free tier, I get the…

Azure SQL Database
asked 2026-06-13T00:45:17.04+00:00
Steven Scearce IV 6 Reputation points
edited an answer 2026-06-13T01:28:12.37+00:00
TP 157.2K Reputation points Volunteer Moderator
1 answer

Trying to add new card to purchase database

Hi all, I'm hoping someone here has hit this and can point me in the right direction, because a week with support hasn't resolved it. In fact i don't even seem to care with level of comms and questions in the last 8 days. The problem: I'm trying to add a…

Azure SQL Database
asked 2026-06-08T20:21:56.41+00:00
Simon Drayton 0 Reputation points
commented 2026-06-12T02:18:34.63+00:00
Bharath Y P 9,645 Reputation points Microsoft External Staff Moderator
2 answers

Run away process

Bad while loop on site cause it to keep writing to SQL, will not stop even after server stopped....NEED IMMEDIATE HELP

Azure SQL Database
asked 2026-06-08T17:03:45.0266667+00:00
Rich Simpson 20 Reputation points
answered 2026-06-11T19:02:48.5466667+00:00
SAI JAGADEESH KUDIPUDI 3,385 Reputation points Microsoft External Staff Moderator
2 answers

Sql Server Billing is very incorrect

I have a resource group with a SQL Server and a SQL Server Database. For my SQL Server Database, I have selected general purpose (most budget friendly), serverless, 1 max vcore 8GB allocated space. Under compute + storage it has an estimated storage…

Azure SQL Database
asked 2026-06-05T21:35:58.08+00:00
Dejan Popovic 0 Reputation points
commented 2026-06-11T02:09:33.5466667+00:00
Lakshma Reddy Vattijonnala 505 Reputation points Microsoft External Staff Moderator
0 answers

How to resolve Databases inaccessible due to CMK TDE key access lost, configuration now correct but databases not recovering

Trying to raise a support ticket but it sent me here. Issue type: Technical Service: SQL Database Environment: Production Severity: Critical (users unable to access production system) Problem type: Security, Private and Compliance Summary:…

Azure SQL Database
asked 2026-06-08T22:30:26.14+00:00
Kevin Whitmore 0 Reputation points
commented 2026-06-10T21:21:13.06+00:00
SAI JAGADEESH KUDIPUDI 3,385 Reputation points Microsoft External Staff Moderator
1 answer

How to tell which resources are using Azure SQL Database 2014-04-01 APIs

I got the email that says I have resources using Azure SQL Database 2014-04-01 APIs and those APIs are retiring but it has no indication on how to find the resources that are using that API. How can I find the resources that are using Azure SQL Database…

Azure SQL Database
asked 2026-06-09T16:07:45.8833333+00:00
Ryan Brown 20 Reputation points
commented 2026-06-10T20:01:14.3633333+00:00
Erland Sommarskog 134.6K Reputation points MVP Volunteer Moderator
2 answers

Production database connectivity issues starting at 10:22am today

Our production database has connectivity issues for ~30 mins staring approx 10:22am today. I've run the diagnostic suggested by Critical insight - no issues found. I need to know what caused the issues so any underlying problems can be resolved.

Azure SQL Database
asked 2026-05-13T10:26:21.9466667+00:00
RJT72 0 Reputation points
commented 2026-06-10T18:19:21.6+00:00
SAI JAGADEESH KUDIPUDI 3,385 Reputation points Microsoft External Staff Moderator
2 answers

Data Sync has been failing for over a week

Data Sync Sync_To_Reporting_Database on Database SDPriceIT has been failing for over a week, I have tried increasing the DTU settings to 3000 and it has still failed. Please advise what Failure looks to be a timeout.. Check the inner exception for any…

Azure SQL Database
asked 2026-06-08T14:52:49.0733333+00:00
Peter Quinn 0 Reputation points
commented 2026-06-10T16:53:59.9066667+00:00
Peter Quinn 0 Reputation points
1 answer One of the answers was accepted by the question author.

How does SQL Server licensing under the IaaS model work for end-of-life versions ?

Specifically, if I have SQL Server 2016 or 2019 running on Azure virtual machines (IaaS) with different licensing models - such as with Azure Hybrid Benefit enabled and without it (using pay-as-you-go for Standard or Enterprise editions) - how is…

Azure SQL Database
asked 2025-07-10T18:57:49.5266667+00:00
$@chin 335 Reputation points
commented 2026-06-10T14:12:40.64+00:00
$@chin 335 Reputation points
8 answers

Retirement notice: Azure SQL Database 2014-04-01 APIs will be retired on 30 June 2026

We’re constantly making updates to Azure SQL Database APIs to ensure optimal security and performance. As part of these updates, we’ll retire Azure SQL Database API version 2014-04-01 on 30 June 2026. See our documentation for a detailed list of all…

Azure SQL Database
asked 2022-11-02T22:58:09.407+00:00
GeethaThatipatri-MSFT 29,597 Reputation points Microsoft Employee Moderator
commented 2026-06-10T09:28:11.2633333+00:00
Dadi, SM (Samba) 0 Reputation points
2 answers One of the answers was accepted by the question author.

Users connecting over Always On VPN using split tunnel for user and device are unable to connect to Azure SQL Managed Instance using Windows Authentication with Kerberos protocol enabled

Users connecting remotely over Always On VPN(split tunnel for user and device) are unable to connect to our Azure SQL Managed Instance using Windows Authentication with the kerberos protocol enabled. It's working ok from on premise servers and over…

Azure SQL Database
asked 2026-06-04T09:00:32.1733333+00:00
Cooling, Steve 65 Reputation points
commented 2026-06-09T07:41:21.3966667+00:00
Cooling, Steve 65 Reputation points
3 answers One of the answers was accepted by the question author.

Azure SQL server initial connectivity issue

Using MS Access 2021 F/E Linked to Azure SQL Server tables via ODBC (Driver 18) The first attempt to open a linked table times out with "Server [server_name] failed." After one or two more attempts, the link will then connect and the…

Azure SQL Database
asked 2026-06-08T18:11:58.1633333+00:00
VBGuyASM 20 Reputation points
accepted 2026-06-09T07:26:47.49+00:00
VBGuyASM 20 Reputation points
3 answers One of the answers was accepted by the question author.

Unable to add user [DOMAIN\user] to Azure SQL Managed Instance for Entra synced AD user.

Hi Experts, I am setting up Windows Authentication to the Azure SQL Managed Instance for a legacy app that does not support Entra authentication. I have synced a small subset for test users through Entra Connect Sync from the on premise active directory…

Azure SQL Database
asked 2026-06-04T11:20:03.8166667+00:00
Joshee, Monika 20 Reputation points
commented 2026-06-08T13:07:37.0033333+00:00
Joshee, Monika 20 Reputation points
2 answers

How to use geo-replication for disaster recovery in Azure SQL Database?

How can I configure active geo-replication in Azure SQL Database to enable disaster recovery across regions?

Azure SQL Database
asked 2026-06-04T07:48:09.3666667+00:00
HimanshuSinha 19,637 Reputation points Microsoft Employee Moderator
answered 2026-06-05T19:15:19.3266667+00:00
Alberto Morillo 35,506 Reputation points MVP Volunteer Moderator
2 answers

If Azure SQL PITR is set to 1 day and the database is deleted, can Azure still retrieve that data after the PITR window expires?

We are building a solution on Azure SQL Database and need to clarify data retention behavior for a client compliance requirement. The client requires that upon deletion, all data be completely and permanently removed from Azure infrastructure. Question:…

Azure SQL Database
asked 2026-06-02T18:50:55.5466667+00:00
Kershawn Edwards 0 Reputation points
commented 2026-06-05T06:04:08.4333333+00:00
Manoj Kumar Boyini 16,725 Reputation points Microsoft External Staff Moderator
3 answers

I tried to clean up my account and it seems i have accidentally remove critical databases and more

I tried to clean up my account and it seems i have accidentally remove critical databases and more. I need to restore the resouces ikolega and all the databases.

Azure SQL Database
asked 2026-05-28T15:30:49.5066667+00:00
David Montalvao 0 Reputation points
commented 2026-06-04T14:22:10.1233333+00:00
Pilladi Padma Sai Manisha 9,945 Reputation points Microsoft External Staff Moderator
1 answer

Having an issue where the business central database exports started silent failing (or failed to start)

I have been backing up the Business Central database using the database export feature, but I noticed my April bacpac was missing and after watching May, it never showed up either. I have verified the SAS URI was valid, and generated a new one just in…

Azure SQL Database
asked 2026-05-29T14:27:51.29+00:00
Chris McClease 0 Reputation points
edited the question 2026-06-04T14:07:15.9233333+00:00
Thanmayi Godithi 10,485 Reputation points Microsoft External Staff Moderator
2 answers

Azure SQL Server deployment fails with RequestDisallowedByPolicy (MCAPS) as SQL authentication is blocked

Azure SQL Server deployment fails with RequestDisallowedByPolicy (MCAPS) as SQL authentication is blocked

Azure SQL Database
asked 2026-05-27T05:33:31.74+00:00
commented 2026-06-04T13:34:19.3833333+00:00
Pilladi Padma Sai Manisha 9,945 Reputation points Microsoft External Staff Moderator
2 answers

How to enable and use auditing in Azure SQL Database?

How can I enable auditing in Azure SQL Database to track database activities and meet compliance requirements?

Azure SQL Database
asked 2026-06-04T07:00:14.0166667+00:00
HimanshuSinha 19,637 Reputation points Microsoft Employee Moderator
answered 2026-06-04T08:45:10.9+00:00
Manoj Kumar Boyini 16,725 Reputation points Microsoft External Staff Moderator
2 answers

Inquiry about Audit Logs for Azure SQL Database PITR Backup

Dear Team, I am a developer working on an Azure SQL Database. We are preparing for an IT audit from our client. We need to check the status of the automatic Point-in-Time Restore (PITR) backups for our database to prove that the system is safely backed…

Azure SQL Database
asked 2026-06-01T02:54:00.41+00:00
Khoa Ho 0 Reputation points
commented 2026-06-04T05:33:27.98+00:00
Manoj Kumar Boyini 16,725 Reputation points Microsoft External Staff Moderator