6,344 questions with Azure SQL Database tags

Sort by: Updated
1 answer

About in Ms Azure SQL DBA

#azure training what iaas and paas in azure SQL database administrator This question is related to the following Learning Module

Azure SQL Database
asked 2025-06-16T20:50:16.3633333+00:00
Sagar Kumar Nayak 0 Reputation points
commented 2025-06-18T18:37:57.1466667+00:00
Sai Raghunadh M 4,640 Reputation points Microsoft External Staff Moderator
2 answers

Getting an Access Denied error when accessing a file in Azure Blob Storage

Files have been loaded into a blob container, and through PowerShell, that data has been loaded into the Azure SQL database successfully for over 2 years. As of last week, this process was functioning correctly. Currently encountering an Access Denied…

Azure SQL Database
asked 2025-05-30T17:00:14.79+00:00
IAA Dashboard 0 Reputation points
commented 2025-06-18T09:56:56.78+00:00
Narendra Pakkirigari 475 Reputation points Microsoft External Staff Moderator
2 answers

recover deleted sql server

Hello i have deleted the sql server and the sql db and i need to recover them is that possible?

Azure SQL Database
asked 2025-06-10T19:08:24.6166667+00:00
Alex Bitar 0 Reputation points
commented 2025-06-17T17:59:04.6233333+00:00
Sai Raghunadh M 4,640 Reputation points Microsoft External Staff Moderator
1 answer

External Data Source from Az SQL DB to Az VM with SQL Server

Hi, Is it possible to create an external data source connection from an Azure SQL Database to SQL server running on an Azure VM. I've created the connection to external server (Azure VM) which creates but when I try to query it, it fails CREATE…

Azure SQL Database
asked 2023-08-15T11:14:31.44+00:00
Matt Brooks 1 Reputation point
commented 2025-06-17T14:52:45.4266667+00:00
Chaitanya 0 Reputation points Microsoft External Staff
1 answer One of the answers was accepted by the question author.

How to provide VIEW SERVER STATE permission to a user in master Azure DB

How to provide Serverstate permission to a user in master Azure DB.

Azure SQL Database
asked 2022-08-08T18:13:50.973+00:00
Vijay Kumar 2,036 Reputation points
commented 2025-06-17T12:46:58.5666667+00:00
Bharath Suresh 0 Reputation points
1 answer

Login Failed for User '

Encountering the error "Login failed for user '

Azure SQL Database
asked 2025-06-09T11:47:44.02+00:00
Shweta Singh 0 Reputation points
commented 2025-06-17T10:24:31.97+00:00
Shweta Singh 0 Reputation points
2 answers

How to Fix:Error: Microsoft ODBC Driver 18 for SQL Server : SSL Provider: [error:1416F086:SSL routines:tls_process_server_certificate:certificate verify failed:self signed certificate].

I followed the documentation: https://learn.microsoft.com/en-us/sql/linux/quickstart-sql-server-containers-azure?view=sql-server-ver16&tabs=kubectl to deploy SQL server on AKS. But While connecting to it, getting the below error: Sqlcmd: Error:…

Azure SQL Database
Azure
Azure
A cloud computing platform and infrastructure for building, deploying and managing applications and services through a worldwide network of Microsoft-managed datacenters.
1,464 questions
Azure Kubernetes Service
Azure Kubernetes Service
An Azure service that provides serverless Kubernetes, an integrated continuous integration and continuous delivery experience, and enterprise-grade security and governance.
2,458 questions
SQL Server | Other
asked 2023-06-27T20:19:16.9633333+00:00
Satyam 25 Reputation points
answered 2025-06-17T02:24:08.6+00:00
Angi Wang 0 Reputation points
2 answers

Is it mandatory to create index's for azure sql database object's and also how to handle performance issue on azure databases.

Is it mandatory to create index's for azure sql database object's and also how to handle performance issue on azure databases.

Azure SQL Database
asked 2025-06-12T06:54:04.2266667+00:00
Anandhswarupp 185 Reputation points
commented 2025-06-17T01:12:58.2833333+00:00
Vijayalaxmi Kattimani 3,410 Reputation points Microsoft External Staff Moderator
2 answers

Data factory fails to run Stored Procedure when SSMS succeeds

I have a nightly job that generates an email via a stored procedure run through azure data factory. It has been in use for about 2 years with no problem. Yesterday it failed without any changes to the SQL A database operation failed with the following…

Azure SQL Database
asked 2025-06-04T21:24:52.7533333+00:00
Lun, Biondi 0 Reputation points
commented 2025-06-16T19:59:23.8066667+00:00
Erland Sommarskog 121.9K Reputation points MVP Volunteer Moderator
1 answer One of the answers was accepted by the question author.

Can't create a SQL Database server in East US region.

Hello Team, We would like to create a SQL Database server in East US region. But we see the following error - "Your subscription does not have access to create a server in the selected region. For the latest information about region…

Azure SQL Database
asked 2025-06-13T22:13:23.32+00:00
Rohit Khansili 20 Reputation points
commented 2025-06-16T16:16:59.8+00:00
Rohit Khansili 20 Reputation points
1 answer One of the answers was accepted by the question author.

Azure SQL database charges keep climbing while db is paused

Hello, I've observed that my Azure SQL database continues to accrue charges even when it is in a paused state. To clarify the current setup: The only service that connects to the database is an App Service hosting a Web API, which is currently…

Azure SQL Database
asked 2025-06-16T10:50:43.1866667+00:00
Jason Halvorson 20 Reputation points
commented 2025-06-16T13:19:13.0166667+00:00
Jason Halvorson 20 Reputation points
1 answer

Azure Database unable to update Datasync config & Datastudio timeout

We seem to be having 2x issues with an Azure SQL database. Datasync keeps failing sync data & reconfiguring of tables to sync. The database is timing out populating the tree of table in both SQL Management Studio & Azure Data Studio. The…

Azure SQL Database
asked 2025-06-04T08:05:01.6933333+00:00
John Tsui 0 Reputation points
answered 2025-06-16T12:03:29.0566667+00:00
PratikLad 1,830 Reputation points Microsoft External Staff Moderator
1 answer

Reconnect Issues in SSMS to Azure SQL DB with Microsoft Entra MFA After Role Reactivation

Connecting to Azure SQL DB with Microsoft Entra MFA from SSMS was successful previously. However, after the role assignment to the Privileged Identity Management Group expired and was re-activated, reconnection from the same SSMS instance fails to invoke…

Azure SQL Database
asked 2025-04-17T07:06:14.6233333+00:00
Jermy Hoffman 0 Reputation points
commented 2025-06-16T11:56:22.9466667+00:00
Micheal Hanlon 0 Reputation points
1 answer One of the answers was accepted by the question author.

Disaster Recovery Plan | How to Restore Azure SQL Database from One Resource Group to Another Across Regions

Hi Team, We recently encountered a limitation while trying to restore an Azure SQL Database from a source server in one resource group to a new SQL Server in another resource group (across regions) using Point-in-Time Restore. Scenario: We have an…

Azure SQL Database
asked 2025-06-05T06:44:46.4366667+00:00
Dinesh varma 20 Reputation points
accepted 2025-06-16T08:03:14.0666667+00:00
Dinesh varma 20 Reputation points
1 answer One of the answers was accepted by the question author.

Azure, Export Hyperscale Database to BacPac failed due to Vector datatype column in a table.

Trying to export a Hyperscale SQL database to Blob storage BacPac. I did som laborations with VECTOR datatype in one table an left it there for later laborations. The export fails due to the Vector column. ErrorMessage: "The ImportExport…

Azure SQL Database
asked 2025-06-13T13:33:35.3433333+00:00
Micael Uthas 20 Reputation points
accepted 2025-06-16T06:13:01.92+00:00
Micael Uthas 20 Reputation points
2 answers One of the answers was accepted by the question author.

What are the cost impact of increasing storage for databases in Azure SQL Elastic Pool

We’re using Azure SQL Databases in an Elastic Pool configuration with General Purpose: Standard-series (Gen5), 6 vCores, and I’m trying to understand how the cost is calculated for the elastic pool, especially regarding storage usage. My current…

Azure SQL Database
asked 2025-06-12T16:00:58.64+00:00
Palash Mathur 130 Reputation points
accepted 2025-06-16T05:44:47.55+00:00
Palash Mathur 130 Reputation points
1 answer

Azure SQL Managed Instance - A disconnect event was raised when server is waiting for Federated Authentication token

We are running Production workloads on Azure SQL Managed Instance, and periodically we see errors: A disconnect event was raised when server is waiting for Federated Authentication token. This could be due to client close or server timeout…

Azure SQL Database
asked 2024-08-28T17:34:06.17+00:00
Aleksey Vitsko 25 Reputation points
commented 2025-06-16T04:50:52.4133333+00:00
SSingh-MSFT 16,371 Reputation points Moderator
1 answer

Cannot see the list of available backups

I need to give one of our members access to see available backup list and give him the ability to restore. However, when he logged into the portal, he sees nothing on the list. This is for Azure Managed SQL instances.

Azure SQL Database
asked 2025-06-10T16:54:05.3433333+00:00
Brian Kim 20 Reputation points
commented 2025-06-16T00:53:32.5066667+00:00
Narendra Pakkirigari 475 Reputation points Microsoft External Staff Moderator
5 answers

How to connect from an azure VPN to an azure SQL server from my PC?

We want from our work computers using an azure VPN to be able to connect/access the databases we have in azure SQL/MySQL. I have read the documentation but I don't understand how it is possible to do this without having to connect from a virtual machine.…

Azure SQL Database
Azure VPN Gateway
Azure VPN Gateway
An Azure service that enables the connection of on-premises networks to Azure through site-to-site virtual private networks.
1,796 questions
Azure Virtual Network
Azure Virtual Network
An Azure networking service that is used to provision private networks and optionally to connect to on-premises datacenters.
2,775 questions
Azure Database for MySQL
Azure Database for MySQL
An Azure managed MySQL database service for app development and deployment.
995 questions
asked 2023-03-08T18:01:55.6466667+00:00
Alejandro García García 5 Reputation points
commented 2025-06-14T00:03:53.1966667+00:00
Andi B 0 Reputation points
1 answer

How to resolve the "Incorrect syntax near 'FORMAT'" with Parquet file

I'm working with Azure Sql connected to an Azure Storage account. I want to read a Parquet file from a Azure Storage account. This code works with a CSV, so I know the connection is good, but when I set the Format to Parquet I get Incorrect syntax…

Azure SQL Database
asked 2025-06-11T18:20:18.8766667+00:00
Anthony Morgan 0 Reputation points
commented 2025-06-13T19:41:29.2366667+00:00
Sai Raghunadh M 4,640 Reputation points Microsoft External Staff Moderator