510 questions with Azure SQL Database tags

Sort by: Updated
0 answers

Problem getting resources deleted

Deleted SQL Managed Instance but associated VNET, Virtual Cluster, NSG and Routing table not getting deleted. The dependency of SQL managed instance isn't getting removed and this is causing the problem. The SQL managed instance however is deleted but…

Azure SQL Database
asked 2025-07-01T15:56:29.5166667+00:00
Yash Juneja 0 Reputation points
commented 2025-07-16T17:47:01.0633333+00:00
Mahesh Kurva 5,700 Reputation points Microsoft External Staff Moderator
0 answers

pyodbc programming error: Encountered exception when enlisting connection

Hi, I have an app hosted on azure app service that is using a managed identity configured with azure sql db. The app was working fine but today I saw the following error message in the application logs and couldn't figure out what might be causing this:…

Azure SQL Database
asked 2025-07-14T15:55:27.33+00:00
Amit Yadav 0 Reputation points
commented 2025-07-16T17:17:38.15+00:00
Mahesh Kurva 5,700 Reputation points Microsoft External Staff Moderator
0 answers

Connection was denied since Deny Network Access after adding private endpoint

Reason: An instance-specific error occurred while establishing a connection to SQL Server. Connection was denied since Deny Public Network Access is set to Yes…

Azure SQL Database
asked 2025-07-09T04:27:23.1666667+00:00
21887231 0 Reputation points Microsoft External Staff
commented 2025-07-11T03:24:13.2166667+00:00
Saraswathi Devadula 7,875 Reputation points Microsoft External Staff Moderator
0 answers

SQL Managed Instance to Azure SQL DB Replication Failing Out of now where.

Seeing the error on my SQL managed instance: 2025-07-08 22:25:44.939 The remote server "ifpsql3.b37eef63d7.database.windows.net" does not exist, or has not been designated as a valid Publisher, or you may not have permission to see available…

Azure SQL Database
asked 2025-07-08T22:56:52.5566667+00:00
David Hancock 0 Reputation points
commented 2025-07-10T20:57:39.8333333+00:00
Oury Ba-MSFT 21,016 Reputation points Microsoft Employee Moderator
0 answers

upgrade any Azure SQL Database resources that use version 2014-04-01 APIs to a newer stable version by 31 October 2025.

HOw to upgrade any Azure SQL Database resources that use version 2014-04-01 APIs to a newer stable version by 31 October 2025.

Azure SQL Database
asked 2025-07-07T14:25:52.31+00:00
Andy Knaff 0 Reputation points
commented 2025-07-09T17:18:29.4166667+00:00
Mahesh Kurva 5,700 Reputation points Microsoft External Staff Moderator
0 answers

Unknown infrastructure error when creating the recommended index on Azure SQL

Hi! I received "Unknown infrastructure error" when executed one of the recommended index queries in the Azure portal for an Azure SQL database. Is there any way to re-run the recommended index script or find out why the error occurred? After…

Azure SQL Database
asked 2021-02-18T15:53:43.037+00:00
ALos 11 Reputation points
commented 2025-07-02T05:12:04.34+00:00
Saju Prabhakaran 0 Reputation points
0 answers

Some values in a table are not being restored after restoring a SQL Managed Instance in Azure

Hi, I have a .bak backup of my database. When I restore this locally using SQL Server Management Studio 21 I can see that all the data is restored correctly. Particularly a column called Description in TableD which is defined as (NVARCHAR(1024), NULL).…

Azure SQL Database
asked 2025-07-01T13:28:41.9566667+00:00
Yusuf Rafiq 0 Reputation points
commented 2025-07-02T03:34:20.7233333+00:00
Saraswathi Devadula 7,875 Reputation points Microsoft External Staff Moderator
0 answers

Was maliciously hacked, Database deleted, and cannot figure out how to create a support ticket.

I can't figure out how to get a support ticket entered. I just keep getting documentation answer for how to restore sql, but we have been maliciously hacked and they deleted our entire database and are signing in to our backup storage to delete that... …

Azure SQL Database
asked 2025-06-26T14:44:08.2233333+00:00
Rick Stephenson 0 Reputation points
commented 2025-06-30T09:03:06.0933333+00:00
Mahesh Kurva 5,700 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
commented 2025-06-27T18:41:28.24+00:00
Sai Raghunadh M 4,640 Reputation points Microsoft External Staff Moderator
0 answers

SQL Auditing Logs Not Reaching Log Analytics or Blob for ppeid-sql-server

Hello Azure Support, We are experiencing an issue where audit logs from our SQL Server instance are not being delivered to Log Analytics or Blob Storage, despite all diagnostic settings being correctly configured. 🧪 Repro Steps: Enabled …

Azure SQL Database
asked 2025-06-23T16:55:53.14+00:00
Robert Wilson 0 Reputation points
commented 2025-06-25T17:00:00.7133333+00:00
Sai Raghunadh M 4,640 Reputation points Microsoft External Staff Moderator
0 answers

SQL Database Business Critical o Hyperscale

Hello How are you? I would like your help with some questions and doubts I have regarding changing the tier of some SQL databases in Azure. I am considering changing the tier of some of the databases with the highest requirements, queries, and workload…

Azure SQL Database
asked 2025-06-23T14:11:02.5166667+00:00
Fernando Gutierrez 305 Reputation points
commented 2025-06-25T16:09:17.4+00:00
Mallaiah Sangi 1,145 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-24T01:15:48.7466667+00:00
Vijayalaxmi Kattimani 3,410 Reputation points Microsoft External Staff 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
0 answers

Recon and Retry

We are working on a large-scale enterprise migration project where we are ingesting data from an on-premises DB2 Snapshot (point-in-time extract) into Azure SQL Hyperscale using Azure-native components. The architecture includes: Source: IBM DB2…

Azure SQL Database
asked 2025-05-28T14:12:03.19+00:00
Janice Chi 320 Reputation points
commented 2025-06-12T14:36:16.51+00:00
PratikLad 1,830 Reputation points Microsoft External Staff Moderator
0 answers

Azure vNet suport subnet injection doesn't work.

I followed the documentation to complete the config but the network connectivity seem not working. https://learn.microsoft.com/en-us/power-platform/admin/vnet-support-setup-configure I try to connect to the SQL managed instance from the Power app, the…

Azure SQL Database
asked 2025-05-26T02:12:27.6266667+00:00
Zhaofeng Yu 0 Reputation points
commented 2025-06-04T23:52:01.6566667+00:00
Oury Ba-MSFT 21,016 Reputation points Microsoft Employee Moderator
0 answers

How can I reach Azure 24 x 7 Enterprise Pay Per Incident support by phone

How can I reach Azure 24 x 7 Enterprise support by phone I have an urgent business need for support ASAP

Azure SQL Database
asked 2025-05-16T03:52:48.8433333+00:00
Bob Kiefer 21 Reputation points
edited the question 2025-05-16T06:13:09.88+00:00
Sai Raghunadh M 4,640 Reputation points Microsoft External Staff Moderator
0 answers

My SQL Azure VM seems to have been attacked by Ransomware and all files are missing and/or corrupted

Logged into my Azure SQL VM this morning. The start menu items are almost all gone. SQL Server isn't running any more. My data disks are almost all empty, and what is there file wise all has a .mkp extension. How do I go back to its original working…

Azure SQL Database
asked 2025-04-28T14:51:04.52+00:00
Albertus van Zyl 0 Reputation points
edited the question 2025-05-08T09:08:03.6666667+00:00
Prrudram-MSFT 28,366 Reputation points Microsoft Employee Moderator
0 answers

SQL DB missing from portal

Hi, I'm hoping someone can help me with what is most likely an admin problem rather than tech. We don't use Azure very much but have an SQL DB running for a piece of software used across out company. Last week we noticed that the DB is missing from the…

Azure SQL Database
asked 2025-05-06T09:36:48.6066667+00:00
Spectra 0 Reputation points
commented 2025-05-08T04:39:57.77+00:00
Mihir Saxena 0 Reputation points Microsoft External Staff Moderator
0 answers

errorCode": "2402 unable to load bulk data using COPY command to table

I am unable to execute COPY command to table . COPY INTO stg.Temp_FctSOSTracking_TPS_India FROM 'https://mfgdasynapseprod01sa.dfs.core.windows.net/landing/RSA/2024-02/2024-02-07/2024-02-07_00:00/fct_sos_details_*.csv' WITH ( FILE_TYPE='CSV', FIRSTROW=2,…

Azure SQL Database
Azure Synapse Analytics
Azure Synapse Analytics
An Azure analytics service that brings together data integration, enterprise data warehousing, and big data analytics. Previously known as Azure SQL Data Warehouse.
5,386 questions
asked 2024-02-07T16:14:10.38+00:00
GUPTA, Mayank 5 Reputation points
commented 2025-05-05T01:38:11.7333333+00:00
Shelly Chen 0 Reputation points
0 answers

Login failed for user '<token-identified principal>'.

Hi, I am suddenly experiencing issues trying to use the query editor preview where it is throwing up this error. I cannot seem to access anything. Microsoft Entra authentication Login failed for user '<token-identified principal>'. Continue as…

Azure SQL Database
asked 2025-04-30T09:24:12.6366667+00:00
Thomas 0 Reputation points
commented 2025-05-01T07:36:00.8133333+00:00
Saraswathi Devadula 7,875 Reputation points Microsoft External Staff Moderator