6,873 questions with Azure SQL Database tags

Sort by: Updated
2 answers

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 0 Reputation points
answered 2026-06-05T02:32:01.6233333+00:00
Ravi Kiran Pagidi 0 Reputation points
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 8,730 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,385 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 8,730 Reputation points Microsoft External Staff Moderator
1 answer

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 45 Reputation points
answered 2026-06-04T10:31:38.1366667+00:00
Amira Bedhiafi 42,046 Reputation points MVP Volunteer 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,150 Reputation points Microsoft External Staff Moderator
1 answer

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-04T07:48:25.94+00:00

AI answer

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,150 Reputation points Microsoft External Staff 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
answered 2026-06-04T02:11:01.65+00:00
Manoj Kumar Boyini 16,150 Reputation points Microsoft External Staff Moderator
2 answers

How to implement row-level security in Azure SQL Database?

What is row-level security in Azure SQL Database and how can I restrict data access based on user roles?

Azure SQL Database
asked 2026-06-04T01:00:52.3966667+00:00
HimanshuSinha 19,637 Reputation points Microsoft Employee Moderator
answered 2026-06-04T01:49:24.8+00:00
Manoj Kumar Boyini 16,150 Reputation points Microsoft External Staff Moderator
3 answers

Azure SQL Database: App Service login fails with error 18456 State 1 after admin password reset and Key Vault sync (public access disabled, private endpoint)

Service Azure App Service (Linux, .NET) → Azure SQL Database, SQL authentication via the server admin login. Connection string stored in Azure Key Vault and referenced from App Service app settings. SQL "Public network access" is Disabled; App…

Azure SQL Database
asked 2026-05-28T02:37:23.77+00:00
Grant Augustin 0 Reputation points
commented 2026-06-02T06:29:10.9233333+00:00
Erland Sommarskog 134.4K Reputation points MVP Volunteer Moderator
3 answers

Performance Improvement Strategy for Azure SQL Database with Billion-Row Tables

We are currently dealing with a high-volume Azure SQL Database environment where a few core tables contain billions of records, and approximately 20 million new records are added every day. Due to this continuous data growth, both the application layer…

Azure SQL Database
asked 2026-05-27T07:56:23.68+00:00
Mallikarjun appani 6 Reputation points
commented 2026-06-01T02:06:02.5033333+00:00
Pilladi Padma Sai Manisha 8,730 Reputation points Microsoft External Staff Moderator
1 answer

Capacity is stuck on Pausing.

I had an issue where my instance started getting really slow when I added a new column to a table. I removed that table. The performance was still being really slow so I ended up pausing the capacity and now it's stuck in the pausing status. If I press…

Azure SQL Database
asked 2026-05-29T20:58:22.5866667+00:00
Robby Barton 0 Reputation points
answered 2026-05-30T06:19:23.83+00:00
Salamat Shah 420 Reputation points MVP
1 answer

SQL Elastic Pools Not Responding - Timeout error / unable to access table via SQL Management Studio

Hi We have a number of SQL pools that are having access issues. As you can see from the Resource utilization chart there are periods of missing "tracking" : Grant ******@brightlogic.co.uk

Azure SQL Database
asked 2026-05-13T09:57:45.3633333+00:00
Grant Jaquest 20 Reputation points
answered 2026-05-29T10:46:26.3633333+00:00
Alex Burlachenko 21,805 Reputation points MVP Volunteer Moderator
2 answers

host website with database in Azure

I would like get web hosting for a small web application with database. please guide

Azure SQL Database
asked 2026-05-18T23:37:49.9533333+00:00
commented 2026-05-27T00:31:38.52+00:00
SAI JAGADEESH KUDIPUDI 3,215 Reputation points Microsoft External Staff Moderator
3 answers

A vulnerability was detected on Azure SQL server on port 443 that tls1.0 and 1.1 are enabled. But we already disabled and configured a minimul TLS version in configuration

We disabled and configured a minimum TLS version of 1.2 in configuration of Azure SQL server. But a vulnerability was detected on Azure SQL server on port 443 that tls1.0 and 1.1 are enabled. The vulnerabilities were not detected on port 1433 but only…

Azure SQL Database
asked 2026-05-19T12:28:31.8866667+00:00
Singireddy Lohith Reddy 0 Reputation points
commented 2026-05-26T11:59:05.4266667+00:00
Pilladi Padma Sai Manisha 8,730 Reputation points Microsoft External Staff Moderator
2 answers

solucion de pyodbc con azure

Buenas tardes, Estoy usando pyodbc, python 3.11, ODBC 17, al momento de correr mi aplicacion me sale esto: cual sera el problema?

Azure SQL Database
asked 2026-05-18T03:36:46.0166667+00:00
Luis miguel Galindo espinoza 0 Reputation points
commented 2026-05-26T11:55:08.73+00:00
Pilladi Padma Sai Manisha 8,730 Reputation points Microsoft External Staff Moderator
2 answers One of the answers was accepted by the question author.

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 270 Reputation points
accepted 2026-05-22T14:19:51.11+00:00
Daniel-4204 270 Reputation points
2 answers One of the answers was accepted by the question author.

Defender for Cloud VA2065 baseline buttons not responding for SQL Server vulnerability assessment

Summary: I am trying to remediate vulnerability finding VA2065 ("Server-level firewall rules should be tracked and maintained at a strict minimum") on an Azure SQL Server resource using Microsoft Defender for Cloud's Vulnerability Assessment…

Azure SQL Database
asked 2026-05-15T06:17:21.93+00:00
A V Reddy (MAQ LLC) 20 Reputation points Microsoft External Staff
accepted 2026-05-22T06:56:59.1266667+00:00
A V Reddy (MAQ LLC) 20 Reputation points Microsoft External Staff
1 answer

Clarification for the AllowAllWindowsAzureIps range and scope

Can anyone here please clarify if the firewall rule 0.0.0.0 AllowAllWindowsAzureIps scope is for all objects within our Azure Tenant or the whole IP ranges owned by Microsoft…

Azure SQL Database
asked 2023-12-07T01:58:41.92+00:00
EnterpriseArchitect 6,386 Reputation points
commented 2026-05-21T22:08:00.95+00:00
Roussel, Timothy 0 Reputation points