417 questions with SQL Server on Azure Virtual Machines tags
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
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

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
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
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
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
Developer technologies | Transact-SQL
SQL Server | Other
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
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
How to filter out Azure VM's compute, license, and underlying software cost from cost details data
What are all the line items that give info about the compute cost of VM and its license cost, and any preinstalled software cost for an Azure resource/VM? Example: We are running SQL Server on windows , and I want to separate out the cost for VM compute,…
SQL Server on Azure Virtual Machines
Azure Cost Management
Windows for business | Windows Server | Devices and deployment | Licensing and activation

Issue in Linked Server from Azure SQL VM to Azure SQL database
Script.txt Hi, I have created linked server on Azure sql VM (not on domain) to connect Azure SQL database. It works fine for admin users but non admin users get msg: Msg 7416, Level 16, State 2, Line 6 Access to the remote server is denied because no…
SQL Server on Azure Virtual Machines
Retrieve an SQL standard license for in place upgrade
We are running a SQL virtual machine SQL server under a developer license that needs to be upgraded to a standard SQL license. The payment for the SQL license is done through Azure so no license keys in our control. Now with the upgrade through the…
SQL Server on Azure Virtual Machines
SQL Server | Other

How to add authentication to SSRS API call from Postman?
Hi, I am trying to use the SSRS REST API as documented here. I am posting here since this Q&A forum was listed as the support forum on a derivative link here. When I make a call in my browser, such as http://my-server/reports/api/v2.0/CatalogItems I…
SQL Server on Azure Virtual Machines
Sql server to Parquet file date missmatch using ADF copy data activity
Hi , I am doing copy data activity in adf Source - Sql server Sink - parquet file When doing copy Date field is changing From 0001-01-01 is changing to 0001-01-03 in parquet. It is incrementing the day by 2 in parquet file. …
SQL Server on Azure Virtual Machines
Azure Data Factory
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…
SQL Server on Azure Virtual Machines

Can't delete resource.
Never mind, was a user issue and it's now solved. Sorry!
SQL Server on Azure Virtual Machines
Decommissioning Azure Storage Accounts for Backup with Azure SQL Managed Instance
The current setup in Azure includes: Primary region: Two SQL Servers enabled for Failover Cluster Instance (FCI) sharing the same data disk, taking backups to Azure Blob storage with Geo-Redundant Storage (GRS). Secondary region for Disaster Recovery…
SQL Server on Azure Virtual Machines
Azure Data Base, Tier elastic Premium
Hello! I have a database in the Elastic Pool Premium tier of 125 eDTUS. I'm getting the following error message: Exception: Microsoft.Data.SqlClient.SqlException Message: Resource ID: 1. The request limit for the database is 40 and has been reached. My…
SQL Server on Azure Virtual Machines
Can't see SQL Server 2019 Standard on Windows Server 2022
Hi - I've deployed SQL Server 2019 Standard on Windows Server 2022 and hoping the SQL server would be available as soon after the deployment but can't see it. Could someone let me know if i need to enable anything to see the SQL on VM please?
SQL Server on Azure Virtual Machines
Unable to Access SQL Server Database on Azure VM After Deploying API to Azure Container Apps
Hello, I have set up an Azure Virtual Machine (VM) where I have my development environment configured, including Visual Studio Code 22 and SQL Server. Recently, I deployed my API using Azure Container Apps. However, I am encountering issues when trying…
SQL Server on Azure Virtual Machines
How to update the SqlIaasExtension on Azure VM from lightweight mode to Full mode
Hi, How to update the SqlIaasExtension on Azure VM from lightweight mode to Full mode. Also, how and where can we see the mode of SqlIaasExtension on the Azure VM? Regards, VJ