Azure SQL Database
An Azure relational database service.
6,051 questions
1 answer
One of the answers was accepted by the question author.
When can we expect Vector Similarity Search in Azure SQL Managed Instance
Hi team, I see that the Vector Similarity search is available in Azure SQL database in Preview mode. May I know when can we expect this feature in Azure SQL Managed Instance.
asked 2025-02-19T06:33:04.32+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(102.4, 38%, 19%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EVG%3C/text%3E%3C/svg%3E)
Vigneshg G
20
Reputation points
edited the question 2025-03-03T16:04:33.71+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, 76%, 11%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EV%3C/text%3E%3C/svg%3E)
VarunTha
12,925
Reputation points Microsoft External Staff
2 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
commented 2025-03-03T16:01:28.73+00:00
Oury Ba-MSFT
20,356
Reputation points Microsoft Employee
1 answer
Serverless Azure SQL Database Not Auto Pausing
I have reconfigured a production database from Azure's DTU pricing to the VCore serverless pricing. My thinking is that once paused time was taken into account, I would be able to beef up the resources for the active time and therefore get better…
asked 2025-03-03T10:25:25.06+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(188.79999999999998, 88%, 28%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERM%3C/text%3E%3C/svg%3E)
Rob Marsh
0
Reputation points
answered 2025-03-03T12:11:25.2933333+00:00
Amira Bedhiafi
29,096
Reputation points
0 answers
Hosting Azure SQL Databases in Multiple Regions for Compliance and Access via Single API
We are looking to implement a multi-region data storage strategy using Azure SQL Database. Our goal is to store EU customer data in an Azure SQL Database located in an EU region and non-EU customer data in a US-based Azure SQL Database to meet compliance…
asked 2025-02-27T13:36:39.6733333+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(278.4, 48%, 36%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EDT%3C/text%3E%3C/svg%3E)
Devesh Tiwari
180
Reputation points
commented 2025-03-03T10:27:37.93+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
10
Reputation points Microsoft External Staff
2 answers
How to Retain User Logins & Passwords When Migrating Azure SQL Database via BACPAC
I have a production application running on Azure with an Azure SQL Server and a SQL Database inside it. In my application, all users are created at the database level with their passwords. I need to migrate this database to another Azure tenant by…
1 answer
Azure SQL Restore from Long Term Retention
I am trying to restore a database from long term retentions. I can't see the DB listed in my restore values, what are the options?
![](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(115.19999999999999, 5%, 21%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ECV%3C/text%3E%3C/svg%3E)
1 answer
Delete a SQL Elastic Pool
F&*k me, this support process is diabolical! I have managed to: Reopen an old support ticket Somehow create a new support ticket (no idea how I did that) Finally found a post mentioning that MS have removed Email/Phone support from Developer…
asked 2025-02-26T15:05:02.0633333+00:00
Rob Marsh
0
Reputation points
commented 2025-03-03T08:49:11.1466667+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, 47%, 31%)' 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)
Mallaiah Sangi
90
Reputation points Microsoft External Staff
2 answers
Need help understanding Query performance insights for Azure sql
In Azure I go to my database and choose Performance Overview | Query Performance insight and it shows me long running queries. I click it to get details and I then click again to see the details of one of the queries. It says in the last 24 hours it…
asked 2025-02-25T21:07:45.8366667+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
0
Reputation points
commented 2025-03-03T08:24:12.77+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(300.8, 60%, 39%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EP%3C/text%3E%3C/svg%3E)
PratikLad
85
Reputation points Microsoft External Staff
0 answers
Azure SQL DB export to blob issue for container $root.
Greetings. Note this is for an Azure SQL DB, not SQL on Azure VM, but there's no tag for that. Trying to export a SQL DB bacpac via powershell to a blob container and getting the message "The container $root specified for the operation was not…
asked 2025-02-24T13:53:55.5633333+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(44.800000000000004, 26%, 14%)' 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)
chrisrdba
471
Reputation points
commented 2025-03-03T05:38:10.69+00:00
Mallaiah Sangi
90
Reputation points Microsoft External Staff
2 answers
I need to know about DTUs and core based ,models for SQL.
I need to know about DTUs and core based ,models for SQL.
asked 2025-02-28T19:44:26.0266667+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, 99%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMW%3C/text%3E%3C/svg%3E)
Muhammad Waqas
0
Reputation points
commented 2025-03-03T05:22:00.6166667+00:00
Mallaiah Sangi
90
Reputation points Microsoft External Staff
1 answer
Azure resource sharing among multiple users
I have created few resources under Startup Subscription, however even after trying many times and many options, I am unable to add another user to see these resources and use them (e.g. DB Creation, App deployment etc.). Can you please suggest the steps…
asked 2025-03-01T05:12:06.6566667+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(201.6, 85%, 29%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ET%3C/text%3E%3C/svg%3E)
TrackSeal
0
Reputation points
commented 2025-03-03T05:05:55.2466667+00:00
Mallaiah Sangi
90
Reputation points Microsoft External Staff
4 answers
How to view new JSON data type in SSMS from Azure SQL?
I created a new Azure SQL database and used the Azure GUI to create a table with the new JSON data type (released May 2024). I then started the latest SSMS and connected to the Azure database. Next I tried to view the table design and received this…
asked 2024-06-25T17:50:32.89+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(67.2, 19%, 16%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EBP%3C/text%3E%3C/svg%3E)
Brian Peal
0
Reputation points
answered 2025-03-03T05:01:32.69+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, 84%, 18%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJS%3C/text%3E%3C/svg%3E)
Justin Smith
0
Reputation points
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-03-03T04:53:28.41+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
2 answers
why can I not query a SQL database in Azure
I am a user access administrator for a SQL Server and SQL Database in Azure and have been unable to give access to my colleague to query the SQL database. Please let me know how I can configure it appropriately.
asked 2025-03-01T21:06:47.7833333+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(156.8, 46%, 25%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJR%3C/text%3E%3C/svg%3E)
Jenn Rolfes
0
Reputation points
commented 2025-03-03T03:57:52.7666667+00:00
Mallaiah Sangi
90
Reputation points Microsoft External Staff
1 answer
Azure SQL DB Timeout
Getting status as 'Resuming' peristently for my SQL DB Trying to figure out cause of the problemScreenshot 2025-02-27 at 16.16.46.png
asked 2025-02-27T11:39:33.9833333+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(80, 71%, 17%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESA%3C/text%3E%3C/svg%3E)
Sparsh Agarwal
0
Reputation points
commented 2025-03-03T00:26:07.5333333+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,795
Reputation points Microsoft External Staff
2 answers
Azure Sql Managed Instance - Service Principal access issue
We have configured Sql Managed Instance and currently configured MS Entra MFA but we can't use for application login/Service account which is prompting for MFA so we have created Service Principal and provided access after adding into Managed Sql Server…
![](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, 17%, 24%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EP%3C/text%3E%3C/svg%3E)
0 answers
How do I fix the error 404 message when trying to set up the Wordpress migration to Azure?
I have been attempting to set up the Wordpress database in Azure. I think I've tried everything 4 times including recoding bash files. I am not a programmer but bootstrapping this myself. Any help or thoughts on this?
![](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, 26%, 38%)' 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)
1 answer
One of the answers was accepted by the question author.
Secure enclaves enabled but SSMS didn't allow
in Azure portal, I created the database with Secure enclaves enabled - type was Virtualization based security (VBS). the command below return 1,1; however when using SSMS trying to connect with Enable secure enclaves, and protocol None, got error: …
![](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(99.2, 39%, 19%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJW%3C/text%3E%3C/svg%3E)
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 External Staff
commented 2025-02-28T18:45:48.5033333+00:00
Mallaiah Sangi
90
Reputation points Microsoft External Staff
0 answers
Incorrect syntax near 'BLOB_STORAGE'.
Hello, I had created a Credential using the following Query. The credential got added successfully. -- CREATE DATABASE SCOPED CREDENTIAL TradeGeekBlobCredential -- WITH IDENTITY = 'SHARED ACCESS SIGNATURE', -- SECRET = 'MYSECRET'; Later, I am…
asked 2025-02-26T09:07:16.3166667+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(294.40000000000003, 12%, 38%)' 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)
Rahul Kumar
0
Reputation points
commented 2025-02-28T17:52:14.17+00:00
Sai Raghunadh M
2,795
Reputation points Microsoft External Staff