Azure SQL Database
An Azure relational database service.
5,401 questions
4 answers
How to fix the error: The transaction log for database is full due to 'log_backup'.
Hi Team, I am getting the below error: The transaction log for database is full due to 'log_backup'. Whereas SQL Always on Clustering has configured and for testing purpose we are monitoring for few days that is working or not properly even no…
asked 2023-05-09T05:17:22.2266667+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, 41%, 17%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EBS%3C/text%3E%3C/svg%3E)
Bikram Sana
5
Reputation points
commented 2024-06-25T18:50:42.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(211.20000000000002, 40%, 30%)' 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)
Tarek Salha
1
Reputation point
2 answers
One of the answers was accepted by the question author.
Sql server Metrics : is 100% CPU percentage is a blocker for all DB operations?
HI All We have observed a case in our database where the CPU perncetage is 100% for quite some time but my application are still able to hit & operate over DB, is 100% CPU usage isnt a blocker for DB operations ?? I see 2 CPU metrics 1) CPU…
asked 2024-05-27T01:27:28.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(137.6, 91%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMM%3C/text%3E%3C/svg%3E)
Manoj Mathe
20
Reputation points Microsoft Employee
accepted 2024-06-25T18:29:39.9366667+00:00
Manoj Mathe
20
Reputation points Microsoft Employee
3 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 2024-06-25T18:29:23.78+00:00
Danish Gul Khattak
335
Reputation points
2 answers
How to use mTLS to secure a sql database
Hi, I'm trying to an managed sql database in Azure using either a managed sql instance or cosmosdb with the postgres interface. However I would like to secure the communication towards it using mTLS since all of the communication will come from…
asked 2024-05-30T07:43:23.8666667+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, 4%, 28%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EDA%3C/text%3E%3C/svg%3E)
David Andersson
0
Reputation points
edited the question 2024-06-25T17:25:12.22+00:00
KapilAnanth-MSFT
40,911
Reputation points Microsoft Employee
2 answers
Accessing a SQL Server without going via VM
Good day Members I have connect using an IPSec to a on prem SQL DB(this is the only way). I can connect to the SQL DB in a VM. I have been using PowerBI and SSMS in the VM. I want to sink the data into an Azure SQL and use it without going via VM. I…
asked 2024-06-19T07:54:17.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(102.4, 23%, 19%)' 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)
StudentLearner
0
Reputation points
edited the question 2024-06-25T17:17:01.52+00:00
KapilAnanth-MSFT
40,911
Reputation points Microsoft Employee
2 answers
One of the answers was accepted by the question author.
I am being charged for a free Azure SQL Database which is free for 12 Months
Hi, I see that I am being charged for the use of MS SQL Server. I thought this service was free for 12 months. I believe I may have made a mistake while creating the database. Could you please assist me in identifying the problem and guide me on how to…
asked 2024-06-24T18:45:07.9+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, 11%, 17%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
alefleitas
20
Reputation points
edited an answer 2024-06-24T23:22:34.3533333+00:00
Oury Ba-MSFT
17,791
Reputation points Microsoft Employee
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,012
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://learn.microsoft.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,012
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,012
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,012
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,791
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,012
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)
Bhargava-MSFT
28,951
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,012
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,012
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
81
Reputation points
accepted 2024-06-24T02:38:44.77+00:00
Ijaz Muhammad
81
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