SQL Server on Azure Virtual Machines
An Azure service that is used to provision Windows and Linux virtual machines.
398 questions
398 questions with SQL Server on Azure Virtual Machines tags
0 answers
Best way to build an AAG cluster in Azure? Do yo uuse the AZ Port template, the Market Place template "SQL with High Avaialability" or build the SQL VMs separatelyu and add them to a WGC and create the AAGS?
Hello. We have used the Az Market place template, "SQL Server With High Availability" to build two Az SQL Server 2022 2-Node Active AAG clusters each with an Az file share witness. But have hit problems with it - can't increase storage…
asked 2025-01-27T16:06:56.1133333+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, 7.000000000000001%, 20%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EEM%3C/text%3E%3C/svg%3E)
Ewen Miller
0
Reputation points
asked 2025-01-27T16:06:56.1133333+00:00
Ewen Miller
0
Reputation points
1 answer
How to Register SPN for MSA/gMSA in SQL Server on Azure VMs
A server farm consisting of about 20 Azure SQL VMs is undergoing a security hardening exercise. The goal is to transition from built-in and individual domain accounts to Managed Service Accounts (MSA) and Group Managed Service Accounts (gMSA) to…
asked 2025-01-26T20:36:06.2033333+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(73.60000000000001, 55.00000000000001%, 17%)' 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)
Abimbola Adeniran
66
Reputation points
commented 2025-01-27T10:49:23.0133333+00:00
Abimbola Adeniran
66
Reputation points
0 answers
How to disable Storage Pools/Disks to be available to other nodes in SQL Cluster?
I am creating a SQL Cluster in Azure. This SQL cluster is mostly based on the Microsoft documentation article called "Tutorial: Configure an availability group in multiple subnets (SQL Server on Azure VMs)". This way you can create an SQL…
asked 2025-01-20T13:46:16.21+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(73.60000000000001, 69%, 17%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EEE%3C/text%3E%3C/svg%3E)
Eldin Egrlic
0
Reputation points
edited the question 2025-01-27T10:35:07.09+00:00
TP
102K
Reputation points
0 answers
Unable to login to the VM as soon as it is added in Failover Cluster as part of SQL AAG setup
Hi Team, We are unable to login to the VM as soon as it is added in Failover Cluster as part of SQL AAG setup. We have deployed a new and tried the same again we are unable to login to the VM and unable to ping it. This is as part of a new SQL AAG…
asked 2025-01-23T11:39:19.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(89.60000000000001, 25%, 18%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EV8%3C/text%3E%3C/svg%3E)
VJ-8370
486
Reputation points
commented 2025-01-27T09:33:42.76+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(35.2, 49%, 13%)' 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)
Vijayalaxmi Kattimani
985
Reputation points Microsoft Vendor
0 answers
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…
asked 2025-01-21T15:25:31.4566667+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, 10%, 37%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ECS%3C/text%3E%3C/svg%3E)
CARLITO SENA
0
Reputation points
commented 2025-01-22T21:10:14.1533333+00:00
CARLITO SENA
0
Reputation points
2 answers
One of the answers was accepted by the question author.
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,…
SQL Server on Azure Virtual Machines
SQL Server on Azure Virtual Machines
An Azure service that is used to provision Windows and Linux virtual machines.
398 questions
Azure Machine Learning
Azure Machine Learning
An Azure machine learning service for building and deploying models.
3,087 questions
Azure Virtual Machines
Azure Virtual Machines
An Azure service that is used to provision Windows and Linux virtual machines.
8,283 questions
Microsoft Teams
Microsoft Teams
A Microsoft customizable chat-based workspace.
10,738 questions
Azure OpenAI Service
Azure OpenAI Service
An Azure service that provides access to OpenAI’s GPT-3 models with enterprise capabilities.
3,577 questions
asked 2025-01-02T21:25:40.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(128, 14.000000000000002%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ELB%3C/text%3E%3C/svg%3E)
luis baldassari
45
Reputation points
commented 2025-01-21T18:02:30.31+00:00
Oury Ba-MSFT
20,176
Reputation points Microsoft Employee
1 answer
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.…
asked 2024-12-31T20:32:23.9066667+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(240, 53%, 33%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ENA%3C/text%3E%3C/svg%3E)
Neuro Alert
0
Reputation points
commented 2025-01-06T08:54:22.7833333+00:00
Vijayalaxmi Kattimani
985
Reputation points Microsoft Vendor
1 answer
One of the answers was accepted by the question author.
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…
asked 2022-10-18T17:49:34.617+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(73.60000000000001, 78%, 17%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EPM%3C/text%3E%3C/svg%3E)
Prashant Meshram
46
Reputation points
commented 2025-01-06T00:54:14.8833333+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, 64%, 40%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERD%3C/text%3E%3C/svg%3E)
Rustin Davitt
20
Reputation points
2 answers
One of the answers was accepted by the question author.
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…
asked 2025-01-02T15:31:13.3333333+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, 8%, 21%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAS%3C/text%3E%3C/svg%3E)
Ammara Sheikh
40
Reputation points
commented 2025-01-02T23:38:46.0966667+00:00
Oury Ba-MSFT
20,176
Reputation points Microsoft Employee
1 answer
One of the answers was accepted by the question author.
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…
asked 2025-01-02T09:34:52.93+00:00
Abimbola Adeniran
66
Reputation points
accepted 2025-01-02T10:54:30.63+00:00
Abimbola Adeniran
66
Reputation points
2 answers
One of the answers was accepted by the question author.
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
asked 2024-12-24T10:55:57.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(281.6, 30%, 37%)' 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)
Stalin Rayala (External)
20
Reputation points
commented 2024-12-27T22:00:23.5866667+00:00
Erland Sommarskog
116K
Reputation points MVP
1 answer
One of the answers was accepted by the question author.
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:…
asked 2024-12-23T08:38:01.5766667+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(32, 8%, 13%)' 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)
Avinash
20
Reputation points
commented 2024-12-23T11:44:18.4133333+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(150.4, 60%, 24%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ENK%3C/text%3E%3C/svg%3E)
Naveen Kumar M
75
Reputation points
1 answer
One of the answers was accepted by the question author.
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…
asked 2021-06-28T20:55:18.807+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(150.4, 89%, 24%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EDC%3C/text%3E%3C/svg%3E)
David C
191
Reputation points
commented 2024-12-09T04:04:55.3433333+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(195.2, 64%, 28%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAJ%3C/text%3E%3C/svg%3E)
Andrew Janke
65
Reputation points
0 answers
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…
asked 2024-11-28T09:32:15.04+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, 14.000000000000002%, 14%)' 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)
kedar giri
81
Reputation points
commented 2024-12-03T15:52:32.7433333+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
1,915
Reputation points Microsoft Vendor
4 answers
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?
asked 2024-11-26T16:13:05.8833333+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(96, 32%, 19%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EPR%3C/text%3E%3C/svg%3E)
PHILIPE RIBEIRO MENDONCA
0
Reputation points
commented 2024-11-29T10:39:19.67+00:00
Sai Raghunadh M
1,915
Reputation points Microsoft Vendor
1 answer
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…
asked 2024-11-13T09:46:32.2+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, 73%, 20%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EHG%3C/text%3E%3C/svg%3E)
Huichao Gong (Shanghai Wicresoft Co Ltd)
0
Reputation points Microsoft Vendor
commented 2024-11-21T08:51:03.9966667+00:00
Vijayalaxmi Kattimani
985
Reputation points Microsoft Vendor
1 answer
One of the answers was accepted by the question author.
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":…
asked 2024-11-13T14:19:01.2866667+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(134.4, 14.000000000000002%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ETG%3C/text%3E%3C/svg%3E)
TATYANA GRIBNIKOVA
20
Reputation points
accepted 2024-11-18T18:28:36.9233333+00:00
TATYANA GRIBNIKOVA
20
Reputation points
1 answer
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. …
asked 2024-11-13T16:56:05.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(128, 20%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERH%3C/text%3E%3C/svg%3E)
Robin Halabicki
1
Reputation point
commented 2024-11-18T13:36:17.7933333+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(252.8, 60%, 34%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMK%3C/text%3E%3C/svg%3E)
Mahesh Kurva
2,095
Reputation points Microsoft Vendor
2 answers
SQl server is not connecting.
Hi Team, We are facing an issue with SQL Server connectivity. We hosted windows SQL 2022 Server in Azure. and every 30 days the connection to the Database is crashing and getting this below error message. Can anybody help on this issue? A…
asked 2024-11-05T06:25:09.55+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(288, 21%, 37%)' 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)
Vishakhan K
5
Reputation points
edited the question 2024-11-11T05:32:37.14+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(227.2, 46%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ENN%3C/text%3E%3C/svg%3E)
NIKHILA NETHIKUNTA
4,425
Reputation points Microsoft Vendor
1 answer
One of the answers was accepted by the question author.
UK region Multi AZ query
Hi, I am looking to design a multi AZ highly available application on Azure. Please let me know if multi AZ is supported in UK West region? We are looking to host our SQL DB on an Azure VM with application content store as Azure Files.
asked 2024-11-09T12:41:30.62+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(262.40000000000003, 23%, 35%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAR%3C/text%3E%3C/svg%3E)
Ankit Rana
20
Reputation points
accepted 2024-11-09T13:49:10.9266667+00:00
Ankit Rana
20
Reputation points