6,858 questions with Azure SQL Database tags

Sort by: Updated
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,101 Reputation points Volunteer 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
answered 2026-05-21T09:55:15.4266667+00:00
Pilladi Padma Sai Manisha 8,150 Reputation points Microsoft External Staff 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.2K 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,205 Reputation points Microsoft External Staff Moderator
2 answers

Unable to create Azure SQL Database on region East US

My Azure tenant is in East US region. I signed up for Fabric (which it created in East US region). I additionally have a Snowflake account (East US region), and I am configuring Snowflake-managed Iceberg tables in Azure OneLake (Fabric). So, to…

Azure SQL Database
asked 2026-05-14T21:39:33.1033333+00:00
Gregory Newcom 0 Reputation points
answered 2026-05-19T00:40:44.3966667+00:00
SAI JAGADEESH KUDIPUDI 3,205 Reputation points Microsoft External Staff 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
answered 2026-05-19T00:23:08.9033333+00:00
SAI JAGADEESH KUDIPUDI 3,205 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,205 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
edited a comment 2026-05-18T21:11:16.55+00:00
Erland Sommarskog 134.2K Reputation points MVP Volunteer 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.2K 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.2K Reputation points MVP Volunteer Moderator
2 answers One of the answers was accepted by the question author.

SQL Server temporal tables - storing the user who deleted a row

Hi all; I am going to use temporal tables to keep a full audit trail of all changes to records in my key tables. One thing I have already implemented is each of those key record models implements: public interface IAuditTrail { /// <summary> …

Azure SQL Database
SQL Server | Other
SQL Server | Other

Additional SQL Server features and topics not covered by specific categories

14,742 questions
asked 2023-07-28T14:54:27.87+00:00
David Thielen 3,231 Reputation points
commented 2026-05-15T16:21:16.3933333+00:00
Erland Sommarskog 134.2K Reputation points MVP Volunteer Moderator
2 answers

databases within a database pool are not available

TITLE: An error occurred while changing the current database. Database '<any in the pool>' on server '' 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-05-13T10:20:21.9266667+00:00
Anton Richards 25 Reputation points
answered 2026-05-14T15:50:49.03+00:00
Manoj Kumar Boyini 15,145 Reputation points Microsoft External Staff Moderator
2 answers One of the answers was accepted by the question author.

How to move Azure SQL from one resource group to other in the same Subscription ?

How to move Azure SQL from one resource group to other in the same Subscription

Azure SQL Database
asked 2025-10-22T20:48:38.9833333+00:00
HimanshuSinha 19,637 Reputation points Microsoft Employee Moderator
accepted 2026-05-13T19:08:26.3933333+00:00
HimanshuSinha 19,637 Reputation points Microsoft Employee Moderator
1 answer One of the answers was accepted by the question author.

Database Watcher Alert Templates Failing to Deploy

I've been trying to set up some database alerting via Database Watcher alert templates. Each time I try to deploy the templates, it fails with the following error message: { "status": "Failed", "error": { …

Azure SQL Database
asked 2026-05-07T16:18:46.21+00:00
Seth Dana 20 Reputation points
accepted 2026-05-13T17:36:08.3133333+00:00
Seth Dana 20 Reputation points
3 answers One of the answers was accepted by the question author.

Need help recovering accidentally deleted Azure SQL Server, database, and resource group (Azure for Students)

I accidentally deleted my Azure SQL Server, SQL database, and the entire resource group from my Azure for Students subscription. Details: Server name: risu_dev Database name: risu_frame Region: Central India Subscription type: Azure for…

Azure SQL Database
asked 2026-05-13T06:53:40.9+00:00
Patel jarnil 20 Reputation points
answered 2026-05-13T11:08:34.7666667+00:00
Saraswathi Devadula 16,025 Reputation points Microsoft External Staff Moderator