6,863 questions with Azure SQL Database tags

Sort by: Updated
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
2 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-05-29T23:04:40.75+00:00
TP 156.8K Reputation points Volunteer Moderator
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,715 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
answered 2026-05-29T03:58:52.8133333+00:00
Pilladi Padma Sai Manisha 8,410 Reputation points Microsoft External Staff Moderator
1 answer

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-05-29T03:53:31.2066667+00:00
Pilladi Padma Sai Manisha 8,410 Reputation points Microsoft External Staff Moderator
2 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
answered 2026-05-28T09:30:14.11+00:00
Alex Burlachenko 21,715 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,210 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,410 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,410 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 250 Reputation points
accepted 2026-05-22T14:19:51.11+00:00
Daniel-4204 250 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,366 Reputation points
commented 2026-05-21T22:08:00.95+00:00
Roussel, Timothy 0 Reputation points
1 answer

Can I restore a SQL Server bak file which has multiple log files to Azure SQL MI?

I ran the SQL to generate a bak file of Mappings SQL Server DB on our data center SQL Server 2016. backup database Mappings to disk = 'F:\backup\Mappings.bak' with init, COMPRESSION, CHECKSUM physical_name of Mappings…

Azure SQL Database
asked 2026-05-18T03:53:24.54+00:00
answered 2026-05-21T14:59:06.1+00:00
Sina Salam 29,516 Reputation points Volunteer Moderator
1 answer

Troubleshoot SQL Database connectivity error 40613

On Azure SQL. We tried to do the preview restart. Still got the error that it could not connect to database. Ran the recommended cloud shell command for Manual Failover and still could not connect to database. Not sure what to do, since it looks like I…

Azure SQL Database
asked 2026-05-14T18:23:31.8233333+00:00
Rob Lim 0 Reputation points
commented 2026-05-20T00:16:03.0866667+00:00
Santhosh Kumar Machukuri 0 Reputation points Microsoft External Staff Moderator
1 answer

Azure SQL Managed Instance stuck in "Starting" state for over 1 hour

We have an Azure SQL Managed Instance that has remained in a "Starting" state for over one hour and has not transitioned to Ready. Environment: Azure SQL Managed Instance Region: UK South Tier: General Purpose (Gen5), 4 vCores Observed…

Azure SQL Database
asked 2026-05-19T09:52:48+00:00
Keith Walsh 0 Reputation points
recommended 2026-05-19T19:13:28.4466667+00:00
Erland Sommarskog 134.3K Reputation points MVP Volunteer Moderator
1 answer

Login failed for user '<token-identified principal>' (I have spent many hours exhausting options)

Multiple App Service managed identities receive valid Entra tokens that are rejected by Azure SQL with "Login failed for user '<token-identified principal>'" even though: The DB user mapping exists with type EXTERNAL_USER The user's…

Azure SQL Database
asked 2026-05-05T16:05:31.53+00:00
Jonathon Childs 0 Reputation points
commented 2026-05-19T01:06:54.1166667+00:00
SAI JAGADEESH KUDIPUDI 3,210 Reputation points Microsoft External Staff Moderator
1 answer

I need to restore the deleted Azure SQL server and db. I could not restore using the Azure portal.

Session ID:da1f7f0674914bd8816c52e008876566 Conversation ID:8FXcwwXNyhFIE61Ng0WDck-us Activity ID:8FXcwwXNyhFIE61Ng0WDck-us|0000006 Correlation ID:8FXcwwXNyhFIE61Ng0WDck-us|0000000 PI Information<

Azure SQL Database
asked 2026-05-08T21:57:04.43+00:00
Naresh Bonthula 0 Reputation points
commented 2026-05-18T23:02:59.7633333+00:00
SAI JAGADEESH KUDIPUDI 3,210 Reputation points Microsoft External Staff Moderator
0 answers

SQL Server instance CPU persistently high

We have a database pool that has been running well, however since ~13 May the pool has been consistently high CPU. There is a lot of noise of legit queries, so I am showing smaller windows. The last hour looks like this. Zooming to a similar time period…

Azure SQL Database
asked 2026-05-16T00:02:41.6866667+00:00
Trevor Nichols 0 Reputation points
commented 2026-05-18T20:45:48.35+00:00
Erland Sommarskog 134.3K 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-05-18T09:28:30.17+00:00
RJT72 0 Reputation points
2 answers One of the answers was accepted by the question author.

Azure database noy available

TITLE: An error occurred while changing the current database. Database on server '' is not currently available. Please retry the connection later. If the problem persists, contact customer support, and provide them the session tracing ID of '}'.

Azure SQL Database
asked 2026-05-14T16:04:26.5166667+00:00
VinceLaPointe-4810 20 Reputation points
commented 2026-05-17T10:02:02.17+00:00
Erland Sommarskog 134.3K Reputation points MVP Volunteer Moderator