Azure SQL Database
An Azure relational database service.
5,348 questions
1 answer
Linked Server - how to set up in Azure Managed Instance
Hi Team How do we configure linked server to On Prem SQL in Azure Managed Instance. What the pre-requisites on the network side of things Thanks
asked 2024-06-17T05:11:23.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(124.80000000000001, 84%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ENV%3C/text%3E%3C/svg%3E)
Nitya V
40
Reputation points
commented 2024-06-24T22:50:20.7233333+00:00
GeethaThatipatri-MSFT
29,007
Reputation points Microsoft Employee
3 answers
authenticating to azure sql db using entra credentials Login failed for token-identified-principal
The goal is a WPF app that allows external users in an Entra external tenant to authenticate to an Azure SQL DB. I am following https://video2.skills-academy.com/en-us/entra/external-id/customers/sample-desktop-wpf-dotnet-sign-in carefully, and can use it…
asked 2024-06-17T21:55:50.7133333+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, 14.000000000000002%, 39%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EGS%3C/text%3E%3C/svg%3E)
greg schlitt
0
Reputation points
answered 2024-06-24T22:43:58.05+00:00
GeethaThatipatri-MSFT
29,007
Reputation points Microsoft Employee
1 answer
Connection to a managed SQL instance using Microsoft Entra Integrated Authentication
We need your assistance with connecting to a managed SQL instance using Microsoft Entra Integrated Authentication from VM. We're encountering the following error when attempting to connect. This is required for migration of our solution to Cloud. …
asked 2024-06-19T13:03:52.6933333+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(105.60000000000001, 56.00000000000001%, 20%)' 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)
Vishwanath K Bellubbi
0
Reputation points
commented 2024-06-24T22:30:30.5833333+00:00
GeethaThatipatri-MSFT
29,007
Reputation points Microsoft Employee
1 answer
I can't get my local machine to connect to the azure database
Hello, I don't have a SQL Server Manamanagement studio on my local machine. However, I am creating a user form application that using a database. I am new to azure and I'm learning it. I wanted to do what I felt was a basic thing: connect my…
asked 2024-06-20T16:30: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(198.4, 50%, 29%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EBB%3C/text%3E%3C/svg%3E)
Ben Booton
0
Reputation points
commented 2024-06-24T22:20:14.9066667+00:00
GeethaThatipatri-MSFT
29,007
Reputation points Microsoft Employee
1 answer
A connection was successfully established with the server, but then an error occurred during the pre-login handshake.
I am trying to connect to a Azure SQL database in Server Management Studio, but I get a timeout period error. I have tried increasing the connection time out and enabling "trust server certificate". I noticed that my connection string has this:…
asked 2023-04-04T18:54:21.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(182.40000000000003, 45%, 27%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJV%3C/text%3E%3C/svg%3E)
Jonpier Veliz
0
Reputation points
commented 2024-06-24T20:51:16.55+00:00
Oury Ba-MSFT
17,631
Reputation points Microsoft Employee
0 answers
How to resolve the SSL connection error when connecting to Azure MySQL from MacOS?
I am attempting to connect to my Azure MySQL database from my MacOS system using SSL, but I am encountering persistent issues. Despite following the instructions for setting up SSL, I receive the following error message: ERROR 2026 (HY000): SSL…
asked 2024-06-24T12:57:42.1366667+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, 26%, 18%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ELR%3C/text%3E%3C/svg%3E)
Leugzim Rullani
0
Reputation points
commented 2024-06-24T20:01:16.38+00:00
GeethaThatipatri-MSFT
29,007
Reputation points Microsoft Employee
1 answer
Reading sql pool auditing files (.xel)
I am trying to read audit files in Synapse analytics, made by automated auditing, using query select * from sys.fn_get_audit_file('https://datalake.dfs.core.windows.net/path/10_00_24_565_6.xel' ,DEFAULT ,DEFAULT ); But it just gives me empty…
asked 2024-06-19T11:07:59.9366667+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(28.799999999999997, 7.000000000000001%, 12%)' 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)
Jani Hämäläinen
40
Reputation points
commented 2024-06-24T19:47:23.3233333+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(86.4, 36%, 18%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EBM%3C/text%3E%3C/svg%3E)
BhargavaGunnam-MSFT
28,766
Reputation points Microsoft Employee
1 answer
One of the answers was accepted by the question author.
error while installing SQL express edition
Hi everyone, im trying to install the SQL express edition server but getting this error and not sure how to approach, installation error It says Oops installation initialization successful
![](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, 72%, 18%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ES%3C/text%3E%3C/svg%3E)
1 answer
Local SSIS Package Issues with MFA on Managed Instance
We have a SQL Managed Instance that we are testing with. I'm attempting to create local packages in SSIS and have them run against the Managed Instance data. When I manually run the SSIS package, I get an MFA validation. It works. However, when I try to…
![](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, 69%, 25%)' 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)
1 answer
Database connectivity issue in dev env
Hello Team , We are using Mysql server with the pricing tier :Standard s2 with 20 DTU's. We have 13 app service web applications in two app service plans. All service applications are of type spring boot which are opening 5 DB connections and we are…
asked 2024-06-06T07:10:14.2333333+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(310.4, 42%, 40%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESK%3C/text%3E%3C/svg%3E)
Sowmya Kailasamurthy
0
Reputation points
answered 2024-06-24T16:00:05.7666667+00:00
GeethaThatipatri-MSFT
29,007
Reputation points Microsoft Employee
2 answers
Edit Data in Azure Data Studio stopped working for me
I usually edit fields in tables manually with Azure Data Studio by clicking right on the table and selecting 'Edit Data'. However it stopped working for me, the screen is loading and nothing happens, sometimes I get an error message that there is already…
asked 2024-06-22T18:56:21.68+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(124.80000000000001, 90%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EHS%3C/text%3E%3C/svg%3E)
Horst Schnattler
0
Reputation points
answered 2024-06-24T14:04:01.1866667+00:00
GeethaThatipatri-MSFT
29,007
Reputation points Microsoft Employee
1 answer
One of the answers was accepted by the question author.
how to connect to azure managed instance from different vnet in hub and spoke?
My function app is in Vnet A and MI is in Vnet B. We use hub and spoke topology. Function app is in spoke A and MI is in spoke B. Public access to MI is disabled now. We have a Azure firewall in the hub.
asked 2024-06-19T08:10:55.1066667+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, 21%, 17%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EIM%3C/text%3E%3C/svg%3E)
Ijaz Muhammad
61
Reputation points
accepted 2024-06-24T02:38:44.77+00:00
Ijaz Muhammad
61
Reputation points
1 answer
One of the answers was accepted by the question author.
Pricing of SQL database
I have a Azure student subscription. I was following the exercise from Microsoft (here). As I created a database, it provided estimated costs. I am only going to use it temporarily and with extremely low amounts of data and extremely low usage (me…
asked 2024-06-21T20:59:15.1033333+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, 48%, 21%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EPK%3C/text%3E%3C/svg%3E)
Preston, Kevin
20
Reputation points
accepted 2024-06-22T15:55:28.6266667+00:00
Preston, Kevin
20
Reputation points
2 answers
My free tier was completed for this month so i choose the option continue using database for additional charges for 10 days of use and now i want to stop it and wait for free version after 10 days so how can i remove this option now
My free tier was completed for this month so i choose the option continue using database for additional charges for 10 days of use and now i want to stop it and wait for free version after 10 days so how can i remove this option now
asked 2024-06-21T11:37:02.9666667+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, 55.00000000000001%, 21%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EKG%3C/text%3E%3C/svg%3E)
Kalyan Goud
20
Reputation points
edited an answer 2024-06-21T15:53:06.8+00:00
Alberto Morillo
33,421
Reputation points MVP
5 answers
One of the answers was accepted by the question author.
SSMS UI bug (all versions so far)
Hello there, There is an annoying bug in the SSMS UI that I thought will be found and fixed with the latest version (19.0.1) I just installed. It persists in all the previous versions I used and is available here too. Here is the description: Connect…
asked 2023-03-20T08:34:33.5233333+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, 44%, 14%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EHS%3C/text%3E%3C/svg%3E)
Hristo Serafimov
35
Reputation points
commented 2024-06-21T13:38:26.3666667+00:00
Erin Stellato
531
Reputation points Microsoft Employee
1 answer
SQL Database export
How to export and download exported database?
asked 2024-06-21T12:47:40.7866667+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, 54%, 30%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ETA%3C/text%3E%3C/svg%3E)
Tukenov, Almaz [Tengizchevroil]
0
Reputation points
answered 2024-06-21T12:53:13.87+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, 79%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERR%3C/text%3E%3C/svg%3E)
Rahul Randive
9,091
Reputation points Microsoft Employee
1 answer
One of the answers was accepted by the question author.
WIll increasing Azure SQL Database from 2 TB to 3 TB cause any downtime or risk of the related services?
Hello, I have a 2 TB Azure SQL Database - General Purpose, Provisioned, Standard-Series (Gen5), 8 vcores. I will need to resize it to 12 vCores and 3 TB. Is this process anyhow risky for my other related services? I have found the similar…
![](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, 20%, 19%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3E14%3C/text%3E%3C/svg%3E)
1 answer
One of the answers was accepted by the question author.
Monthly limit has been reached. Yo can wait for credits
I've create a resource of SQL managed instance with the new offer of free vCore 720 hours/month for But after 2 weeks the database stoped saying I got the vCore 720 reached. Is that right? just create databases and tried to restore backup Also I deleted…
asked 2024-06-20T12:02:32.6533333+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, 73%, 30%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EHK%3C/text%3E%3C/svg%3E)
Hari Kumar G
20
Reputation points
accepted 2024-06-21T06:37:42.8066667+00:00
Hari Kumar G
20
Reputation points
1 answer
One of the answers was accepted by the question author.
Retirement of Azure SQL Database APIs 2014-04-01
The Azure SQL Database API version 2014-04-01 is retiring, I would like to understand the following things: How can we check the resources effected using the resource graph explorer? How to make the changes using code? Any prerequisite or…
asked 2024-05-01T08:54:07.26+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(179.20000000000002, 44%, 27%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAA%3C/text%3E%3C/svg%3E)
Azra Akil
60
Reputation points
commented 2024-06-20T22:40:02.87+00:00
GeethaThatipatri-MSFT
29,007
Reputation points Microsoft Employee
1 answer
Additional Cost for Verify Function in SQL DB Backups to Blob Storage
I have a plan to move my SQL backups directly to Blob Storage and want to know what additional costs I may encounter when using the Verify function in my T-SQL query. I have read that Verify may increase costs tenfold, but I need more detail and…
asked 2024-06-06T20:53:53.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(198.4, 35%, 29%)' 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)
Jordan Algar
0
Reputation points
commented 2024-06-20T21:08:30.41+00:00
Oury Ba-MSFT
17,631
Reputation points Microsoft Employee