412 questions with SQL Server on Azure Virtual Machines tags
MIgration from Onpremise to Azure
Dear Experts I have 2 Virtual Machine having SQL Server hosted on it. In a AS-IS migration , do I need to make any changes to the SQL Server post migration to Azure. Which All SQL Versions are supported by Azure in this case as I have SQL 2005 and…
SQL Server on Azure Virtual Machines
SQL Server | Other
How to create SQL active active instance
Hello, I have a webapp running in 2 separate regions West US and East US. There is a SQL multi subnet cluster configured which has nodes in each of the regions. Currently this is a Active/passive configuration in which the webapp talks to one of the…
SQL Server on Azure Virtual Machines
SQL Server | Other

How to connect to the ip hosted in the VM
hi, I have created a VM with win OS. i have installed SQL server and my ERP application to it. my software uses SQL as its database. I want to connect to his DB from outside network using the ip address. i tried the ICMP protocol opening suggested in…
SQL Server on Azure Virtual Machines
Azure VPN Gateway
Elastic pool agent jobs with SQL server on azure vms
I have a setup where I have sql server running in an azure vm. I would like to have my elastic pool agent connect to this server to run a few jobs. Is this supported at this time?
SQL Server on Azure Virtual Machines

Need to implement High availibalilty for Customer Information lookup on Website?
Hi All, Looking for a robust and cost-effective solution for this requirement: We have customer information (2-3 million rows) and it is used across the website as a lookup. Looking for a solution to quick lookup of customer database. How about…
SQL Server on Azure Virtual Machines
Azure SQL Database


SQLServer on IaaS VM of Azure Cloud and Integration Runtime
All, We are working on a process to load AzureSQL PaaS DB with data from several SQLServer data sources. Some of them are On-Prem and some are in vNet (SQLServer on VMs in Azure IaaS). I'm aware that Integration runtime is needed for SQLServers…
SQL Server on Azure Virtual Machines
Azure Data Factory
SQL Log shipping version
Can I configure log shipping running on SQL Server 2012 going to SQL Server 2019?
SQL Server on Azure Virtual Machines
Windows 2016 cluster nodes , unable to reach internet after creating cluster with Azure Vms.
I have 3 VMS in Azure. 3 vms in same Vnet and subnet. 1 DC with domain foo.bar.local 10.83.48.4 VM1 2016 with SQL joined to that domain with name: VM1. foo.bar.local 10.83.48.5 VM2 2016 with SQL joined to that domain with name: VM1.…
SQL Server on Azure Virtual Machines
License downgrade rights in AZURE
I have SQL Server Enterprise 2019 Core licenses with Software Assurance and want to activate Azure Hybrid Benefit on virtual machines on Azure. Does the same Downgrade rights for versions applied in an on-premises environment also apply to Azure? …
SQL Server on Azure Virtual Machines
SQL 2016 Backup for IaaS VM
I'm planning on hosting a set of servers in Azure. Some of these servers will run SQL Server 2016. These servers will be deployed to different data centers in the same Azure region. These will be part of an Always On availability group i'll backup the…
SQL Server on Azure Virtual Machines
Azure Virtual Machines
Azure Instance Glitch
May I know why the D Series Core is Saved but the summary is still in vCPU? Is there any glitch in this concern? Or the Core will also tag/same in VCPU?
SQL Server on Azure Virtual Machines


Instance SQL SERVER Web Hosting
Hi, I would like to know if I can create Instances with SQL server web Hosting license? Thank you in advance.
SQL Server on Azure Virtual Machines
SQL Server | Other
Timeout errors for asynchronous secondary replica
Hi, we set up an Always One Cluster a few months ago and everything is working very well. We did simulations of faiolver for both the synchronous replicaca and also for the asynchronous and everything is fine. But after setting up some alarms, we…
SQL Server on Azure Virtual Machines


Problem accessing SQL Managed Instance from on-prem network
I am trying to connect to an Azure SQL Server Managed Instance from my on-prem network which is connected to Azure via a Gateway VPN. The gateway VPN terminates in VNET A and the SQL Server Managed Instance is in its own standalone VNET B. Do I need…
SQL Server on Azure Virtual Machines
Azure SQL Database

Event ID 60621 on Azure VM with SQL Server
Hello, I have 3 Azure VMs running SQL Server on them and all have the same warning message in event viewer every 35 seconds: [Warning] ServerConfigurationsManagementGetSqlStorageDataErrored: System.Exception: Error occurred when attempting to query…
SQL Server on Azure Virtual Machines
Azure Virtual Machines
Which Synapse Connector to use for SQL Server on Azure VM?
We have some SQL Servers on Azure VMs that we would like to use as Synapse sources. The VMs are on an Azure Virtual Network. We use Azure Active Directory for authentication to the database. The following seem to fall under Azure SQL in the…
SQL Server on Azure Virtual Machines
Azure Synapse Analytics
Unable to connect to SQL Server running on VM from Azure Web App
Hi all, I've some connectivity issues between an SQL server running on an VM (on Azure) and an Azure Web App connected to the same VNET. Setup details; VM Name: vmtest1 SQL Server running on 1433 (and I can connect to this SQL Server via…
SQL Server on Azure Virtual Machines
Azure App Service
Correlation between Azure VM to Azure SQL
Hi, To reduce cost, I want to migrate SQL database from Azure VM to Azure SQL. I found a lot of guides hot to do this. But I can't find information about tiers comparation. For example, I have VM with size D4 V4. What type for SQL server should I…
SQL Server on Azure Virtual Machines
Azure SQL Database
Vulnerability assessment findings on SQL VM Showing wrong info
We have few Vulnerability assessment findings on SQL VM from Security Center for which there is no Remediation step and add to baseline is also disabled. When I am running that query on SQL Server for that specific database, I am not getting any result…
SQL Server on Azure Virtual Machines
Microsoft Security | Microsoft Defender | Microsoft Defender for Cloud


Migration From on-premises to Azure SQL Managed Instance using LRS
https://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/log-replay-service-migrate using this above link I have done the migration in autocomplete mode and the database has been created in Azure SQL Managed Instance successfully, but while…