Azure SQL Database
An Azure relational database service.
6,903 questions
2 answers
One of the answers was accepted by the question author.
Create SQL Database not allowing me to use the (US) East US region
I'm following along on creating a single database - Azure and when I try to use my "Free" subscription I get this error: Your subscription does not have access to create a server in the selected region. For the latest information about region…
Azure SQL Database
![](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(185.6, 61%, 27%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EVB%3C/text%3E%3C/svg%3E)
1 answer
SqlException in stored procedure of an Azure SQL database that goes away when updating stored procedure without any changes
We have a stored procedure in an Azure SQL database which uses OPENJSON to access a json value. The field containing the value is checked with ISJSON to make sure that it really contains valid json. This stored procedure randomly throws an SqlException…
Azure SQL Database
Azure SQL Database
An Azure relational database service.
6,903 questions
asked 2026-06-29T07:35:12.74+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(236.8, 83%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAF%3C/text%3E%3C/svg%3E)
Andreas Fandrich
0
Reputation points
commented 2026-07-02T09:28:03.19+00:00
Erland Sommarskog
135.3K
Reputation points MVP
Volunteer Moderator
1 answer
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,903 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
edited an answer 2026-07-02T07:13:27.94+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
2 answers
How to set up new SQL server database
I am using enterprise SQL at work and would like to practise my coding from a home laptop. With no previous experience, how do I configure my azure account to create a simple SQL database that I can load data to and use SSMS?
Azure SQL Database
Azure SQL Database
An Azure relational database service.
6,903 questions
asked 2026-06-28T17:21:09.24+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(211.20000000000002, 44%, 30%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ER%3C/text%3E%3C/svg%3E)
RCS
0
Reputation points
commented 2026-07-02T05:03:27.0566667+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,950
Reputation points Microsoft External Staff
Moderator
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
Azure SQL Database
An Azure relational database service.
6,903 questions
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-07-01T07:59:20.1033333+00:00
Manoj Kumar Boyini
17,950
Reputation points Microsoft External Staff
Moderator
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,903 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-07-01T05:51:44.12+00:00
Khan, Jazeem
0
Reputation points
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,903 questions
asked 2026-06-23T11:38:05.4466667+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(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)
Niek
0
Reputation points
commented 2026-07-01T02:06:05.9433333+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,770
Reputation points Microsoft External Staff
Moderator
3 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,903 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-07-01T01:51:58.68+00:00
Pilladi Padma Sai Manisha
10,770
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,903 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
edited a comment 2026-07-01T01:44:49.9766667+00:00
SAI JAGADEESH KUDIPUDI
3,550
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,903 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
recommended 2026-06-30T08:27:01.34+00:00
Erland Sommarskog
135.3K
Reputation points MVP
Volunteer Moderator
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,903 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
Pilladi Padma Sai Manisha
10,770
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,903 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,770
Reputation points Microsoft External Staff
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,903 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
2 answers
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,903 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
answered 2026-06-24T08:01:00.3833333+00:00
Pilladi Padma Sai Manisha
10,770
Reputation points Microsoft External Staff
Moderator
2 answers
One of the answers was accepted by the question author.
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,903 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
20
Reputation points
answered 2026-06-22T05:55:49.77+00:00
Pilladi Padma Sai Manisha
10,770
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,903 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
![](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
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,903 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,903 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
135.3K
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,903 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,451
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,903 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