6,732 questions with Azure SQL Database tags

Sort by: Updated
1 answer

Setup DAB for Azure Static Web App to connect to Azure SQL Server

Trying to setup a Static Web App to connection to Azure SQL server. Documentation is out of data providing SWA setup but once you go to the Azure portal - Database cannot be connected to using UI in portal. Tried setting up Docker but can't get .Net 8…

Azure SQL Database
asked 2026-02-04T03:40:40.8466667+00:00
Timothy E Hu 20 Reputation points
commented 2026-02-04T06:01:51.7866667+00:00
Suchitra Suregaunkar 7,100 Reputation points Microsoft External Staff Moderator
2 answers

Agent message code 21118. Failed to connect to Azure Storage '\\filestorage.file.core.windows.net\replshare' with OS error: 67.

We are trying to mount Aure file storage account file share with SQL Managed instance and getting below error: -XCancelEventHandle Global\Distribution-{999CD062-8A3C-4697-9A2A-B241BB5852ED} 2026-01-15 08:28:21.258 Startup Delay: 2800…

Azure SQL Database
asked 2026-01-15T12:13:28.83+00:00
Devulacheruvu Venkatesh 0 Reputation points
commented 2026-02-04T02:40:53.0366667+00:00
VRISHABHANATH PATIL 5,175 Reputation points Microsoft External Staff Moderator
2 answers

Azure SQL Server General Purpose DB migration to Hyperscale stuck in the first step

Hello I started a small DB migration (~10GB) from General Purpose to Hyperscale before actually upgrading our production DB (~700GB). The problem is that even the small DB is now stuck in this process. I noticed the migration wizard is also buggy (it…

Azure SQL Database
asked 2026-01-29T19:55:19.2133333+00:00
ebahr 0 Reputation points
edited a comment 2026-02-04T01:37:10.51+00:00
ebahr 0 Reputation points
3 answers One of the answers was accepted by the question author.

Can't register disconnected SQL Server instance

I'm new to azure and I'm trying to create a database for my ASP.NET website. I am having trouble in creating it as I get an error. The error plainly states: "SQL Server registration for ESU" with a line below it that says "Failed to…

Azure SQL Database
asked 2026-02-01T21:11:15.34+00:00
Wes Stout 20 Reputation points
accepted 2026-02-03T23:18:45.7733333+00:00
Wes Stout 20 Reputation points
2 answers

Az SQL DB performance issues

Query latency differs across environments (Dev vs UAT) – same stored procedure, different performance I’m facing a performance issue where the same stored procedure and identical query logic behave differently across environments. Problem…

Azure SQL Database
asked 2026-02-03T12:18:06.17+00:00
Hemanth Kumar Kotha 0 Reputation points
answered 2026-02-03T22:36:28.0666667+00:00
Erland Sommarskog 132K Reputation points MVP Volunteer Moderator
2 answers

Azure Billing related issue

Earlier, I was paying approximately ₹560 per month for Azure SQL Database, which was for a single database running on a basic DTU tier. Last month, I created one additional SQL database in the same Azure tenant. Since Azure charges SQL Database costs per…

Azure SQL Database
asked 2026-02-03T20:30:43.69+00:00
EEHA 0 Reputation points
answered 2026-02-03T22:29:56.8466667+00:00
Erland Sommarskog 132K Reputation points MVP Volunteer Moderator
2 answers

Azure Elastic Jobs dynamic enumeration includes databases from wrong elastic pool

I'm experiencing an issue with Azure Elastic Jobs where the dynamic enumeration feature is incorrectly including databases from the wrong elastic pool. Setup: - Two elastic pools: "PoolA" and "PoolB" - Target group using…

Azure SQL Database
asked 2026-01-29T10:58:12.1766667+00:00
Deyvid Todorov 10 Reputation points
answered 2026-02-03T14:14:35.5966667+00:00
Deyvid Todorov 10 Reputation points
1 answer

How does Azure SQL Managed Instance work with Private Endpoint?

I am using Azure SQL Managed Instance with Private Endpoint enabled, and we would like clarification on the networking requirement. Even when connecting through Private Endpoint, Microsoft documentation and troubleshooting guidance indicate that network…

Azure SQL Database
asked 2026-02-03T11:05:54.8066667+00:00
Julie 120 Reputation points
answered 2026-02-03T12:28:49.34+00:00
Marcin Policht 75,830 Reputation points MVP Volunteer Moderator
0 answers

How to migrate from Azure SQL Database to Azure SQL Managed Instance

We have a around 100 databases in Azure SQL database on one logical sql server in one elastic pool. The database range from ~5GB to 400GB in size. We want to migrate all databases to Azure SQL Managed Instance due to reasons like better cross-database…

Azure SQL Database
asked 2026-02-03T10:42:55.42+00:00
Georg Sieber 5 Reputation points
commented 2026-02-03T11:09:21.69+00:00
Pilladi Padma Sai Manisha 3,210 Reputation points Microsoft External Staff Moderator
2 answers One of the answers was accepted by the question author.

Get-AzMaintenancePublicConfiguration timeout

Hello, I have some problems with Get-AzMaintenancePublicConfiguration. Sometimes it works perfectly fine, but often it times out. Do you have any advice? Code: $MaintenanceConfiguration = "SQL_NorwayEast_MI_2" $MaintenanceConfig =…

Azure SQL Database
asked 2025-12-04T08:35:07.5866667+00:00
Julie 120 Reputation points
commented 2026-02-03T10:14:57.34+00:00
Julie Gabriella Nicolaisen 0 Reputation points
3 answers

Azure SQL Database Query editor SQL server authentication is not working??

I've logged in to my Azure SQL Database many times in the past via the Query Editor SQL Server Authentication... now when I try to login it just freezes... greyed out... no error messages, just not doing anything??

Azure SQL Database
asked 2026-01-29T22:29:16.3133333+00:00
Bob Lowe 10 Reputation points
commented 2026-02-02T21:45:43.42+00:00
Erland Sommarskog 132K Reputation points MVP Volunteer Moderator
1 answer

Unable to connect to my Azure database - Your refresh token has expired

HI team, I am trying to connect to my Azure database using Sql server management studio and is receiving the error. Your refresh token has expired. Can you please help me how to get around this. Error message logs: TITLE: Microsoft SQL Server Management…

Azure SQL Database
asked 2026-02-02T13:17:36.4266667+00:00
Vidhi Jamar 0 Reputation points
answered 2026-02-02T20:33:30.74+00:00
Alberto Morillo 35,411 Reputation points MVP Volunteer Moderator
4 answers

How much disk space is needed for a Transaction Log (T‑Log) backup for a 1.91 TB database?

Recently, we changed some SQL databases on VM EETAZ1-BHL-ERPL from Simple to Full Recovery Model. Following this, we triggered a full database backup. We have a SQL backup policy configured where transaction logs are backed up every 15 minutes. However,…

Azure SQL Database
asked 2026-01-30T12:51:58.33+00:00
Raju Kothapally 10 Reputation points
answered 2026-01-30T22:49:13.0866667+00:00
Erland Sommarskog 132K Reputation points MVP Volunteer Moderator
2 answers

New-AzSqlInstance skuname bug?

Hello, I have som trouble with the New-AzSqlInstance cmdlet. I want to provision a Managed Instance with Business Critical - Premium-series - Memory Optimized, but it's always set to General Purpose. I use following SKU -Sku @{ Name =…

Azure SQL Database
asked 2026-01-30T12:36:35.2966667+00:00
Julie 120 Reputation points
answered 2026-01-30T14:18:04.49+00:00
Manoj Kumar Boyini 5,410 Reputation points Microsoft External Staff Moderator
2 answers One of the answers was accepted by the question author.

Update-AzSqlInstanceVulnerabilityAssessmentSetting error

Hello, I am having some trouble with this cmdlet Update-AzSqlInstanceVulnerabilityAssessmentSetting when configuring vulnerability assessment for a Azure SQL Managed Instance. For context I have a User-assigned Managed Identity set as primary identity…

Azure SQL Database
asked 2026-01-15T13:07:18.0833333+00:00
Julie 120 Reputation points
edited a comment 2026-01-30T12:37:59.88+00:00
Julie 120 Reputation points
1 answer

Users facing issue with archived data retrieval issue on Azure database

Users facing issue with archived data retrieval issue on Azure database, It's taking very long time to retrieve data.

Azure SQL Database
asked 2026-01-30T10:10:47.7366667+00:00
Ramesh Banoth 0 Reputation points
answered 2026-01-30T10:22:22.86+00:00
Pilladi Padma Sai Manisha 3,210 Reputation points Microsoft External Staff Moderator
1 answer

when I am trying to build distributed availability group in azure portal, I am not able to select size as it's not coming any one that is available in zone1, though I have not mentioned zone1

when I am trying to build distributed availability group in azure portal, I am not able to select size as it's not coming any one option that is available in zone1, though I have not mentioned zone1 anywhere while setting up the high availability

Azure SQL Database
asked 2026-01-30T06:28:03.51+00:00
Mandal, Jayita (Cognizant) 0 Reputation points
commented 2026-01-30T09:27:25.8+00:00
Pilladi Padma Sai Manisha 3,210 Reputation points Microsoft External Staff Moderator
1 answer

My WebApp cant connect to a system managed identity SQL Database, what am I doing wrong?

I can access my web application that uses Entra ID as its authentication feature. I run locally a db without a problem but when I try to access a System Assigned SQL Database feature in the cloud i get a HTTP ERROR 500. What am I doing wrong. Moderator:…

Azure SQL Database
asked 2026-01-15T16:09:44.0233333+00:00
Humberto Elizondo 0 Reputation points
commented 2026-01-30T07:05:00.5733333+00:00
Manoj Kumar Boyini 5,410 Reputation points Microsoft External Staff Moderator
2 answers

Connectivity Issue

misleading Azure SQL Database- sql server version when i am connected through SSMS on my local laptop in oject explorer showing me the number 12.0.0 something which is defined as sql server version

Azure SQL Database
asked 2026-01-27T21:22:02.5633333+00:00
Shaheer Ahmad 0 Reputation points
commented 2026-01-29T15:28:52.11+00:00
VRISHABHANATH PATIL 5,175 Reputation points Microsoft External Staff Moderator
3 answers

Azure Sql Database fails to consistently pause even after long periods of inactivity

Azure Serverless database is set to auto-pause after 15 minutes of inactivity. DB fails to consistently pause even after long periods of inactivity. Intermittent messages about restart, but pause messages are very inconsistent. Status "online"…

Azure SQL Database
asked 2026-01-29T13:55:56.3666667+00:00
John Grady 0 Reputation points
answered 2026-01-29T13:58:38.85+00:00
Manoj Kumar Boyini 5,410 Reputation points Microsoft External Staff Moderator