6,947 questions with Azure SQL Database tags

Sort by: Updated
2 answers

SQL Server Deployment in East US 2 Region — Regional Capacity Restriction

Problem description I am unable to provision a new Azure SQL Database logical server in the East US 2 region. Both Azure CLI and ARM deployment via Bicep fail with the error indicating that the region is not accepting new SQL server creation at this…

Azure SQL Database
asked 2026-08-27T15:51:38.9333333+00:00
Jake Stratton 15 Reputation points
commented 2026-09-20T00:56:47.4833333+00:00
SIVASANKAR YEDDULA 170 Reputation points Microsoft External Staff Moderator
2 answers

How to fix Create SQL Database error -Free tier

{ "code": "ProvisioningDisabled", "message": "Provisioning of free limit database is not supported for provided service level objective or region" }

Azure SQL Database
asked 2026-09-11T18:18:04.6866667+00:00
Patel, Harikrushn 0 Reputation points
commented 2026-09-18T12:08:54.1866667+00:00
Kvns Krishna Teja 0 Reputation points Microsoft External Staff Moderator
1 answer

Azure SQL Database cannot be deleted - stale Job Agent association

Hello, I cannot delete an Azure SQL Database because Azure reports: CannotMoveOrDropJobAccountDatabase "The database confis001dev on server conservis01 is used by job account SQL Agent. Database cannot be deleted or renamed while associated with job…

Azure SQL Database
asked 2026-09-14T10:08:34.76+00:00
Hans-Christian Höpfl 0 Reputation points
commented 2026-09-16T09:26:01.9266667+00:00
Kvns Krishna Teja 0 Reputation points Microsoft External Staff Moderator
2 answers

MSSQL error 40613

Today I can't connect to azure SQL at all., I didn't make any change, the IP is ok. The query editor in the Azure portal doesn't work either, however it shows the service available when i check. It is for more than 12 hours already, im not awr of…

Azure SQL Database
asked 2026-09-11T19:36:30.13+00:00
Peter Bancso 0 Reputation points
edited a comment 2026-09-13T11:11:10.62+00:00
calculadora alicia 0 Reputation points
1 answer

Autoscaling delay causing downtime during Azure Load Testing – best approach?

We are currently performing Azure Load Testing on a production-like architecture and are facing issues with reactive autoscaling delays. Test Scenario: Concurrent users: 2000–3000 Load pattern: Step-based ramp (increase every 2 minutes) …

Azure SQL Database
asked 2026-06-24T18:09:07.7066667+00:00
Chandan Shah (Persistent Systems Inc) 5 Reputation points Microsoft External Staff
edited the question 2026-09-10T21:37:17.6533333+00:00
Matthew Trilby-Bassett 225 Reputation points Microsoft Employee Admin
2 answers

Unable to create technical support request with active Developer Support plan

We recently upgraded our Azure support plan from Basic to Developer. I am an Owner of the affected Azure subscription. However, when I try to create a technical support request, either from the affected Azure SQL resource/alert or through Help + support,…

Azure SQL Database
asked 2026-08-07T18:22:20.9166667+00:00
Bohdan Zaiats 0 Reputation points
answered 2026-09-10T13:27:12.4133333+00:00
Smaran Thoomu 35,870 Reputation points Microsoft External Staff Moderator
2 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
answered 2026-09-10T13:08:21.95+00:00
Deepesh Dhake 1,165 Reputation points
1 answer

Create a support ticket to enable a server for Azure SQL

Hello, I just started with Azure App Service. I was finally able to request 1 core server for it. Now I need to create database and I prefer Azure SQL. Second time around I don't know how to create a support ticket to create a server for it. Azure…

Azure SQL Database
asked 2026-09-09T05:45:57.18+00:00
Support Spokenform 0 Reputation points
commented 2026-09-10T13:03:20.29+00:00
Erland Sommarskog 137.4K Reputation points MVP Volunteer Moderator
1 answer

Azure sql database -some FK check constraints automatically change to nocheck

Azure sql database -some FK check constraints automatically change to nocheck , no alter was applied , checked audit log as well.anyone faced similiar issue

Azure SQL Database
asked 2026-09-09T20:44:48.4533333+00:00
Puppala, Sreedhar 0 Reputation points
commented 2026-09-09T20:56:53.82+00:00
Erland Sommarskog 137.4K Reputation points MVP Volunteer Moderator
0 answers

Problem: Sync-Gruppe ist "invalid" (Fehler beim Lesen), Löschversuch hängt seit >30 Min in "InProgress"

Subscription-ID: f3e2736f-fcd9-4d84-ba44-8bd8e098d43c Resourcengruppe: Kalibrierung Server: kaldat-2020 Datenbank (Hub): Kaldat2022 Sync-Gruppen-Name: MW Async-Operation-ID: 7beb56ca-a3a5-4d1e-a4f7-570a0a9b24f3

Azure SQL Database
asked 2026-08-07T16:35:13.8233333+00:00
M. Weißberg 21 Reputation points
commented 2026-09-06T23:15:57.9166667+00:00
Ganesh Chelluri 190 Reputation points Microsoft External Staff Moderator
4 answers

Add a user to a sql database in azure without syncing with entra id; where can i find ssms

I am trying to add a db_writer to a database without tying my database to entra ID. I want people to access the database via seperate login and passwords. The documentation does appear to match whats available on my screen and I cannot find the role for…

Azure SQL Database
asked 2026-09-04T13:32:42.2733333+00:00
Jeanne Howard 0 Reputation points
answered 2026-09-05T09:31:32.55+00:00
Himaja Y 545 Reputation points Microsoft External Staff Moderator
2 answers

How do I fix a failed deployment when making a sql database?

How do i fix this?

Azure SQL Database
asked 2026-09-04T03:23:48.6266667+00:00
Josseline Gonzalez 0 Reputation points
answered 2026-09-04T08:36:29.1866667+00:00
Charan Venkat Sai Thambi 0 Reputation points Microsoft External Staff Moderator
2 answers One of the answers was accepted by the question author.

I am not getting azure free database 100000 vCore seconds for my sql server database

Hi, I am using azure free sql server database with monthly 100000 vCore seconds. But suddenly from current month the benefits are not applying. I am unable to create ticket also. Can anyone help me how to use free services.

Azure SQL Database
asked 2026-09-03T00:10:23.3533333+00:00
Venkata Renukaiah Sanaka 20 Reputation points
commented 2026-09-04T02:26:15.76+00:00
Venkata Renukaiah Sanaka 20 Reputation points
1 answer One of the answers was accepted by the question author.

Elastic Job Agent control database generates constant SQL audit volume despite a single nightly job

We have server-level SQL auditing enabled on Azure SQL logical servers with a Log Analytics destination, using the default audit action groups. The Elastic Job Agent's control database lives on the same server in each of our 3 environments, and its…

Azure SQL Database
asked 2026-09-01T15:29:45.1966667+00:00
Daniel-4204 310 Reputation points
commented 2026-09-02T16:42:37.21+00:00
Daniel-4204 310 Reputation points
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-08-31T18:57:23.4433333+00:00
Eugenio Rossetto 0 Reputation points
1 answer

AI-Powered Natural Language Querying for Azure SQL Data Warehouse

Requirement: AI-Powered Natural Language Querying for Existing Azure SQL Database We have an existing Azure SQL database containing Fact and Dimension tables that are already structured for reporting and analytics. We want to add AI capabilities on top…

Azure SQL Database
asked 2026-08-24T11:35:47.67+00:00
Yernaidu Siraparapu 125 Reputation points
commented 2026-08-27T16:53:38.3233333+00:00
SIVASANKAR YEDDULA 170 Reputation points Microsoft External Staff Moderator
1 answer

How to migrate Azure SQL database from tenant to tenant

I have an Azure SQL database that is has 1 TB approximately and i am planning to migrate it to another tenant with minimum time, how am i able to do so? i have no access to change the billing ownership and the DMS is not working for migrating Azure SQL.…

Azure SQL Database
asked 2026-08-23T14:36:33.8166667+00:00
Kum Wing Kit 5 Reputation points
commented 2026-08-27T16:46:13.1166667+00:00
SIVASANKAR YEDDULA 170 Reputation points Microsoft External Staff Moderator
2 answers One of the answers was accepted by the question author.

Our jobs are failing intermittently at azure sql db step error code 40316

we have so many scheduled job which interact with azure sql database few are failing and few are succeeding , all are configured with same database. see below ss for your reference

Azure SQL Database
asked 2026-08-27T13:13:10.7333333+00:00
Ankit Kumar Bansal 20 Reputation points
answered 2026-08-27T14:18:07.7733333+00:00
Himaja Y 545 Reputation points Microsoft External Staff Moderator
0 answers

Join: Microsoft Azure Q&A Champions Program

The Microsoft Azure Q&A Champions Program recognizes and empowers a global community of internal and external Azure experts who help customers succeed by providing high-quality, trusted answers on Microsoft Q&A. The program scales expert led…

Azure SQL Database
asked 2026-08-26T19:45:45.2266667+00:00
Ashley Swearingen 0 Reputation points Microsoft External Staff Moderator
3 answers

Why am I getting a bill of 2.5 K INR for a free Azure SQL Server recource?

I am a student trying to get into the DE Space. I had created a Azure SQL Server Resource in my subscription and it is a free tier one. I haven't been using it much, but out of nowhere I am getting a bill of 2.5K INR. Can anyone please help me understand…

Azure SQL Database
asked 2026-08-17T16:58:40.84+00:00
Shyamal 0 Reputation points
commented 2026-08-25T17:13:46.7033333+00:00
SIVASANKAR YEDDULA 170 Reputation points Microsoft External Staff Moderator