6,316 questions with Azure SQL Database tags

Sort by: Updated
1 answer

"DBCC SHRINKFILE for data files is not supported in a Hyperscale database" error trying to shrink db

I get the following when attempting to use either SHRINKFILE or SHRINKDATABASE: "DBCC SHRINKFILE for data files is not supported in a Hyperscale database when the database is not encrypted or protector change is in progress. Enable transparent…

Azure SQL Database
asked 2025-06-13T18:15:45.7566667+00:00
Nathan Allan 0 Reputation points
edited an answer 2025-06-23T07:56:20.74+00:00
PratikLad 1,665 Reputation points Microsoft External Staff Moderator
0 answers

AzureSQL: Error executing a cross database query on the server with private endpoint

Hello, I'm trying to execute a cross database query on Azure SQLServer with multiple databases and run into error below: Any clue on how to go above resolving this? Msg 46832, Level 16, State 3, Line 93 An error occurred while establishing connection to…

Azure SQL Database
asked 2025-06-20T23:27:34.55+00:00
Sachin S 26 Reputation points
edited a comment 2025-06-23T04:59:52.27+00:00
Sai Raghunadh M 4,300 Reputation points Microsoft External Staff Moderator
1 answer

Unexpected costs in Azure Database

Hi Azure community, I recently set up a free tier student account using which I have created a SQLDB in the UAE region. While the cost per month according to documentation says 6 USD, I am being charged around 83 USD. There are no other resources…

Azure SQL Database
asked 2025-06-21T10:00:09.7333333+00:00
Madihah Anaum (MBA PT Dubai) 0 Reputation points
commented 2025-06-23T01:50:55.1266667+00:00
Mahesh Kurva 4,860 Reputation points Microsoft External Staff Moderator
1 answer One of the answers was accepted by the question author.

How to fix SQL vulnerabilities using baselines?

I have many SQL vulnerabilities in my subscription but when I open them the remediation is very unclear and obscure. It says to add to baseline but I need to know where can I edit the security baseline and what needs to be added/removed from it for each…

Azure SQL Database
asked 2024-02-05T14:36:28.5433333+00:00
Najam ul Saqib 400 Reputation points
commented 2025-06-20T21:53:01.1633333+00:00
Oury Ba-MSFT 20,906 Reputation points Microsoft Employee Moderator
0 answers

Can connect with database using Azure Studio not with ODBC

Please provide the following details to your technical contact: Error Details: The exact error: [Microsoft][ODBC Driver 18 for SQL Server][SQL Server]Failed to authenticate the user '******@highlandfarms.net' in Entra ID (Authentication option is…

Azure SQL Database
asked 2025-06-18T15:33:06.7233333+00:00
Hamish HFL 5 Reputation points
commented 2025-06-20T21:39:58.67+00:00
Fred Hanson 0 Reputation points
1 answer

Cannot connect to Azure SQL server

This morning, we were unable to connect to two of our azure sql servers (UAT and Prod) from an on prem VM, yet we could connect to our 3rd server (DEV). UAT and DEV are on the same subscription in Azure while prod is on a separate sub. Access is…

Azure SQL Database
asked 2025-06-17T19:35:34.3766667+00:00
KH2437 0 Reputation points
commented 2025-06-20T19:20:00.4+00:00
Sai Raghunadh M 4,300 Reputation points Microsoft External Staff Moderator
0 answers

Our Azure SQL DB looks like it's getting hammered. Very HIGH DTU

Since around 7am this morning a database we use for a simple application has started seeing 100% DTU. I doubled it to 800, but still at 100%. Doubled again to 1600, and still having issues. There's hardly any sessions, so what could be causing this…

Azure SQL Database
asked 2025-06-17T14:42:46.5266667+00:00
Paul Smith 0 Reputation points
commented 2025-06-20T17:30:01.79+00:00
Mahesh Kurva 4,860 Reputation points Microsoft External Staff Moderator
1 answer

Automatic tuning is not creating indexes on our SQL database

We have automatic tuning turned on with Create Index ON, but it no longer creates indexes like it used to.

Azure SQL Database
asked 2025-06-04T21:06:09.1066667+00:00
Kevin Hannan 6 Reputation points
commented 2025-06-20T13:38:46.8866667+00:00
PratikLad 1,665 Reputation points Microsoft External Staff Moderator
1 answer

How to get our database running again

Our free monthly allowance has run out, so I've enabled the 'continue using database for additional charges' however the database is still not accessible. How can I get this running again?

Azure SQL Database
asked 2025-06-20T08:46:42.1166667+00:00
Lewis Finn 0 Reputation points
commented 2025-06-20T09:41:49.2+00:00
Erland Sommarskog 121.4K Reputation points MVP Volunteer Moderator
0 answers

My Sql Managed Instance is stuck in a starting

My SQL Managed Instance seems to be stuck in the starting state.

Azure SQL Database
asked 2025-06-18T21:14:56.77+00:00
Lawrence Short 0 Reputation points
commented 2025-06-20T09:03:43.76+00:00
Sai Raghunadh M 4,300 Reputation points Microsoft External Staff Moderator
1 answer

Unable to Reclaim Allocated Space After Shrinking Azure SQL Database

We are experiencing an issue with reclaiming allocated space from our Azure SQL Database (Pass Service)despite running DBCC SHRINKDATABASE. The database in question (db_name) currently shows approximately 300 GB of used space but over 1 TB of allocated…

Azure SQL Database
asked 2025-06-14T14:39:48.0966667+00:00
Dattatray Giramkar 0 Reputation points
commented 2025-06-20T03:43:46.21+00:00
Vijayalaxmi Kattimani 3,170 Reputation points Microsoft External Staff Moderator
0 answers

Azure Sql performance bad on S3 but not S4

On the 10th of June our Database hosted in UK South started consuming all it's DTUs on a certain query. Usually the database would run at up to 20% DTU, but for an unknown reason it's hitting 100%. I scaled up to S4 from S3 and then the database's DTU…

Azure SQL Database
asked 2025-06-18T05:55:40.1233333+00:00
Anthony Argyrou 0 Reputation points
commented 2025-06-20T03:42:35.3566667+00:00
Vijayalaxmi Kattimani 3,170 Reputation points Microsoft External Staff Moderator
3 answers One of the answers was accepted by the question author.

First Connection to Azure SQL FreeDB takes 60 seconds

I created a new Azure SQL Database using the FreeDB option. It's a serverless solution. The first time I run a web application that accesses it, it takes 60 seconds or more to return a result. After the first page, it is much more responsive. However, if…

Azure SQL Database
asked 2024-03-27T21:04:03.28+00:00
Robert Galante 61 Reputation points
answered 2025-06-20T00:44:23.2866667+00:00
Daniel noyn 1 Reputation point
1 answer One of the answers was accepted by the question author.

SQL managed instance stuck on stage 2 of resizing for 12 hours

Hi. I have an SQL Managed Instance that has been stuck on stage 2 of resizing (I adjusted the disk size) for about 12 hours now. Is there anything I can do?

Azure SQL Database
asked 2025-06-19T06:16:19.1466667+00:00
Mark Windle 90 Reputation points
accepted 2025-06-19T10:05:08.19+00:00
Mark Windle 90 Reputation points
1 answer

float value "0.00007136" is stored as "7.136E-05" in azure sql database

I have a table with float column and trying to insert value "0.00007136" but it end up showing as "7.136E-05" I have tried cast float , cast decimal, everything but still it is adding in table like that. I am using simple insert…

Azure SQL Database
asked 2025-06-17T15:06:08.2133333+00:00
Pankaj Joshi 391 Reputation points
commented 2025-06-19T09:03:36.7133333+00:00
Saraswathi Devadula 5,570 Reputation points Microsoft External Staff Moderator
1 answer

About in Ms Azure SQL DBA

#azure training what iaas and paas in azure SQL database administrator This question is related to the following Learning Module

Azure SQL Database
asked 2025-06-16T20:50:16.3633333+00:00
Sagar Kumar Nayak 0 Reputation points
commented 2025-06-18T18:37:57.1466667+00:00
Sai Raghunadh M 4,300 Reputation points Microsoft External Staff Moderator
2 answers

Getting an Access Denied error when accessing a file in Azure Blob Storage

Files have been loaded into a blob container, and through PowerShell, that data has been loaded into the Azure SQL database successfully for over 2 years. As of last week, this process was functioning correctly. Currently encountering an Access Denied…

Azure SQL Database
asked 2025-05-30T17:00:14.79+00:00
IAA Dashboard 0 Reputation points
commented 2025-06-18T09:56:56.78+00:00
Narendra Pakkirigari 475 Reputation points Microsoft External Staff Moderator
2 answers

recover deleted sql server

Hello i have deleted the sql server and the sql db and i need to recover them is that possible?

Azure SQL Database
asked 2025-06-10T19:08:24.6166667+00:00
Alex Bitar 0 Reputation points
commented 2025-06-17T17:59:04.6233333+00:00
Sai Raghunadh M 4,300 Reputation points Microsoft External Staff Moderator
1 answer

Enabling user authentication to connect Access front end to Azure SQL Database

I need to connect/link the tables in Access to an Azure SQL database using ODBC Driver 18 for SQL Server. I am trying to use New Data Source->From Database->From Azure Database to authenticate with either Azure AD Password or Interactive…

Azure SQL Database
Access Development
Access Development
Access: A family of Microsoft relational database management systems designed for ease of use.Development: The process of researching, productizing, and refining new or existing technologies.
907 questions
asked 2024-07-12T16:24:59.9766667+00:00
George Dimitrov 0 Reputation points
commented 2025-06-17T16:29:52.4866667+00:00
Hamish HFL 5 Reputation points
1 answer

External Data Source from Az SQL DB to Az VM with SQL Server

Hi, Is it possible to create an external data source connection from an Azure SQL Database to SQL server running on an Azure VM. I've created the connection to external server (Azure VM) which creates but when I try to query it, it fails CREATE…

Azure SQL Database
asked 2023-08-15T11:14:31.44+00:00
Matt Brooks 1 Reputation point
commented 2025-06-17T14:52:45.4266667+00:00
Chaitanya 0 Reputation points Microsoft External Staff