6,970 questions with Azure SQL Database tags

Sort by: Updated
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-17T15:48:03.5166667+00:00
Graeme Thomson 0 Reputation points
0 answers

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
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.2K 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,160 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.2K 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.7K 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.2K 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.2K Reputation points MVP Volunteer Moderator
1 answer

SQL Database: Authentication Issue After Visual Studio Update — Ongoing Problem

Problem description I am experiencing an authentication problem with my Azure SQL Database after updating Visual Studio. The issue started immediately following the update on September 25, 2026, at 12:00 AM Pacific Time. My Visual Studio project can no…

Azure SQL Database
asked 2026-09-26T22:27:50.77+00:00
Dilip-3803 0 Reputation points
commented 2026-10-06T22:20:43.3966667+00:00
Dilip Kumar 0 Reputation points
4 answers

SQL database Deployment Issues

Hello i'm trying to set up for a SQL server for my university class. I am one of the ones in my class that cannot get my server too deploy. When I set up my server I keep getting this error. I've been troubleshooting trying to fix the error for quite…

Azure SQL Database
asked 2026-09-09T20:52:54.5866667+00:00
Grant Anderson 0 Reputation points
edited an answer 2026-10-05T15:51:10.44+00:00
Yuki_Mi 1,160 Reputation points Moderator
1 answer

Azure SQL Managed Instance DNS Alias returns ResourceNotFound although resource type is advertised(West Europe)

We are attempting to create a DNS Alias for an Azure SQL Managed Instance using the documented resource type: Microsoft.Sql/managedInstances/dnsAliases The following has been validated: Managed Instance exists and is in Ready state. Microsoft.Sql…

Azure SQL Database
asked 2026-10-01T21:14:55.98+00:00
Kishor kumar Reddy Akki 50 Reputation points
edited an answer 2026-10-02T05:11:02.93+00:00
Andriy Bilous 12,516 Reputation points MVP
2 answers

Azure SQL MANAGED INSTANCE error 80071bc9. [CFabricCommonUtils::GetFabricPropertyInternalWithRef] EndGetProperty call failed for property: SpaceToReserveInMB with result: 80071bc9

We are running a Failover group between two instances in Azure SQL Managed instance and we noticed that we faced the same total disconnection issue of SQL clientes, when both instances reach between the 84% to 90% of storage limit. We found that by…

Azure SQL Database
asked 2026-10-01T06:33:54.62+00:00
Jorge 0 Reputation points
commented 2026-10-02T03:52:53.8166667+00:00
Jorge 0 Reputation points
2 answers

ProvisioningDisabled when disabling auto-pause on Azure SQL free serverless database

I have an existing Azure SQL Database in Sweden Central with the following configuration: General Purpose serverless SKU: GP_S_Gen5 Maximum capacity: 2 vCores Minimum capacity: 0.5 vCores useFreeLimit: true freeLimitExhaustionBehavior: AutoPause …

Azure SQL Database
asked 2026-09-29T14:25:43.3266667+00:00
Lyubomir Shumantov 0 Reputation points
answered 2026-10-02T02:47:19.3133333+00:00
Deepesh Dhake 1,325 Reputation points
1 answer

Azure SQL Change Event Streaming: producer stops delivering to one Event Hubs partition after a transient outage and never reconnects

Environment Azure SQL Database, General Purpose (reproduced on both serverless and provisioned compute), CES preview enabled. Destination: Event Hubs Standard namespace, Kafka endpoint (mynamespace.servicebus.windows.net:9093/myhub), @destination_type…

Azure SQL Database
asked 2026-09-22T20:54:48.7866667+00:00
Eugenio Rossetto 0 Reputation points
edited an answer 2026-10-01T10:11:28.5966667+00:00
Mladen Andzic - Msft 11 Reputation points Microsoft Employee
4 answers

SQL Database: Creating Linked Tables in Microsoft Access — Encountered Connection Errors

Problem description I am attempting to create a linked table in Microsoft Access that points to a table in Azure SQL Database. However, I am experiencing connection issues, and the linking operation fails with an error message. The problem started around…

Azure SQL Database
asked 2026-09-29T18:36:29.8233333+00:00
PeterLemay-9856 0 Reputation points
answered 2026-09-30T20:05:10.9266667+00:00
Ganesh Chelluri 195 Reputation points Microsoft External Staff Moderator