6,976 questions with Azure SQL Database tags

Sort by: Updated
1 answer

SQL Database: Request for Enabling Zone Redundancy in East US — Provisioning Disabled Error

Problem description I am attempting to enable zone redundancy on an existing Azure SQL Database using Azure CLI, but the operation fails with the error 'ProvisioningDisabled'. The request was to update the database with '--zone-redundant true', but it is…

Azure SQL Database
asked 2026-10-21T19:51:31.41+00:00
Stephen Abney 0 Reputation points
answered 2026-10-21T20:58:19.35+00:00
Hemant Bharadwaj 0 Reputation points Microsoft Employee
2 answers

best practices working with Azure

Hi People, I am working on an important project, can anyone guide me with the best practices which can be implemented in the projects with azure, sql, python integrated projects. with regards, Manasa BR Data Analyst

Azure SQL Database
asked 2026-10-21T08:24:55.13+00:00
Manasa BR 0 Reputation points
edited the question 2026-10-21T10:57:55.3866667+00:00
_AW_ 70,081 Reputation points Volunteer Moderator
2 answers

Creating More than one Database into Azure Sql Database

Hello, We have earlier created Azure Sql Server Database and we are trying to add one more database which is ok to have it? EX. Server: sqldb-mfr-test.database.windows.net Database: sqldb-mfr-test Now we wanted to add another database like…

Azure SQL Database
asked 2026-10-20T19:19:01.0033333+00:00
pdsqsql 436 Reputation points
commented 2026-10-20T21:26:57.3566667+00:00
Erland Sommarskog 138.3K Reputation points MVP Volunteer Moderator
1 answer

SQL Managed Instance Stuck Scaling

I am trying to delete a resource group in my Visual Studio Enterprise subscription, but the SQL Managed Instance is stuck "Scaling managed instance" and has been for over 24 hours now. As it is a Visual Studio Enterprise subscription, I only…

Azure SQL Database
asked 2026-10-20T12:51:08.8+00:00
Shaun McCloud 0 Reputation points
edited a comment 2026-10-20T13:32:32.84+00:00
Erland Sommarskog 138.3K Reputation points MVP Volunteer Moderator
2 answers

Getting Issue with CES unable to connect with Azure Event Hub

Earlier CES working with Destination Type = AzureEventHubsAmqp this was working with same Credentials and everything but now my Azure SQL Database update and not accepting above destination type and restrict to pass AzureEventHubs only then it is not…

Azure SQL Database
asked 2026-07-28T09:55:08.9733333+00:00
Ajay Agrahari 0 Reputation points
commented 2026-10-20T09:29:10.0366667+00:00
Ganesh Chelluri 200 Reputation points Microsoft External Staff Moderator
1 answer

Create a new Microsoft SQL database

I'm trying to create a new database on West Europe region and I get this message: "Your subscription does not have access to create a server in the selected region. For the latest information about region availability for your subscription, go to…

Azure SQL Database
asked 2026-10-19T16:45:52.2866667+00:00
Rui Henriques 0 Reputation points
answered 2026-10-19T16:46:28.0033333+00:00

AI answer

1 answer

Database x on server y is not currently available (Error 40613)

Hello, I have serverless Azure SQL Database which as of ~6.00AM BST this morning became unresponsive and stopped providing telemetry. Azure console shows "NaN B" next to where typically data usage is displayed. All attempts to connect (direct…

Azure SQL Database
asked 2026-10-19T11:30:49.98+00:00
Ben Pearce 0 Reputation points
commented 2026-10-19T13:20:57.03+00:00
Senthil kumar 2,755 Reputation points
1 answer

SQL Data Sync: Subscription Operation Not Supported During Migration — Request for Assistance

Problem description I am experiencing an issue with Azure SQL Data Sync, where operations are blocked with the error 'DataSync_SubscriptionOperationNotSupported.' This occurs even though my subscription was previously active and used Data Sync. I need…

Azure SQL Database
asked 2026-10-17T14:42:48.9666667+00:00
Tajal-8792 0 Reputation points
edited an answer 2026-10-18T05:19:54.1266667+00:00
Andriy Bilous 12,516 Reputation points MVP
1 answer

How to fix login failure for Azure Sql Server from Azure app service.

I have an Azure app service and an Azure SQL server database. The Login to Azure sql server from the Azure app service fails: Error Number:18456,State:1,Class:14 I can run a query on the database using Azure query. I can run a query on the database…

Azure SQL Database
asked 2026-10-17T13:06:03.7233333+00:00
Graeme Thomson 0 Reputation points
commented 2026-10-17T17:10:55.98+00:00
Erland Sommarskog 138.3K Reputation points MVP Volunteer Moderator
1 answer

Clarification on Azure SQL Data Sync Retirement & Alternative Solutions

Dear Azure Support, I recently noticed that Azure SQL Data Sync is scheduled for retirement on September 30, 2027. We have several production environments that rely on SQL Data Sync for bidirectional synchronization between on-premises MS SQL databases…

Azure SQL Database
asked 2025-04-11T09:03:51.85+00:00
Riyaz 0 Reputation points
answered 2026-10-16T05:00:48.8266667+00:00
Mihai 0 Reputation points
2 answers

Alternates for Azure Data Sync

I currently use Azure Data Sync to provide data from an on- premises SQL Server to an Azure hosted website for a company's customers. With Data Sync ending I need to find the best method to retain the function of having data access available to the web…

Azure SQL Database
asked 2025-04-04T17:43:19.0966667+00:00
Bob Fischer 71 Reputation points
answered 2026-10-16T04:57:56.01+00:00
Mihai 0 Reputation points
2 answers

SQL server provisioning is being denied in the selected region for this subscription

Good day all, I'm receiving the following error when I attempt to create a test Azure Sql Free database. The subscription is active and enabled, and there are no existing Azure SQL resources in it, so this does not appear to be a problem with a failed…

Azure SQL Database
asked 2026-10-15T10:44:56.07+00:00
Scott K 0 Reputation points
answered 2026-10-15T14:04:41.9666667+00:00
Jose Benjamin Solis Nolasco 12,861 Reputation points Volunteer Moderator
1 answer

Azure SQL Database: Validating logical_database_guid as a stable identifier for least-privilege access — Permissions and best practices

Problem description I am seeking confirmation on whether using logical_database_guid as a database-local, stable identifier is supported and recommended for least-privilege access when connecting directly to a standalone Azure SQL Database in a General…

Azure SQL Database
asked 2026-10-09T22:18:33.7166667+00:00
Ramu-1383 0 Reputation points
commented 2026-10-14T20:55:00.3466667+00:00
Erland Sommarskog 138.3K Reputation points MVP Volunteer Moderator
3 answers

How do I shrink Azure SQL database allocated space down to value closer to used space?

After archiving data, my Azure SQL database has 1.5 TB allocated space and 500GB used. How do I shrink the database save save on costs?

Azure SQL Database
asked 2026-10-12T18:45:17.62+00:00
Admin-Honors, Steven 0 Reputation points
answered 2026-10-13T19:26:40.94+00:00
Deepesh Dhake 1,325 Reputation points
2 answers

SQL Database: Zone Redundancy Deployment Error — Provisioning Disabled

Problem description I am attempting to enable zone redundancy on my Azure SQL elastic pool, but I encounter an error stating 'Provisioning of zone redundant database/pool is not supported for your current request.' The operation fails both via Terraform…

Azure SQL Database
asked 2026-09-26T06:50:23.53+00:00
BWilson-1307 0 Reputation points
edited an answer 2026-10-13T16:54:35.5333333+00:00
Yuki_Mi 1,165 Reputation points Moderator
1 answer

Connectivity: Troubleshoot DB Availability and Connection Errors

Job failed due to reason: at Source 'NativeToWorkdayCompany': Cannot connect to SQL database: 'jdbc:sqlserver://azcfasqlp003.database.windows.net;database={CFA}', 'Service Principal ID: 583bea78-xxxxxxxxxxxx'.[SQL Exception]Error Code:40613, Error…

Azure SQL Database
asked 2026-10-13T11:52:52.2+00:00
Venkata Ramana Reddy Beeram 0 Reputation points
commented 2026-10-13T14:09:58.2033333+00:00
Erland Sommarskog 138.3K Reputation points MVP Volunteer Moderator
2 answers

Billing Dispute with Azure Pay-As-You-Go invoice - How to contact Support with Chat -or even raise a ticket

This has to be the most frustrating Contact service ever. I have a billing dispute with my latest Azure Pay-As-You-Go invoice. I am disputing invoice G18930752. I am not reporting a technical fault or Azure outage. I have identified that approximately…

Azure SQL Database
asked 2026-10-10T11:19:29.37+00:00
Ian Lowe 1 Reputation point
commented 2026-10-13T06:57:04.2766667+00:00
TP 164.8K Reputation points Volunteer Moderator
1 answer

Azure SQL private endpoint: Linux App Service + managed identity passes DNS/TCP/token checks, but SqlClient OpenAsync fails with ConnectionReset 10054

QUESTION I am investigating a Development-only Azure SQL connection problem from a .NET application hosted on Linux Azure App Service. I would appreciate help identifying the next targeted diagnostic, rather than repeating deployment attempts or…

Azure SQL Database
asked 2026-10-11T09:46:14.5133333+00:00
Pravin Goorun 21 Reputation points
commented 2026-10-11T10:42:17.35+00:00
Erland Sommarskog 138.3K Reputation points MVP Volunteer Moderator
2 answers

Stale PITR SQL restore point

Under Azure SQL Server\Data Management\Backups (Available Backups tab) My SQL server has 2 databases. One database has a very stale date "Earliest PITR restore point" of August 31, 2026 and the other is within 6 days old. I ran the Diagnose…

Azure SQL Database
asked 2026-10-05T13:54:17.9233333+00:00
Matthew Brown 0 Reputation points
answered 2026-10-08T13:27:34.7766667+00:00
Deepesh Dhake 1,325 Reputation points
1 answer

Azure SQL Managed Instance hardware generation update (Standard-series to Premium-series) stuck at Step 2/6 "Virtual Cluster resize/creation" for 15+ hours

I started an update on an Azure SQL Managed Instance to change only the hardware generation from Standard-series (Gen 5) to Premium-series. The vCore count and storage size were not changed. Instance configuration: - Service tier: General Purpose -…

Azure SQL Database
asked 2026-10-07T06:05:01.4133333+00:00
Oryal 0 Reputation points
recommended 2026-10-07T18:06:47.2666667+00:00
Erland Sommarskog 138.3K Reputation points MVP Volunteer Moderator