6,308 questions with Azure SQL Database tags

Sort by: Updated
0 answers

Azure PostgreSQL server unreachable – app failing with OperationalError (Tracking ID: e521870a-a610-410d-a970-b5b3e05e6e50)

Summary: My Django web app hosted on Azure App Service has worked flawlessly for months but suddenly started returning 500 errors on login. I have made no code changes. On investigation, I've confirmed the app can no longer connect to the Azure…

Azure SQL Database
asked 2025-06-14T21:44:39.98+00:00
Tom Rye 0 Reputation points
0 answers

Unable to Reclaim Allocated Space After Shrinking Azure SQL Database

We are experiencing an issue with reclaiming allocated space from our Azure SQL Database (Pass Service)despite running DBCC SHRINKDATABASE. The database in question (db_name) currently shows approximately 300 GB of used space but over 1 TB of allocated…

Azure SQL Database
asked 2025-06-14T14:39:48.0966667+00:00
Dattatray Giramkar 0 Reputation points
commented 2025-06-14T15:25:04.2+00:00
Erland Sommarskog 121.3K Reputation points MVP Volunteer Moderator
1 answer

Can't create a SQL Database server in East US region.

Hello Team, We would like to create a SQL Database server in East US region. But we see the following error - "Your subscription does not have access to create a server in the selected region. For the latest information about region…

Azure SQL Database
asked 2025-06-13T22:13:23.32+00:00
Rohit Khansili 0 Reputation points
edited the question 2025-06-14T08:39:13.48+00:00
TP 123.5K Reputation points Volunteer Moderator
5 answers

How to connect from an azure VPN to an azure SQL server from my PC?

We want from our work computers using an azure VPN to be able to connect/access the databases we have in azure SQL/MySQL. I have read the documentation but I don't understand how it is possible to do this without having to connect from a virtual machine.…

Azure SQL Database
Azure VPN Gateway
Azure VPN Gateway
An Azure service that enables the connection of on-premises networks to Azure through site-to-site virtual private networks.
1,773 questions
Azure Virtual Network
Azure Virtual Network
An Azure networking service that is used to provision private networks and optionally to connect to on-premises datacenters.
2,752 questions
Azure Database for MySQL
Azure Database for MySQL
An Azure managed MySQL database service for app development and deployment.
977 questions
asked 2023-03-08T18:01:55.6466667+00:00
Alejandro García García 5 Reputation points
commented 2025-06-14T00:03:53.1966667+00:00
Andi B 0 Reputation points
1 answer

How to resolve the "Incorrect syntax near 'FORMAT'" with Parquet file

I'm working with Azure Sql connected to an Azure Storage account. I want to read a Parquet file from a Azure Storage account. This code works with a CSV, so I know the connection is good, but when I set the Format to Parquet I get Incorrect syntax…

Azure SQL Database
asked 2025-06-11T18:20:18.8766667+00:00
Anthony Morgan 0 Reputation points
commented 2025-06-13T19:41:29.2366667+00:00
Sai Raghunadh M 4,120 Reputation points Microsoft External Staff Moderator
2 answers One of the answers was accepted by the question author.

What are the cost impact of increasing storage for databases in Azure SQL Elastic Pool

We’re using Azure SQL Databases in an Elastic Pool configuration with General Purpose: Standard-series (Gen5), 6 vCores, and I’m trying to understand how the cost is calculated for the elastic pool, especially regarding storage usage. My current…

Azure SQL Database
asked 2025-06-12T16:00:58.64+00:00
Palash Mathur 130 Reputation points
edited a comment 2025-06-13T19:34:47.34+00:00
Sai Raghunadh M 4,120 Reputation points Microsoft External Staff Moderator
1 answer

Azure SQL - High CPU usage - Wait type: SOS Wait Dispatch

I have a current Azure SQL database running high CPU utilization. running sp_who2 shows task: SUSPENDED DB000013 programname: tdService. Can this be turned off or adjusted. maxdop adjusted index fragmentation - resolved

Azure SQL Database
asked 2025-06-11T15:02:33.5166667+00:00
Alex 0 Reputation points
commented 2025-06-13T19:14:38.3633333+00:00
Sai Raghunadh M 4,120 Reputation points Microsoft External Staff Moderator
0 answers

"DBCC SHRINKFILE for data files is not supported in a Hyperscale database" error trying to shrink db

I get the following when attempting to use either SHRINKFILE or SHRINKDATABASE: "DBCC SHRINKFILE for data files is not supported in a Hyperscale database when the database is not encrypted or protector change is in progress. Enable transparent…

Azure SQL Database
asked 2025-06-13T18:15:45.7566667+00:00
Nathan Allan 0 Reputation points
commented 2025-06-13T19:06:36.2966667+00:00
Sai Raghunadh M 4,120 Reputation points Microsoft External Staff Moderator
0 answers

Azure Data Sync to on-prem SQL succeeded but the destination table has old and new records

We have an Azure Data sync group to sync multiple tables from an Azure SQL database to SQL on-premises database. The sync group has been setup for a while, however, yesterday we noticed that in one of the tables we had data that should have been deleted…

Azure SQL Database
asked 2025-06-11T12:59:38.24+00:00
Aaron Wong 0 Reputation points
commented 2025-06-13T16:24:22.1766667+00:00
Sai Raghunadh M 4,120 Reputation points Microsoft External Staff Moderator
1 answer

Azure SQL Managed Instance - A disconnect event was raised when server is waiting for Federated Authentication token

We are running Production workloads on Azure SQL Managed Instance, and periodically we see errors: A disconnect event was raised when server is waiting for Federated Authentication token. This could be due to client close or server timeout…

Azure SQL Database
asked 2024-08-28T17:34:06.17+00:00
Aleksey Vitsko 25 Reputation points
commented 2025-06-13T16:13:17.5933333+00:00
Andres Jordan 0 Reputation points
1 answer

Azure SQL PaaS Failover Scenario and Cost

Hi, I have a few questions regarding Azure SQL PaaS failover, pricing, and integration with private endpoint: If I configure a Failover Group that contains 10 SQL databases, will the entire failover group automatically failover if only one of the…

Azure SQL Database
asked 2025-06-07T14:01:43.5833333+00:00
ElenaMarlowe-3376 65 Reputation points
commented 2025-06-13T16:07:40.2866667+00:00
Shraddha Pore 445 Reputation points Microsoft External Staff Moderator
1 answer

Azure, Export Hyperscale Database to BacPac failed due to Vector datatype column in a table.

Trying to export a Hyperscale SQL database to Blob storage BacPac. I did som laborations with VECTOR datatype in one table an left it there for later laborations. The export fails due to the Vector column. ErrorMessage: "The ImportExport…

Azure SQL Database
asked 2025-06-13T13:33:35.3433333+00:00
Micael Uthas 0 Reputation points
answered 2025-06-13T14:44:16.97+00:00
Mahesh Kurva 4,555 Reputation points Microsoft External Staff Moderator
1 answer

Data factory fails to run Stored Procedure when SSMS succeeds

I have a nightly job that generates an email via a stored procedure run through azure data factory. It has been in use for about 2 years with no problem. Yesterday it failed without any changes to the SQL A database operation failed with the following…

Azure SQL Database
asked 2025-06-04T21:24:52.7533333+00:00
Lun, Biondi 0 Reputation points
commented 2025-06-13T14:00:03.3033333+00:00
PratikLad 1,585 Reputation points Microsoft External Staff Moderator
0 answers

Azure Database unable to update Datasync config & Datastudio timeout

We seem to be having 2x issues with an Azure SQL database. Datasync keeps failing sync data & reconfiguring of tables to sync. The database is timing out populating the tree of table in both SQL Management Studio & Azure Data Studio. The…

Azure SQL Database
asked 2025-06-04T08:05:01.6933333+00:00
John Tsui 0 Reputation points
commented 2025-06-13T13:56:45.34+00:00
PratikLad 1,585 Reputation points Microsoft External Staff Moderator
1 answer

Cant get the Database Watcher to start collecting data from the Azure SQL DB

We carefully configured a database watcher as per documentation. everything is setup (Key Vault with proper permissions, executed script to create login and grant permissions (script copy-pasted), created secrets in the vault). But we don't get any data…

Azure SQL Database
asked 2025-06-03T20:03:31.79+00:00
Jurica Smirčić 0 Reputation points
commented 2025-06-13T13:55:13.4133333+00:00
PratikLad 1,585 Reputation points Microsoft External Staff Moderator
1 answer

Failed SQL logins to MI coming from same subnet as SQLManagedInstance

We have started monitoring failed login attempts to our managed instance and see some failed connections that we can't seem to figure out what the attempt may be. Error message: A disconnect event was raised when server is waiting for Federated…

Azure SQL Database
asked 2024-04-30T15:36:48.85+00:00
Ryan Pighin 91 Reputation points
edited a comment 2025-06-13T12:47:41.6766667+00:00
Mohammad Farogh Javed Shaikh 0 Reputation points
1 answer

Login Failed for User '

Encountering the error "Login failed for user '

Azure SQL Database
asked 2025-06-09T11:47:44.02+00:00
Shweta Singh 0 Reputation points
answered 2025-06-13T12:32:20.0166667+00:00
Narendra Pakkirigari 395 Reputation points Microsoft External Staff Moderator
2 answers

Is it mandatory to create index's for azure sql database object's and also how to handle performance issue on azure databases.

Is it mandatory to create index's for azure sql database object's and also how to handle performance issue on azure databases.

Azure SQL Database
asked 2025-06-12T06:54:04.2266667+00:00
Anandhswarupp 185 Reputation points
commented 2025-06-13T01:40:41.49+00:00
Vijayalaxmi Kattimani 3,065 Reputation points Microsoft External Staff Moderator
1 answer

I can connect to my Azure database today. Can you help me solve this issue?

Microsoft.Data.SqlClient.SqlException (0x80131904): A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL…

Azure SQL Database
asked 2025-06-05T21:34:37.32+00:00
Pheng 0 Reputation points
answered 2025-06-12T17:04:10.6933333+00:00
PratikLad 1,585 Reputation points Microsoft External Staff Moderator
1 answer One of the answers was accepted by the question author.

How to improve query performance in Azure SQL Database with large datasets?

Hi everyone, I'm working with an Azure SQL Database that contains a few large tables (over 10 million rows each), and I'm noticing performance issues when running complex joins and aggregations. I've already implemented indexing on the commonly queried…

Azure SQL Database
asked 2025-06-11T16:59:34.1466667+00:00
Advika Sinha 20 Reputation points
accepted 2025-06-12T17:01:52.81+00:00
Advika Sinha 20 Reputation points