Azure SQL Database
An Azure relational database service.
6,900 questions
2 answers
Using DAC (Dedicated Admin Connection) with a SQL Server Managed Instance
Hi, Azure SQL Managed instances Is it possible to use DAC with a SQL Managed instance? If so how? Does it need to be on a vm that is within the same vnet as the managed instance? Is it possible to use the DAC from my remote laptop which connects to our…
Azure SQL Database
asked 2026-06-23T13:58:58.5166667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(163.2, 2%, 25%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EDW%3C/text%3E%3C/svg%3E)
Daniel Warne
0
Reputation points
commented 2026-06-27T07:11:23.8466667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(16, 2%, 11%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMK%3C/text%3E%3C/svg%3E)
Manoj Kumar Boyini
17,550
Reputation points Microsoft External Staff
Moderator
3 answers
Copilot Studio – Azure SQL Knowledge Source Connected but Agent Cannot Retrieve Data
Dear reader, I'm integrating an Azure SQL Database as a knowledge source in Copilot Studio, but despite the connection showing as successful and preview data being visible, the agent is unable to retrieve any data when queried. Below are the details and…
Azure SQL Database
Azure SQL Database
An Azure relational database service.
6,900 questions
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(83.2, 68%, 18%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EN%3C/text%3E%3C/svg%3E)
2 answers
Azure SQL API version upgrade notification
Hello Team, We received a notification regarding the retirement of the Azure SQL REST API version 2014-04-01 (effective 30 June 2026), indicating that resources using this API version should be updated. The following advisor resources are reported: …
Azure SQL Database
Azure SQL Database
An Azure relational database service.
6,900 questions
asked 2026-06-23T09:46:21.66+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(76.8, 92%, 17%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ETS%3C/text%3E%3C/svg%3E)
Tikoo, Shivata
0
Reputation points
commented 2026-06-26T07:01:46.6366667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(12.8, 24%, 11%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EPP%3C/text%3E%3C/svg%3E)
Pilladi Padma Sai Manisha
10,765
Reputation points Microsoft External Staff
Moderator
2 answers
Server identity does not have the Microsoft Entra Directory Readers permission.
I'm using a Service Principal that creates an SQL Server with an SMI (System-assigned managed identity) in an Azure DevOps pipeline, and then runs an .sql file with the SQL Server's SMI. I made sure that the SMI has the following permissions in Azure: I…
Azure SQL Database
Azure SQL Database
An Azure relational database service.
6,900 questions
asked 2026-06-18T08:41:48.62+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(182.40000000000003, 83%, 27%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EDM%3C/text%3E%3C/svg%3E)
Daniel Martinez
40
Reputation points
commented 2026-06-26T06:59:32.11+00:00
Pilladi Padma Sai Manisha
10,765
Reputation points Microsoft External Staff
Moderator
1 answer
Facing issue while trying to create Azure SQL DB
Hello, I am attempting to create a new SQL Server but encountering the following error: Your subscription does not have permission to create a server in the chosen region. For the most current information regarding region availability for your…
Azure SQL Database
Azure SQL Database
An Azure relational database service.
6,900 questions
asked 2026-06-24T07:11:14.6866667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(89.60000000000001, 45%, 18%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ENB%3C/text%3E%3C/svg%3E)
nikhil.b
0
Reputation points
commented 2026-06-26T06:54:19.47+00:00
Pilladi Padma Sai Manisha
10,765
Reputation points Microsoft External Staff
Moderator
1 answer
Our alerting system is detecting random resource health issues on production databases hosted on Azure SQL MI
Every now and then production sql databases: At Monday, June 22, 2026 at 12:46:41 AM GMT+10, the Azure monitoring system received the following information regarding your Managed database: We're sorry, we have identified degradation of your database.…
Azure SQL Database
Azure SQL Database
An Azure relational database service.
6,900 questions
asked 2026-06-22T00:25:08+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 61%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EBW%3C/text%3E%3C/svg%3E)
Brett Waymouth Admin
0
Reputation points
edited a comment 2026-06-26T06:44:02.12+00:00
Pilladi Padma Sai Manisha
10,765
Reputation points Microsoft External Staff
Moderator
1 answer
Azure SQL managed instance and API planing and designing questions to fix the latency issue.
I have an application hosted in a single location, but due to latency concerns, the Azure SQL Managed Instance databases are deployed across three regions: the US, India, and Europe. Each region has its own dedicated database. When a user performs…
Azure SQL Database
Azure SQL Database
An Azure relational database service.
6,900 questions
asked 2026-06-25T20:58:49.91+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(176, 99%, 27%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAB%3C/text%3E%3C/svg%3E)
Arunkumar Babu
0
Reputation points
answered 2026-06-25T22:50:06.08+00:00
Erland Sommarskog
135K
Reputation points MVP
Volunteer Moderator
2 answers
Understanding Temp Storage Cleanup and IOPS Utilization in Azure SQL Managed Instance
I have a couple of questions regarding Azure SQL Managed Instance storage and performance metrics. 1. TempDB Storage Behavior Our Azure SQL Managed Instance shows approximately 1.1 TB allocated for TempDB storage from the time the instance was…
Azure SQL Database
Azure SQL Database
An Azure relational database service.
6,900 questions
asked 2026-06-25T12:23:56.3433333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(144, 63%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESG%3C/text%3E%3C/svg%3E)
Swaroop Gowda D
25
Reputation points
answered 2026-06-25T19:43:05.88+00:00
Erland Sommarskog
135K
Reputation points MVP
Volunteer Moderator
2 answers
How to gain access for my subscription to make an sql database in the same region as my vnet
I'm trying to create an sql database and match the region to my vnet, which is in us east and it's saying my subscription doesn't have access to create a server in that region.
Azure SQL Database
Azure SQL Database
An Azure relational database service.
6,900 questions
asked 2026-06-18T22:09:37.2166667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(224.00000000000003, 74%, 31%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJC%3C/text%3E%3C/svg%3E)
Jack Callahan
0
Reputation points
commented 2026-06-25T12:08:52.0066667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(134.4, 49%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAG%3C/text%3E%3C/svg%3E)
Akhil Gajavelly
1,830
Reputation points Microsoft External Staff
Moderator
1 answer
Autoscaling delay causing downtime during Azure Load Testing – best approach?
We are currently performing Azure Load Testing on a production-like architecture and are facing issues with reactive autoscaling delays. Test Scenario: Concurrent users: 2000–3000 Load pattern: Step-based ramp (increase every 2 minutes) …
Azure SQL Database
Azure SQL Database
An Azure relational database service.
6,900 questions
asked 2026-06-24T18:09:07.7066667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(70.4, 16%, 16%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ECS%3C/text%3E%3C/svg%3E)
Chandan Shah (Persistent Systems Inc)
5
Reputation points Microsoft External Staff
answered 2026-06-25T00:07:10.1533333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(131.20000000000002, 96%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERK%3C/text%3E%3C/svg%3E)
Ravi Kiran Pagidi
90
Reputation points
1 answer
Unable to Connect Azure to AWS RDS – Request for Technical Assistance & Meeting
Dear Azure Support Team, Greetings from Allianz Insurance Sri Lanka. We are currently using Azure in conjunction with AWS for our M484 system anomaly detection solution, with both environments hosted via our FCP setup. However, we are facing an issue…
Azure SQL Database
Azure SQL Database
An Azure relational database service.
6,900 questions
asked 2026-06-22T06:19:30.23+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(121.6, 46%, 21%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EKJ%3C/text%3E%3C/svg%3E)
Khan, Jazeem
0
Reputation points
commented 2026-06-24T01:52:33.7266667+00:00
Pilladi Padma Sai Manisha
10,765
Reputation points Microsoft External Staff
Moderator
0 answers
Unable to Enable Zone Redundancy for Azure SQL Managed Instance in East US 2
Issue Summary We are attempting to enable Zone Redundancy for our Azure SQL Managed Instance deployed in the East US 2 region. According to Microsoft documentation and the Azure region availability information, East US 2 supports Zone Redundant…
Azure SQL Database
Azure SQL Database
An Azure relational database service.
6,900 questions
asked 2026-06-17T20:43:26.9033333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(118.4, 77%, 21%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAM%3C/text%3E%3C/svg%3E)
Ali Mehmood
0
Reputation points
commented 2026-06-22T23:14:53.9766667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(208, 49%, 30%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESJ%3C/text%3E%3C/svg%3E)
SAI JAGADEESH KUDIPUDI
3,550
Reputation points Microsoft External Staff
Moderator
1 answer
Hyperscale log storage not reclaimed after DBCC SHRINKFILE TRUNCATEONLY
The transaction log file (file_id 2) shows 1046528.007812 MB allocated against 1657.414062 MB used (per sys.database_files). DBCC SHRINKFILE(2, TRUNCATEONLY) was run during a low-traffic window and completed successfully but did not reduce the allocated…
Azure SQL Database
Azure SQL Database
An Azure relational database service.
6,900 questions
asked 2026-06-19T17:45:07.3966667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(246.4, 53%, 33%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EDV%3C/text%3E%3C/svg%3E)
Douglas van Zanden
0
Reputation points
answered 2026-06-20T03:17:05.47+00:00
Ravi Kiran Pagidi
90
Reputation points
8 answers
Retirement notice: Azure SQL Database 2014-04-01 APIs will be retired on 30 June 2026
We’re constantly making updates to Azure SQL Database APIs to ensure optimal security and performance. As part of these updates, we’ll retire Azure SQL Database API version 2014-04-01 on 30 June 2026. See our documentation for a detailed list of all…
Azure SQL Database
Azure SQL Database
An Azure relational database service.
6,900 questions
asked 2022-11-02T22:58:09.407+00:00
GeethaThatipatri-MSFT
29,597
Reputation points Microsoft Employee
Moderator
commented 2026-06-19T19:14:37.4+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(307.2, 54%, 39%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EGF%3C/text%3E%3C/svg%3E)
Gennaro FALCO
20
Reputation points
2 answers
Issues executing bulk data transfers using the SQL Server bcp utility.
SQL Server Tools & Utilities (bcp utility) We attempted to use bcp out with the native format flag (-n) to stream data through a Linux named pipe (FIFO), the process encounters data corruption. This issue specifically triggers when the table…
Azure SQL Database
Azure SQL Database
An Azure relational database service.
6,900 questions
asked 2026-06-15T06:46:25.35+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(272, 64%, 36%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJB%3C/text%3E%3C/svg%3E)
Juhi Bhatnagar
0
Reputation points
commented 2026-06-19T08:03:08.42+00:00
Erland Sommarskog
135K
Reputation points MVP
Volunteer Moderator
3 answers
One of the answers was accepted by the question author.
Azure SQL Database Server - SQL Audit to Log Analytics Workspace - How can I view Failed Logins ?
I have Azure SQL Database server where I enabled SQL Audit. It writes to Log Analytics Workspace as audit destination. According to docs, it should capture FAILED_DATABASE_AUTHENTICATION_GROUP events. I have requirement to capture and view failed…
Azure SQL Database
Azure SQL Database
An Azure relational database service.
6,900 questions
asked 2026-06-17T23:16:30.8266667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(297.6, 60%, 38%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAV%3C/text%3E%3C/svg%3E)
Aleksey Vitsko
45
Reputation points
commented 2026-06-19T00:28:34.7133333+00:00
Jose Benjamin Solis Nolasco
9,286
Reputation points
Volunteer Moderator
3 answers
One of the answers was accepted by the question author.
Data Sync has been failing for over a week
Data Sync Sync_To_Reporting_Database on Database SDPriceIT has been failing for over a week, I have tried increasing the DTU settings to 3000 and it has still failed. Please advise what Failure looks to be a timeout.. Check the inner exception for any…
Azure SQL Database
Azure SQL Database
An Azure relational database service.
6,900 questions
asked 2026-06-08T14:52:49.0733333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(246.4, 40%, 33%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EPQ%3C/text%3E%3C/svg%3E)
Peter Quinn
20
Reputation points
accepted 2026-06-18T10:24:50.9566667+00:00
Peter Quinn
20
Reputation points
3 answers
A vulnerability was detected on Azure SQL server on port 443 that tls1.0 and 1.1 are enabled. But we already disabled and configured a minimul TLS version in configuration
We disabled and configured a minimum TLS version of 1.2 in configuration of Azure SQL server. But a vulnerability was detected on Azure SQL server on port 443 that tls1.0 and 1.1 are enabled. The vulnerabilities were not detected on port 1433 but only…
Azure SQL Database
Azure SQL Database
An Azure relational database service.
6,900 questions
asked 2026-05-19T12:28:31.8866667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(92.8, 90%, 18%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESL%3C/text%3E%3C/svg%3E)
Singireddy Lohith Reddy
0
Reputation points
commented 2026-06-18T05:59:45.6866667+00:00
Pilladi Padma Sai Manisha
10,765
Reputation points Microsoft External Staff
Moderator
2 answers
How can I optimize a complex SQL reporting query with multiple joins, aggregations, and filters without changing existing business logic rules?
I am working on a production SQL report that joins eight tables, applies several date and status filters, and computes grouped totals for weekly dashboards. Query runtime increased from under one minute to nearly fifteen minutes after adding two new…
Azure SQL Database
Azure SQL Database
An Azure relational database service.
6,900 questions
asked 2026-06-18T03:08:38.21+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(192, 26%, 28%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EH%3C/text%3E%3C/svg%3E)
HimanshuSinha
19,637
Reputation points Microsoft Employee
Moderator
answered 2026-06-18T04:17:07.97+00:00
Pilladi Padma Sai Manisha
10,765
Reputation points Microsoft External Staff
Moderator
2 answers
One of the answers was accepted by the question author.
How to tell which resources are using Azure SQL Database 2014-04-01 APIs
I got the email that says I have resources using Azure SQL Database 2014-04-01 APIs and those APIs are retiring but it has no indication on how to find the resources that are using that API. How can I find the resources that are using Azure SQL Database…
Azure SQL Database
Azure SQL Database
An Azure relational database service.
6,900 questions
asked 2026-06-09T16:07:45.8833333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(92.8, 43%, 18%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERB%3C/text%3E%3C/svg%3E)
Ryan Brown
40
Reputation points
accepted 2026-06-16T12:14:32.1633333+00:00
Ryan Brown
40
Reputation points