6,577 questions with Azure SQL Database tags

Sort by: Updated
0 answers

Setting UAMI and Primary Identity Managed Instance timeout

Hello, I want to set identites after provisioning Azure SQL Managed Instance with Azure Powershell. First I set my automation-umi and a unique umi per instance to UAMI, then I set primary to the automation-umi. The automation-umi has Directory Reader…

Azure SQL Database
asked 2025-10-28T12:59:30.4633333+00:00
Julie 40 Reputation points
commented 2025-10-31T16:23:48.08+00:00
Mahesh Kurva 9,725 Reputation points Microsoft External Staff Moderator
0 answers

Reason: An instance-specific error occurred while establishing a connection to SQL Server. Connection was denied because Deny Public Network Access is set to Yes. For more information,

Reason: An instance-specific error occurred while establishing a connection to SQL Server. Connection was denied because Deny Public Network Access is set to Yes. For more information,

Azure SQL Database
asked 2025-10-31T09:03:23.81+00:00
Gunti GUNTI 0 Reputation points
commented 2025-10-31T15:12:14.3133333+00:00
Mahesh Kurva 9,725 Reputation points Microsoft External Staff Moderator
1 answer

we accidently deleted sql server and database in azure , how to recover

We accidentally deleted SQL Server and the database in Azure yesterday, so we want to recover it .we want the backup of SQL Server and the database because it contains essential data

Azure SQL Database
asked 2025-10-31T08:28:00.42+00:00
Atharv Atre 0 Reputation points
commented 2025-10-31T14:58:56.8+00:00
Mahesh Kurva 9,725 Reputation points Microsoft External Staff Moderator
0 answers

I need to get my data off of azure sql or help with billing

Azure has been over charging my organization to the point we need to pull our database off and go with someone else. When we signed up we didn't know we had General Purpose (Most budget friendly) server tier enabled and Azure has been taking around $400…

Azure SQL Database
asked 2025-10-31T14:21:07.0433333+00:00
Michael Neumeier 0 Reputation points
0 answers

Azure Fabric : user user/password identification

Hello, Form my application, I need to user user/password identification to login to Azure Fabric. Any idea how should I set this kind of connection? Thank you, Daniela

Azure SQL Database
asked 2025-10-31T10:33:08.6266667+00:00
BOAMBA, Daniela 21 Reputation points
edited a comment 2025-10-31T13:59:21.3766667+00:00
Manoj Kumar Boyini 415 Reputation points Microsoft External Staff Moderator
1 answer One of the answers was accepted by the question author.

Need to revert a Hyperscale Database to General Purpose

During the process of testing if Hyperscale DB's was viable for one of my production databases, we made and error and did not revert the database to General Purpose. I understand that the 45 day grace period has expired but I am hoping there is a path to…

Azure SQL Database
asked 2025-10-30T20:22:09.34+00:00
William VanWart 0 Reputation points
accepted 2025-10-31T13:33:50.1466667+00:00
William VanWart 0 Reputation points
1 answer

Why do we get error 'Database already exists' during recovery on new sql managed instance. (false-positive)

First of all. This is more a question to see if we can just ignore this error because everything works perfectly except for the false error. (It took a few hours to realize this). Scenario: We recover a .bak (located in a Storage Account) into a Azure…

Azure SQL Database
asked 2025-10-30T11:30:52.0833333+00:00
Kjell Bulcke 0 Reputation points
commented 2025-10-31T06:58:56.7133333+00:00
Kjell Bulcke 0 Reputation points
3 answers

I have a azure ci/cd pipeline and it failed due to json index issue not supported. I checked my project and there is no json index in my database project

The error message is :##[error]*** An error occurred during deployment plan generation. Deployment cannot continue. ##[error]Error SQL72018: SqlJsonIndex could not be imported but one or more of these objects exist in your…

Azure SQL Database
asked 2025-10-20T21:43:28.97+00:00
JingJing Gao 5 Reputation points
edited an answer 2025-10-30T18:24:34.5733333+00:00
TechnicianTate 6 Reputation points
2 answers One of the answers was accepted by the question author.

Wrong user/pass in azure powershell when granting permissions to the managed identity for SQL access

Hi, I am uploading an app that uses sql to azure. I have already uploaded the app, when accesing its URL I get a "App is running and waiting for content" In order to provide an sql db to the app, i am following this tutorial: …

Azure SQL Database
asked 2025-10-29T15:42:05.6233333+00:00
sdf sdfgs 20 Reputation points
accepted 2025-10-30T16:43:42.22+00:00
sdf sdfgs 20 Reputation points
0 answers

Since yesterday night we are experiencing 100% DTU that cause our website to ne not responsive

Since yesterday night we are experiencing 100% DTU that cause our website to ne not responsive, we suspect a possbile attack, because if we bring down the application the traffic on DB decrease, as soon as we bring it back the problem starts again.…

Azure SQL Database
asked 2025-10-28T07:14:05.2066667+00:00
Napoli Magazine Srl 0 Reputation points
commented 2025-10-30T15:25:30.0333333+00:00
VRISHABHANATH PATIL 1,380 Reputation points Microsoft External Staff Moderator
1 answer

Finding & fixing Azure resource using Azure SQL Database 2014-04-01 APIs

Hello. I'm using Azure and have been getting the following email sent to me multiple times: "Required action To avoid potential service disruptions, upgrade any Azure SQL Database resources that use version 2014-04-01 APIs to a newer stable…

Azure SQL Database
asked 2025-10-10T07:54:26.1266667+00:00
Mikael Karlgren 20 Reputation points
answered 2025-10-30T11:35:26.0166667+00:00
Sina Salam 25,931 Reputation points Volunteer Moderator
0 answers

How do I enable database zone redundancy on my Azure SQL DB

I am running into the current error. I am in zone East US and on a serverless DB. I don't see anywhere where I can't update to 'Yes'. Can you let me know what issue I am running into?

Azure SQL Database
asked 2025-10-27T17:11:10.36+00:00
Darren Gourley 0 Reputation points
commented 2025-10-30T10:52:21.0633333+00:00
Kalyani Kondavaradala 3,310 Reputation points Microsoft External Staff Moderator
2 answers

Want to upgrade any Azure SQL Database resources

We want to upgrade any Azure SQL Database resources that use version 2014-04-01 APIs to a newer stable version by 31 October 2025 to avoid potential service disruptions. Please connect us with someone who can provide guidance.

Azure SQL Database
asked 2025-10-24T09:39:36.5133333+00:00
NYC Admin 0 Reputation points
answered 2025-10-30T09:31:22.7133333+00:00
Sina Salam 25,931 Reputation points Volunteer Moderator
4 answers

Failed to authenticate the user NT Authority\Anonymous Logon in Active Directory (Authentication=ActiveDirectoryIntegrated).

I'm working on configuring Azure SQL Server authentication using Microsoft Entra Integrated. Here’s my setup: I have an Azure SQL Server with an active database. My laptop is connected to Azure AD. I’ve opened SQL Server Management Studio (SSMS),…

Azure SQL Database
Microsoft Security | Microsoft Entra | Microsoft Entra ID
SQL Server | Other
asked 2024-07-29T14:52:57.4433333+00:00
Sam H 5 Reputation points
answered 2025-10-29T21:23:28.2033333+00:00
grover110 0 Reputation points
2 answers

Managed Identity with Azure Linked Server

Hello all, I am curious to know if it's possible to create Azure SQL linked server with managed identity from an on-premises SQL Server. I have a situation that prevents using SQL account authentication for linked servers. Will appreciate any input,…

Azure SQL Database
asked 2025-10-27T11:25:25.7333333+00:00
Babawale Dawodu 110 Reputation points
answered 2025-10-29T14:14:06.76+00:00
Kalyani Kondavaradala 3,310 Reputation points Microsoft External Staff Moderator
2 answers

make sure the SQL Database firewall allows the integration runtime to access

Cannot connect to SQL Database. Please contact SQL server team for further support. Server: 'xxxxxxxxxx.database.windows.net', Database: 'master', User: 'xxxxxxxxx'. Check the linked service configuration is correct, and make sure the SQL Database…

Azure SQL Database
asked 2025-10-27T08:15:14.98+00:00
Gunti GUNTI 0 Reputation points
edited a comment 2025-10-29T12:15:07.6+00:00
Kalyani Kondavaradala 3,310 Reputation points Microsoft External Staff Moderator
0 answers

Enabling MARS (Multiple Active Result Sets) in Azure Sql Connection string results in failure with Private Endpoints/Azure Firewall

We have an app service running from UK South, that talks to an Azure Sql Database over in North Europe. We have vnet integration on the app service on a virtual network in UK South, the private endpoints vnet/subnet resides on North EU and requests are…

Azure SQL Database
Azure Firewall
Azure Firewall
An Azure network security service that is used to protect Azure Virtual Network resources.
828 questions
Azure Private Link
Azure Private Link
An Azure service that provides private connectivity from a virtual network to Azure platform as a service, customer-owned, or Microsoft partner services.
562 questions
asked 2021-10-22T08:45:56.967+00:00
John 1 Reputation point
commented 2025-10-29T10:46:15.8333333+00:00
Pete Luetchford 21 Reputation points
0 answers

Azure SQL server giving CVE errors when we did Vulnerability scan through Roboshadow application.

Azure SQL server giving CVE errors when we did Vulnerability scan through Roboshadow application.1434 and 1433 ports are giving most of the CVE's related to patch updates. But our database server is DTU based and PaaS. How This can be justified? . Kindly…

Azure SQL Database
asked 2025-10-28T07:49:38.93+00:00
Siva Kumar Reddy 0 Reputation points
commented 2025-10-29T02:02:59.01+00:00
VRISHABHANATH PATIL 1,380 Reputation points Microsoft External Staff Moderator
1 answer

Which Hyperscale configuration makes the most sense for us?

Hello, I am trying to determine which Hyperscale DB configuration would make the most sense for us based on both cost and performance. Our current configuration is set to Serverless, 0.75-6 vCores, 2.25-18GB RAM. We are spending on average…

Azure SQL Database
asked 2025-10-28T16:28:26.3933333+00:00
Shea Martin 40 Reputation points
commented 2025-10-28T20:48:48.2966667+00:00
Shea Martin 40 Reputation points
1 answer

Best Approach to Avoid Duplicates When Loading Cumulative Monthly Orders Daily & Handling Month Transitions

Question: Hi all, I am working on a data warehouse project where we receive orders files on a monthly basis. Each file contains all orders for that month, and the file grows daily as new orders are added. Currently, we load this data into a raw table…

Azure SQL Database
asked 2025-10-24T07:39:08.7233333+00:00
YERNAIDU SIRAPARAPU 125 Reputation points
commented 2025-10-28T17:09:38.3766667+00:00
Mahesh Kurva 9,725 Reputation points Microsoft External Staff Moderator