400 questions with SQL Server on Azure Virtual Machines tags
Check the linked service configuration is correct, and make sure the SQL Database firewall allows the integration runtime to access
Currently we are migrated all ADF pipeline, Datasets, linked service etc to the new Fabric environment. and during testing, we encountered an connectivity issue. As I am trying to create new linked service to point to the on-Prem Sql server. however…
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…
MDS Web link is not working for Azure AD users
I have installed SQL Server on Azure VM along with MDS. i have configured Azure AD (Microsoft Entra ID) on Azure VM. Users are Able to login system with Azure AD and also able to connect SQL Server using Azure Active Directory - Integrated authentication…
Resource is not available to restore DB backup in azure
Hi Team, Azure DB scheduled backup is stuck and Unable to restore DB backup as resorce is not available. Please do the needful
Azure SQL Server VM
We have an Azure subscription (type = Azure Plan) and have deployed an Azure VM using the Microsoft marketplace template ('Windows Server 2022 with SQL Server 2022 Standard'). Please note, this is an Azure Windows VM running SQL Server, not an Azure SQL…

restore backup is fasiling
restore is failing, whenm i try restoring a database backup all options are failing, restoring on a sql vm does not find the instance, so it says that not all fields are compiled, restoring to a file is failing and also restoring on thew original…
How to Rename an Azure SQL VM and Managed Disks without Affecting SQL Server?
We have a SQL Server Azure Virtual Machine (Win/SQL 2022) that was deployed using a marketplace image and is currently running. This VM was set up as part of a SQL Server Migration project from on-premises to the cloud, where some databases have already…
Issue with the sandbox being unavailable on Microsoft Azure Fundamentals
Hey everyone, I’ve been trying to use the MS Learn Sandbox for a module, but I keep running into this annoying error message: “The sandbox for this module is currently unavailable. We're working to resolve this as quickly as possible. In the meantime,…
how to user correctly function OPENROWSET to access excel spreadsheet as SQL table?
see bellow the commands that I used and the mistakes that I received and the same error happend in SQL server management Studio and Azure Data Studio. USE [master] --CONFIGURANDO À INSTÂNCIA SQL PARA ACEITAR OPÇÕES AVANÇADAS EXEC sp_configure 'show…

Backup SQL VM, Cancel/Delete SQL VM resources and reservation
I am in the process of archiving an SQL VM and I would like to take backup of that resource and download it outside of the environment. After the backup is completed I would like to delete the VM and all of its associated resources and reservations.…
The certificate with identifier used to sign the client assertion is expired on application
Hi Team, I am trying to create some external tables from the azure synapse on the parquet files that I have load into the Azure Data Lake storage Gen2. I also created the app in azure directly and extended the expiry date and also provided the Synapse…
What is the replacement for SQL Insights for SQL Server in Azure VM?
Hi, I am just wondering about the below Note on the SQL Insights Preview feature. What is the replacement monitoring tool for SQL Server in Azure VM as SQL Insights has retired and database watcher does not support SQL in Azure…

In azure sql virtual machine deployment can we use specific (additional) disk for SQL installation
In azure sql virtual machine deployment can we use separate (additional) managed disk for SQL installation instead of the C drive or OS drive

Unable to Send Emails from SQL Server
There is an issue with sending emails from SQL Server, accompanied by the following error message: The mail could not be sent to the recipients because of the mail server failure. (Sending Mail using Account 2 (2024-12-03T11:05:46). Exception Message:…
How to register my Azure VM with the SQL IaaS Agent Extension
I deployed a Azure VM and installed SQL 2019 (as opposed to deploying a SQL Server VM from marketplace with SQL pre-installed). I was reading about the benefits of SQL IaaS Agent Extension. See the following article: "Register SQL Server VM…
Listener IP Not Reachable from Primary Server in Hybrid Availability Group Setup
Hello there, I have configured a 3-node SQL Server Availability Group with the following setup: Primary Node: On-premises (10.10.1.10) HA Node: On-premises (10.10.1.11) DR Node: Azure VM (10.0.0.4) The listener is configured with two IP addresses…
SSRS license on a separate sql server vm
I have a VM on Azure IaaS Sql server 2019 Standard. I would like to install SSRS on a separate VM. Would I need a new license for this?
Connect to SQL Server on Azure VM with Microsoft Entra managed identity authentication failed
I enabled Microsoft Entra authentication for SQL Server on Azure VM, and I can connect with this sql server using user assigned manage identity with SSMS successfully, but when I try to connect to this sql server in C#, I get below error…
Error installing SqlIaasExtension during VM deployment
N-th attempt to create and deploy an Azure SQL VM fails with the status "conflict" in operations details and the following details: { "status": "Failed", "error": { "code":…
SQL Server 2019 SKU Upgrade for Entra
I am looking to upgrade our 2019 instance to 2022 with in place upgrade. The database and server was created using a template in Azure for "SQL Server Standard 2019 on Windows Server 2022". We would like to enable Entra Authentication. …