Azure SQL Database
An Azure relational database service.
6,025 questions
1 answer
SQL Database Reserved vCores
We have a number of databases running on Azure SQL Server resources. We would like to change them to SQL Database Reserved vCores. Is there a way to change the from Azure SQL Database to SQL Database Reserved vCores. We would like to find the easiest…
asked 2025-02-21T00:11:02.9066667+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, 43%, 21%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESC%3C/text%3E%3C/svg%3E)
Sipo Ching
0
Reputation points
commented 2025-02-21T13:42:36.81+00:00
Sipo Ching
0
Reputation points
1 answer
One of the answers was accepted by the question author.
Recently, ODBC connections to our database in Azure no longer show all available tables.
When trying to add a linked table to our Azure DB in Microsoft Access via ODBC, recently I've started getting the following error message: OBDB--call failed. [Microsoft][ODBC SQL Server Driver][SQL Server]Reference to database and/or server name in…
asked 2025-02-19T13:49:18.2133333+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(275.2, 3%, 36%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ENF%3C/text%3E%3C/svg%3E)
Neal Freeman
20
Reputation points
accepted 2025-02-21T13:14:07.1866667+00:00
Neal Freeman
20
Reputation points
0 answers
User can not log onto Azure Sql Server
Users can not log on to SQL Server. Only the Admin account can access the server. I have created the users and given them roles. The users show up in the database correctly but the logons do not work.
asked 2025-02-20T00:54:44.1+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(291.2, 80%, 38%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ETB%3C/text%3E%3C/svg%3E)
Tom Burke
0
Reputation points
edited a comment 2025-02-21T11:40:39.9966667+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(35.2, 49%, 13%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EVK%3C/text%3E%3C/svg%3E)
Vijayalaxmi Kattimani
1,480
Reputation points Microsoft Vendor
3 answers
Zone Redundency Option not showing on West Europe SQL Elastic pool
Hi, I have an SQL Elastic Pool in West Europe and another East US and the section where it allows me to enable "Zone Redundancy" isn't showing: I've successfully enabled it on our UK South Elastic Pool without any issues: UK South Elastic…
asked 2025-02-18T11:44:41.7033333+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(19.2, 75%, 11%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ECW%3C/text%3E%3C/svg%3E)
Callum Woodward
1
Reputation point
answered 2025-02-21T09:28:21.7533333+00:00
Callum Woodward
1
Reputation point
3 answers
We have a serverless Azure SQL database that we can't drop from the portal or SSMS.
I have reviewed the common solutions provided by the troubleshooter and none of them have resolved the issue.
asked 2025-02-18T14:17:44.1566667+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(259.20000000000005, 1%, 35%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EDD%3C/text%3E%3C/svg%3E)
Dan Deluna
0
Reputation points
commented 2025-02-21T09:04:49.2733333+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(256, 4%, 34%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EPC%3C/text%3E%3C/svg%3E)
Prasad Chaganti
0
Reputation points Microsoft Vendor
1 answer
upload_blob and download_blob takes 2 seconds to execute which increases execution time of our API
This is how we are creating a pdf on azure blob storage and reading the file from Azure blob storage upload_blob and download_blob takes 2 seconds to execute which increases execution time of our API i tried async but it didnt reduced time. func tools…
asked 2025-02-19T13:21:00.3766667+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(51.2, 91%, 14%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMA%3C/text%3E%3C/svg%3E)
Mayank Arora
0
Reputation points
commented 2025-02-21T08:54:13.0733333+00:00
Prasad Chaganti
0
Reputation points Microsoft Vendor
1 answer
How to take Azure SQL DB Backup to external storage
How to take Azure SQL DB Backup to external storage
asked 2025-02-17T08:15:24.7533333+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(214.4, 84%, 30%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESE%3C/text%3E%3C/svg%3E)
Saiju E
0
Reputation points
commented 2025-02-21T08:16:09.8233333+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(252.8, 60%, 34%)' 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)
Mahesh Kurva
2,750
Reputation points Microsoft Vendor
1 answer
How do I log a ticket to release an SQL MI logical name?
I need to have an SQL managed instance logical name released before the 7 day default timeout. How do I log a ticket to ask for this directly? All options via the Azure portal lead to self-led diagnosis and no end path to log an actual ticket. It's been…
asked 2025-02-17T12:08:41.42+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(0, 36%, 10%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESD%3C/text%3E%3C/svg%3E)
Steven Datt
0
Reputation points
commented 2025-02-21T08:11:09.41+00:00
Mahesh Kurva
2,750
Reputation points Microsoft Vendor
2 answers
One of the answers was accepted by the question author.
Vulnerability Scan on Azure SQL Server and found unexpected TLS 1.0, TLS 1.1, TLS 1.2 and SWEET32 issue
Hi there, Recently, I used the most popular vulnerability scanner to scan the Azure SQL Server (DB), and the results were unexpected. It showed a few vulnerabilities found, all of which were unexpected: TLS 1.0 FOUND TLS 1.1 FOUND TLS 1.2 with Weak…
asked 2024-02-29T07:29:46.6033333+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, 91%, 17%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EC%3C/text%3E%3C/svg%3E)
Carrr
30
Reputation points
commented 2025-02-21T04:10:16.3566667+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(220.8, 4%, 31%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESM%3C/text%3E%3C/svg%3E)
ShaktiSingh-MSFT
16,246
Reputation points
1 answer
How to login SQL server from SSMS using Managed Identity
Hi Team, We are using Azure SQL server. We have to disable the 'Public Network access' on this server now so we are checking the options on how to connect to this server from SSMS 20 as our existing method of login with MFA account will not work…
asked 2025-02-20T09:17:51.97+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(284.8, 11%, 37%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESU%3C/text%3E%3C/svg%3E)
Sanchita Uttarwar
0
Reputation points Microsoft Vendor
edited an answer 2025-02-21T01:42:15.9733333+00:00
Alberto Morillo
34,466
Reputation points MVP
1 answer
SQL Server Error: 10060.
Unable to connect to my managed instance. My public endpoint is enabled. Error I'm getting when I try to login via SSMS. I added an inbound security rule that is higher than the "deny_all_inbound" rule. My rule port is set to 3342, protocol…
asked 2025-02-18T18:58:39.0233333+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(150.4, 20%, 24%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJM%3C/text%3E%3C/svg%3E)
Julian McNeill
0
Reputation points
commented 2025-02-21T01:12:29.6066667+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(249.60000000000002, 51%, 34%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAP%3C/text%3E%3C/svg%3E)
Adithya Prasad K
5
Reputation points Microsoft Vendor
1 answer
How do I fix Azure SQL Database Connection Issue when it was working earlier?
This is my following error message while trying to connect to my Azure SQL database one day later. Originally, it was working, but when I had to try and sign in again with Microsoft Entra ID, I was unable to. See the following error message: Database…
asked 2025-02-20T16:51:33.58+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(227.2, 7.000000000000001%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJH%3C/text%3E%3C/svg%3E)
James Hizon
20
Reputation points
commented 2025-02-21T01:01:28.46+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(198.4, 69%, 29%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESR%3C/text%3E%3C/svg%3E)
Sai Raghunadh M
2,640
Reputation points Microsoft Vendor
2 answers
TLS 1.0 Vulnerabilites on SQL databases
The remote service accepts connections encrypted using TLS 1.0. TLS 1.0 has a number of cryptographic design flaws. Modern implementations of TLS 1.0 mitigate these problems, but newer versions of TLS like 1.2 and 1.3 are designed against these flaws and…
asked 2025-02-20T14:51:20.1333333+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(96, 57.99999999999999%, 19%)' 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)
Girshwin Findlay (Rayton)
0
Reputation points
answered 2025-02-21T00:44:55.27+00:00
Alberto Morillo
34,466
Reputation points MVP
1 answer
Deploying Azure SQL fails due to timeout. (32min) - why is it failing
The resource write operation failed to complete successfully, because it reached terminal provisioning state 'Failed'. Click here for details
asked 2025-02-13T18:43:10.63+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, 57.99999999999999%, 30%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJA%3C/text%3E%3C/svg%3E)
James A. Spellman
0
Reputation points
edited an answer 2025-02-21T00:37:09.02+00:00
Oury Ba-MSFT
20,346
Reputation points Microsoft Employee
2 answers
Azure SQL Connection Error Code: 18456 Error State: 15
Hi, we have a strange issue with Azure Sql. When ever a User run lot of queries with aginst Azure Sql. His/Her account getting blocked on the database . Log shows following error. …
asked 2025-02-20T12:42:51.3866667+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(38.4, 53%, 13%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERP%3C/text%3E%3C/svg%3E)
Rajan Patel
0
Reputation points
commented 2025-02-20T22:37:05.4033333+00:00
Erland Sommarskog
117.3K
Reputation points MVP
1 answer
Azure SQL Managed Instance Stuck After Force Deleting Virtual Cluster – Cannot Remove MI
I attempted to delete an Azure SQL Managed Instance (MI), but the process became stuck while deleting the associated Virtual Cluster. I then manually force deleted the Virtual Cluster using Azure CLI. However, the SQL MI still exists in the Azure Portal…
![](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(300.8, 9%, 39%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EEL%3C/text%3E%3C/svg%3E)
0 answers
How to fix sql server having a stuck ExportDatabase job at 1%, cancelling leads to stuck CancelInProgress instead
We were doing an ExportDatabase operation on our production database. This is part of our release pipeline, to do a backup before deploying new code. The github action timed out eventually since the export job got stuck at 1% and was stuck for 8 hours.…
asked 2025-02-18T08:04:09.8533333+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(304, 76%, 39%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EKM%3C/text%3E%3C/svg%3E)
Kalle Macklin
0
Reputation points
commented 2025-02-20T22:07:36.2666667+00:00
Erland Sommarskog
117.3K
Reputation points MVP
0 answers
Why are all Host Pool applications and users suddenly unable to connect to all Azure SQL databases?
On Thursday of last week Feb 13th, all Host Pool users and applications were suddenly unable to connect to the SQL databases associated with said applications. This consists of two primary databases and applications. The two databases are JTS_AZURE and…
asked 2025-02-17T16:39:29.7433333+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, 10%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EEA%3C/text%3E%3C/svg%3E)
Ed Abraham
0
Reputation points
edited a comment 2025-02-20T20:36:14.51+00:00
Oury Ba-MSFT
20,346
Reputation points Microsoft Employee
1 answer
One of the answers was accepted by the question author.
Connect Azure Automation Account to Azure SQL using Managed Identity
Hello, I'm trying to create a Runbook (Powershell) to connect to Azure SQL Database and then add an Entra ID user in that database. If there is way to do so in CLI commands it's fine by me. The problem is that we're always stuck at the DB connection step…
asked 2025-02-19T09:56:47.0966667+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(140.8, 61%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMS%3C/text%3E%3C/svg%3E)
Michel Sfeir
85
Reputation points
accepted 2025-02-20T17:21:43.84+00:00
Michel Sfeir
85
Reputation points
1 answer
One of the answers was accepted by the question author.
Access setting for Azure SQL elastic query across same logical server.
I would like to use elastic queries between two Azure SQL databases on the same logical server. Unfortunately I am getting an error this is not possible because Public Access has been set to Disabled. My understanding, is this is normal for accessing…
asked 2025-02-20T13:26:51.4633333+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(166.4, 84%, 26%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ELA%3C/text%3E%3C/svg%3E)
Lockyer, Aaron (SGRE COG B MS SYS BSPM)
0
Reputation points
commented 2025-02-20T14:28:09.78+00:00
Nandan Hegde
34,251
Reputation points MVP