428 questions with SQL Server on Azure Virtual Machines tags

Sort by: Updated
0 answers

How to enable SQL best practices assessments for SQL VMs via Powershell (not CLI)

I am using Powershell and the Update-AzSqlVM cmdlet to enable the features included with the SQL Server IaaS extension. I have been able to successfully Configure Storage via -SqlManagementType 'Full' parameter, but having trouble with the Enable SQL…

SQL Server on Azure Virtual Machines
asked 2025-10-21T18:27:00.6333333+00:00
Paul Sebestyen 0 Reputation points
edited a comment 2025-10-24T15:04:28.6366667+00:00
Swapnesh Panchal 740 Reputation points Microsoft External Staff Moderator
3 answers One of the answers was accepted by the question author.

Preventing Database Deletion in SSMS

prevent accidental database deletions within SQL Server Management Studio (SSMS). Currently, I am exploring options to enforce this restriction effectively implemented a DDL trigger Is the above DDL trigger approach appropriate for preventing…

SQL Server on Azure Virtual Machines
Developer technologies | Transact-SQL
Developer technologies | Transact-SQL
A Microsoft extension to the ANSI SQL language that includes procedural programming, local variables, and various support functions.
4,710 questions
SQL Server | Other
asked 2024-06-28T13:20:16.26+00:00
Niket Kumar Singh 830 Reputation points
answered 2025-10-24T13:17:36.25+00:00
Ramana Kopparapu 306 Reputation points
1 answer

Where can I read the transcript for the Azure SQL

I would like to read instead of listening all the time

SQL Server on Azure Virtual Machines
asked 2025-10-14T15:55:26.2966667+00:00
renee fontan 0 Reputation points
commented 2025-10-21T03:59:05.0533333+00:00
Pratyush Vashistha 4,255 Reputation points Microsoft External Staff Moderator
2 answers One of the answers was accepted by the question author.

Health Probe Failing After Azure Load Balancer SKU Upgrade – One SQL Server Unhealthy

We have an Azure setup with a SQL pool containing two SQL servers (SQLServer-0 and SQLServer-1) behind a Load Balancer. The Load Balancer is configured with a custom TCP health probe on port 59999. Everything was working as expected prior to upgrading…

SQL Server on Azure Virtual Machines
asked 2025-10-03T12:10:31.6133333+00:00
GOPINATH M 60 Reputation points
commented 2025-10-17T10:17:50.39+00:00
Pratyush Vashistha 4,255 Reputation points Microsoft External Staff Moderator
1 answer

How can I increase the size of the data disk on a Windows Server VM running SQL Server?

Hi, I have a Windows Server VM on Azure that is running SQL Server. Its size is Standard E4bds v5 and it was created from the sql2022-ws2022 source image offer. It has a single P30 Premium SSD LRS data disk of swize 1024GiB. I want to increase the size…

SQL Server on Azure Virtual Machines
asked 2025-10-10T02:08:16.9533333+00:00
Daniel-08125 0 Reputation points
commented 2025-10-16T23:19:37.7066667+00:00
TP 141.6K Reputation points Volunteer Moderator
1 answer

SQL virtual machine version upgrade

We are currently using SQL virtual machine 2016 version standard edition the end of support is going to reach at July14, 2026. So, we are plaining to upgrade the SQL virtual machine to 2022 version. our Virtual machine size is Standard E8-4ads v5. We…

SQL Server on Azure Virtual Machines
asked 2025-10-15T10:11:48.43+00:00
Dhanushkumar J 0 Reputation points
answered 2025-10-16T09:03:56.88+00:00
Kalyani Kondavaradala 3,145 Reputation points Microsoft External Staff Moderator
2 answers

VM Started Automatically to Create/Update/Delete Virtual Machine Extension by SQLVMResourceProviderAuth

I noticed that 3 of my VMs were automatically started by a system process and left running. It seems to be related to creating or updating and then deleting virtual machine extensions by the SQLVMResourceProviderAuth entity. Events (both on the same…

SQL Server on Azure Virtual Machines
asked 2025-10-03T14:45:50.17+00:00
tonypinter 0 Reputation points
commented 2025-10-06T08:00:20.6366667+00:00
Abhisek Mishra 845 Reputation points Microsoft External Staff Moderator
1 answer

How to remove SQL Server 2017 after in-place upgrade to 2022 on Azure SQL VM?

Hi community members, I’ve completed an in-place upgrade of SQL Server from 2017 to 2022 on an Azure SQL VM using this Microsoft guide: Change SQL Server version on Azure VM. The upgrade went fine, and the VM is re-registered with the SQL IaaS Agent…

SQL Server on Azure Virtual Machines
asked 2025-09-17T18:58:10.8633333+00:00
Nikunj Patel 20 Reputation points
edited a comment 2025-09-22T07:10:42.17+00:00
Abhisek Mishra 845 Reputation points Microsoft External Staff Moderator
2 answers

Recovery Pending mode.

Hello, Last night we increased the CPU and RAM size of our production Windows machine running on Azure to optimize performance and manage credits more efficiently. However, after the resize operation, our SQL Server databases have gone into Recovery…

SQL Server on Azure Virtual Machines
asked 2025-09-12T03:49:56.52+00:00
Nasuh Akın 0 Reputation points
commented 2025-09-17T02:10:42.8+00:00
Pratyush Vashistha 4,255 Reputation points Microsoft External Staff Moderator
1 answer

With SQL Server 2019, how do you configure PMEM on an Azure VM?

As a DBA relatively new to the Azure VM environment, do you have the ability to configure SQL Server 2019 as described in https://free.blessedness.top/en-us/sql/database-engine/configure-windows/configure-persistent-memory?view=sql-server-ver17. I have…

SQL Server on Azure Virtual Machines
asked 2025-08-29T18:55:50.8333333+00:00
Hulings, David 5 Reputation points
commented 2025-09-08T15:48:10.8666667+00:00
VRISHABHANATH PATIL 1,295 Reputation points Microsoft External Staff Moderator
1 answer One of the answers was accepted by the question author.

Memory issue on Azure SQL Server VM

Hi Team, Need your help to troubleshoot. high memory issue on one of the SQL Server on Azure Virtual Machine. No other application installed on this VM. its dedicated to SQL only. Here is the existing setting at SQL : Total Memory in VM server: 64…

SQL Server on Azure Virtual Machines
asked 2025-08-19T23:56:49.74+00:00
Vijay Kumar 2,061 Reputation points
accepted 2025-08-26T17:49:37.0533333+00:00
Vijay Kumar 2,061 Reputation points
1 answer

How do I deploy an Azure SQL VM?

I am trying to start up a Windows 2022 VM with Developer's Edition SQL 2022. It's a menu option, so it seems this should be pretty straightforward. It fails with MSSQL Service failing to start -- every time. I am largely taking defaults -- main…

SQL Server on Azure Virtual Machines
asked 2025-08-19T11:19:28.9333333+00:00
Steven K. Mariner 0 Reputation points
commented 2025-08-21T05:51:08.1666667+00:00
Saraswathi Devadula 13,330 Reputation points Microsoft External Staff Moderator
2 answers

BACKUP LOG Write Fail to Azure Storage

Hello, We have a SQL VM running out of Azure with SQL Agent jobs running BACKUP LOG every x hours to Azure Blob. These jobs have been running fine for a long time until recently. We keep getting the below error and these jobs fail intermittently for…

SQL Server on Azure Virtual Machines
Azure Storage
Azure Storage
Globally unique resources that provide access to data management services and serve as the parent namespace for the services.
3,663 questions
Developer technologies | Transact-SQL
Developer technologies | Transact-SQL
A Microsoft extension to the ANSI SQL language that includes procedural programming, local variables, and various support functions.
4,710 questions
SQL Server | Other
asked 2022-06-13T18:07:29.267+00:00
sidney l 21 Reputation points
answered 2025-07-02T21:20:53.65+00:00
Andy Soushek 0 Reputation points
0 answers

A critical resource (SQL) was deleted from VM. I need to restore it.

The resource related to hosting SQL on a VM was deleted. Is there a way to restore the resource and recover the lost data? It would be ok to reset the VM to a previous state if that is what needed to be done. There is currently a web site outage…

SQL Server on Azure Virtual Machines
asked 2025-06-12T16:20:07.6033333+00:00
Christopher Blanchard 0 Reputation points
commented 2025-06-12T16:51:11.0266667+00:00
Sai Raghunadh M 4,570 Reputation points Microsoft External Staff Moderator
0 answers

Facing Ext_StorageConfigurationSettings_ArgumentError Issue while deploying Azure SQL VM via Bicep – Storage Configuration Error and Default File Path Not Applied

Facing Ext_StorageConfigurationSettings_ArgumentError Issue while deploying Azure SQL VM via Bicep – Storage Configuration Error and Default File Path Not Applied   I am deploying an Azure SQL Virtual Machine using Bicep, but I’m encountering an error…

SQL Server on Azure Virtual Machines
asked 2025-06-27T08:16:13.14+00:00
nikita tiwari 25 Reputation points
commented 2025-07-02T21:09:10.4133333+00:00
Mahesh Kurva 9,575 Reputation points Microsoft External Staff Moderator
1 answer

How to allow remote connections to SQL server on an Azure VM through an Azure VPN

I have a Virtual machine on my azure network that is accessed by an Azure VPN via a virtual network gateway. I need to allow a user to connect to SQL server on that VM. I dont want to open 1433 and 1434 to the whole internet and the user does not have a…

SQL Server on Azure Virtual Machines
asked 2025-07-23T13:12:01.03+00:00
Kyle Sicard 20 Reputation points
commented 2025-07-25T04:47:33.7+00:00
Saraswathi Devadula 13,330 Reputation points Microsoft External Staff Moderator
1 answer

How to provide edition upgrade for existing VM without rebuild

We have an existing Azure VM with SQL Server Express installed and customised. We need to upgrade the SQL Server instance to Web Edition without redeploying the VM. We are licensed through Azure and want to be billed for Web Edition. Can you help us…

SQL Server on Azure Virtual Machines
asked 2025-07-23T15:07:40.36+00:00
David Carey 0 Reputation points
commented 2025-07-25T17:19:47.6633333+00:00
Mahesh Kurva 9,575 Reputation points Microsoft External Staff Moderator
2 answers One of the answers was accepted by the question author.

Need SQL Server 2019 Standard Setup Support for SSRS/SSIS on Separate Azure VM (PAYG)

We have a Linux VM in Azure running SQL Server 2019 Standard (Pay-As-You-Go), provisioned via Marketplace. We're restructuring and moving SSRS/SSIS to a separate Windows Server 2019 VM (also in Azure). During SSRS setup on the new VM, it's asking for a…

SQL Server on Azure Virtual Machines
asked 2025-07-28T12:02:42.38+00:00
Jimin Dev 20 Reputation points
accepted 2025-07-29T14:04:57.56+00:00
Jimin Dev 20 Reputation points
2 answers

Data disk space is low

Action is needed immediately to prevent data/application issues. Our SQL data drive is getting full; we have increased the VM to resize the disk but still the vm shows the same size. And the SQL is almost full.

SQL Server on Azure Virtual Machines
asked 2025-07-30T01:10:39.7033333+00:00
Deena Sridharan 0 Reputation points
commented 2025-07-31T03:09:03.2633333+00:00
TP 141.6K Reputation points Volunteer Moderator
1 answer One of the answers was accepted by the question author.

Network security group to allow inbound 1433 connections not working as expected in SQL Virtual Machine

Hi all, I'm using the following to deploy a SQL Server virtual machine. This machine allows mixed type authentication and allows external connections. imageReference { publisher: 'microsoftsqlserver' offer: 'sql2022-ws2022' sku:…

SQL Server on Azure Virtual Machines
asked 2025-08-09T00:39:39.2966667+00:00
Cameron Collver 20 Reputation points
accepted 2025-08-11T16:08:35.81+00:00
Cameron Collver 20 Reputation points