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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
 
	
			  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
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 Private Link
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
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
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…