6,836 questions with Azure SQL Database tags

Sort by: Updated
2 answers

Unable to delete Azure SQL Database + Server due to RBAC — how to disable network access as a workaround?

I’m trying to clean up Azure resources but neither I nor anyone on my team has permission to delete an Azure SQL Server and SQL Database inside a specific Resource Group. Since deletion is blocked, I’d like guidance on: What exact RBAC…

Azure SQL Database
asked 2026-04-29T16:21:56.6833333+00:00
Ragunath Gunasekaran 20 Reputation points Microsoft Employee
commented 2026-04-30T03:46:01.0666667+00:00
SAI JAGADEESH KUDIPUDI 2,525 Reputation points Microsoft External Staff Moderator
3 answers One of the answers was accepted by the question author.

Azure Database Link Server

On the on-prem SQL server we can sue link server to connect to the table in different database. Can we make simillar way to connecting between table on the on-prem to azure sql db?

Azure SQL Database
asked 2026-04-23T12:34:32.5533333+00:00
Handian Sudianto 6,966 Reputation points
accepted 2026-04-30T01:47:53.12+00:00
Handian Sudianto 6,966 Reputation points
3 answers

Pricing for Azure SQL Managed Instance Pool

Hello, If we cretae an Azure SQL Managed Instance Pool but no instance; will there still be any charges for the compute? When we try to create it on Azure portal, it shows cost estimation as zero, no matter how many cores we choose. Regards,

Azure SQL Database
asked 2026-04-23T08:55:24.7333333+00:00
Riaz 0 Reputation points
commented 2026-04-29T17:37:12.5066667+00:00
Suchitra Suregaunkar 13,210 Reputation points Microsoft External Staff Moderator
1 answer

Azure SQL Database automatically reverting to previous pricing tier and restoring after deletion

I am experiencing an issue with an Azure SQL Database where changes I make do not persist. The database was originally configured with the pricing tier General Purpose: Gen5, 2 vCores. I attempted to downscale it to the Basic tier, and the change was…

Azure SQL Database
asked 2026-04-29T07:48:32.9133333+00:00
Abuzar Khan 0 Reputation points
answered 2026-04-29T10:35:23.43+00:00
SAI JAGADEESH KUDIPUDI 2,525 Reputation points Microsoft External Staff Moderator
3 answers

Azure SQL server DB is not pausing automatically even though there are no active connections.

Azure SQL server DB is not pausing automatically even though there are no active connections. And its costing us heavy price. Can someone please help me out with solution and will Azure refund the amount?

Azure SQL Database
asked 2026-04-23T08:38:28.69+00:00
Gururaj Karthik 0 Reputation points
commented 2026-04-29T05:15:01.14+00:00
Saraswathi Devadula 15,940 Reputation points Microsoft External Staff Moderator
1 answer

Azure Recovery Service Vault | Move Sql Database

Hello everyone, I need to move the backup of sql databases from a recovery service vault to another. I know that we cannot move data but is there the possibility to preserve backup on the old vault? Does it apply the soft delete state after moving or…

Azure SQL Database
asked 2026-04-21T11:06:47.8666667+00:00
Andrea Longhitano 180 Reputation points
commented 2026-04-28T23:01:44.44+00:00
Santhosh Kumar Machukuri 0 Reputation points Microsoft External Staff Moderator
0 answers

How to enable connection witrh ms entra id using ssms and azure sql db

I am trying to connect to the sql server using ms entra managed identity but it isn't working. I've exhausted every path that I know to attempt to make this work. I am also trying to create databases on this sever and they keep failing.

Azure SQL Database
asked 2026-04-23T22:10:13.0433333+00:00
Comfort Olorunlero 0 Reputation points Microsoft Employee
commented 2026-04-28T20:41:32.8+00:00
Erland Sommarskog 133.9K Reputation points MVP Volunteer Moderator
1 answer One of the answers was accepted by the question author.

Impact to SQL Server access when moving Subscription and SQL Server Database Resources

I am about to have Microsoft move a Subscription and all of its resources from one Account to another. The SQL Server Databases are constantly being accessed via direct calls by my customers using SELECT, INSERT, UPDATE, and DELETE SQL Statement. Their…

Azure SQL Database
asked 2026-04-28T16:24:13.5966667+00:00
Glenn Seehausen 20 Reputation points
accepted 2026-04-28T18:18:46.7366667+00:00
Glenn Seehausen 20 Reputation points
2 answers

Some tables and views timing out in Power Apps connecting to Azure SQL Server

Hi Today we've been experiencing a timeout issues in a Power App which connects to Azure SQL Server. Below is the error message on one of the queries. This connection has been setup for roughly 3 years without issues but today these errors. Note that…

Azure SQL Database
asked 2026-04-21T15:58:01.91+00:00
AY 36 Reputation points
commented 2026-04-28T11:55:40.8433333+00:00
SAI JAGADEESH KUDIPUDI 2,525 Reputation points Microsoft External Staff Moderator
1 answer One of the answers was accepted by the question author.

Azure Managed Instance - Metrics - Storage Space Used Percent

Is there a built in metric for Storage Space Used Percent for Azure Managed Instance? If not, can this be added as a feature? I know that on Azure SQL DB, there is dataspace used percent metric available.

Azure SQL Database
asked 2026-04-28T08:30:27.5266667+00:00
Conray Quek 20 Reputation points
accepted 2026-04-28T08:31:04.6066667+00:00
Conray Quek 20 Reputation points
2 answers

Problemi performance DB dopo attività Microsoft del 21/04

Salve, il 21 Aprile microsoft ha effettuato delle attività sul Database di una nostra app di Produzione, da quel momento in poi le risorse del database e le performance del database sono peggiorate. Si nota un rallentamento e un’occupazione significativa…

Azure SQL Database
asked 2026-04-25T06:34:04.41+00:00
Roberto Marino 0 Reputation points
answered 2026-04-27T13:16:25.4266667+00:00
Roberto Marino 0 Reputation points
3 answers One of the answers was accepted by the question author.

Azure SQL: Adding a new data sync group fails

I try to add a new data sync group (currently no exist). However, i get the error Failed to perform data sync operation: Cannot find the user 'DataSync_executor', because it does not exist or you do not have permission. Creating certificate Creating…

Azure SQL Database
asked 2026-04-20T13:07:29.79+00:00
Georg Sieber 45 Reputation points
accepted 2026-04-27T12:40:33.14+00:00
Georg Sieber 45 Reputation points
2 answers

After exsauhsting SQLServer Free tier, even after upgrading tier the database is blocked

I had a free tier on my sqlserver database i've used all resources on it and the db stopped which is expected. I placed a keep paying after free tier resources have been used but it's not applying. I also tried upgrading to a basic tier but when i…

Azure SQL Database
asked 2026-04-26T12:09:52.47+00:00
Daichi 21 Reputation points
commented 2026-04-27T04:31:14.74+00:00
Saraswathi Devadula 15,940 Reputation points Microsoft External Staff Moderator
2 answers

Stop Azure SQL imports into Log Analytics

What are the exact click by click steps to I stop Azure SQL imports into Log Analytics? I have this info below, but I need more direction to determine if Azure SQL is what is writing excessively to Log Analytics and I need exact directions on how to stop…

Azure SQL Database
asked 2026-04-20T13:55:54.51+00:00
Jeff Cochand 0 Reputation points
commented 2026-04-24T15:13:51.8866667+00:00
Santhosh Kumar Machukuri 0 Reputation points Microsoft External Staff Moderator
3 answers

Azure SQL Database Query Performance, misleading as it includes primary and standby data

Query Performance is including information for primary and secondary (note this is a business critical read-only replica, not a geo). Take a query ID provided, go to query store, it shows on Secondary, not Primary. This gives misleading information as…

Azure SQL Database
asked 2026-04-09T15:16:48.2833333+00:00
Nancy Wotawa 0 Reputation points
answered 2026-04-24T05:47:57.1866667+00:00
Anuradha 0 Reputation points Microsoft Employee
2 answers

how to allow others to connect to database

doing a group project, first time using azure DB, my group cannot connect to my set up database with my sql authentication user and password. I have set firewall rules with their IP, I've assigned roles, they just cant log in for whatever reason. No…

Azure SQL Database
asked 2026-04-22T17:18:08.2866667+00:00
helpm 0 Reputation points
commented 2026-04-23T20:24:32.9833333+00:00
Manoj Kumar Boyini 13,360 Reputation points Microsoft External Staff Moderator
2 answers

Database transfer to my local system

I need to transfer a database from Azure to my local system, but I’m facing some issues. Could you please help me with this?

Azure SQL Database
asked 2026-04-22T07:26:59.3766667+00:00
Ajay Prajapati 0 Reputation points
commented 2026-04-23T20:23:32.49+00:00
Manoj Kumar Boyini 13,360 Reputation points Microsoft External Staff Moderator
1 answer One of the answers was accepted by the question author.

Unable to disable Microsoft Entra-only authentication on SQL Managed Instance. Met with InvalidParameterValue error

We are unable to disable Microsoft Entra-only authentication on a SQL Managed Instance. Behavior: The API accepts the PUT request (HTTP 202 Accepted) but the async operation fails with:…

Azure SQL Database
asked 2026-04-15T20:05:34.18+00:00
Daniel Sanchez 20 Reputation points Microsoft Employee
accepted 2026-04-23T20:20:06.32+00:00
Daniel Sanchez 20 Reputation points Microsoft Employee
1 answer

Azure SQL Managed Instance database not visible in sys.databases but name still appears to exist

We ran into an issue on Azure SQL Managed Instance after a database drop operation. The database no longer appears in sys.databases, so from the normal catalog view it looks like it has already been removed. However: CREATE DATABASE using the same name…

Azure SQL Database
asked 2026-04-14T16:04:38.1133333+00:00
João Paixão 0 Reputation points
commented 2026-04-23T20:01:21.6866667+00:00
Manoj Kumar Boyini 13,360 Reputation points Microsoft External Staff Moderator
2 answers

Why does my Azure SQL Database with auto-pause enabled show recurring CPU spikes every 5 minutes overnight and is it generating billable compute time?

I have two Azure SQL Databases across two separate development stages: Dev 1 (serverless tier, auto-pause enabled) and Dev 2 (auto-pause disabled). Both databases are configured identically apart from the auto-pause setting. Both receive traffic from…

Azure SQL Database
asked 2026-04-16T20:57:22.55+00:00
Daniel-4204 230 Reputation points
answered 2026-04-22T06:25:52.2666667+00:00
Saraswathi Devadula 15,940 Reputation points Microsoft External Staff Moderator