412 questions with SQL Server on Azure Virtual Machines tags

Sort by: Updated
2 answers One of the answers was accepted by the question author.

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
asked 2021-02-06T07:36:55.763+00:00
Vishu 1,736 Reputation points
accepted 2021-06-21T13:52:11.563+00:00
Vishu 1,736 Reputation points
1 answer

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
asked 2021-06-09T01:52:39.137+00:00
NM 41 Reputation points
commented 2021-06-11T01:13:59.747+00:00
CarrinWu-MSFT 6,891 Reputation points
0 answers

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
Azure VPN Gateway
An Azure service that enables the connection of on-premises networks to Azure through site-to-site virtual private networks.
1,803 questions
asked 2021-06-04T11:13:15.013+00:00
Ashwin 1 Reputation point
commented 2021-06-07T03:09:45.243+00:00
SaiKishor-MSFT 17,336 Reputation points
1 answer

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
asked 2021-06-03T16:22:11.287+00:00
Ashwin Kumar 1 Reputation point
answered 2021-06-04T05:07:39.76+00:00
Martin Cairney 2,261 Reputation points
1 answer

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
asked 2021-05-28T09:31:00.98+00:00
Shivendoo Kumar 751 Reputation points
answered 2021-05-28T13:06:45.657+00:00
Alberto Morillo 34,681 Reputation points
1 answer

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
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
11,661 questions
asked 2020-11-11T02:23:50.233+00:00
grajee 371 Reputation points
commented 2021-05-20T19:01:58.793+00:00
OmarSiado-MSFT 156 Reputation points Microsoft Employee
2 answers

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
asked 2021-05-17T07:21:42.087+00:00
Dann Moredo 1 Reputation point
answered 2021-05-19T14:02:25.817+00:00
Pranathi Panyam_MSFT 1,066 Reputation points Microsoft Employee
1 answer

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
asked 2021-05-10T13:40:10.483+00:00
Yiyo-33 21 Reputation points
commented 2021-05-19T12:58:46.783+00:00
Yiyo-33 21 Reputation points
4 answers One of the answers was accepted by the question author.

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
asked 2021-04-20T15:48:50.75+00:00
Eber Souza 21 Reputation points
commented 2021-05-04T15:25:25.907+00:00
kobulloc-MSFT 26,811 Reputation points Microsoft Employee Moderator
3 answers One of the answers was accepted by the question author.

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 Virtual Machines
An Azure service that is used to provision Windows and Linux virtual machines.
9,068 questions
asked 2021-04-09T20:16:09.11+00:00
Ankit Rathod 391 Reputation points
answered 2021-05-04T07:37:12.32+00:00
Ankit Rathod 391 Reputation points
1 answer

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
asked 2021-04-12T16:02:31.71+00:00
Richelle Lanuza 21 Reputation points
commented 2021-04-20T15:28:34.92+00:00
prmanhas-MSFT 17,946 Reputation points Microsoft Employee Moderator
2 answers

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
asked 2021-04-19T08:48:39.2+00:00
Ernest 1 Reputation point
answered 2021-04-20T02:38:44.933+00:00
AmeliaGu-MSFT 14,006 Reputation points Microsoft External Staff
1 answer

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
asked 2021-03-04T17:43:01.737+00:00
Salves 501 Reputation points
commented 2021-04-14T05:03:59.217+00:00
prmanhas-MSFT 17,946 Reputation points Microsoft Employee Moderator
1 answer

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
asked 2021-04-06T21:26:48.187+00:00
PJL 1 Reputation point
commented 2021-04-10T01:05:52.443+00:00
SUNOJ KUMAR YELURU 15,496 Reputation points MVP
1 answer

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
Azure Virtual Machines
An Azure service that is used to provision Windows and Linux virtual machines.
9,068 questions
asked 2021-03-29T08:56:15.6+00:00
Ori Gilgun 61 Reputation points
commented 2021-03-30T20:44:28.617+00:00
Ori Gilgun 61 Reputation points
1 answer One of the answers was accepted by the question author.

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
Azure Synapse Analytics
An Azure analytics service that brings together data integration, enterprise data warehousing, and big data analytics. Previously known as Azure SQL Data Warehouse.
5,384 questions
asked 2021-03-25T14:49:54.84+00:00
Johnny Humphrey 186 Reputation points
accepted 2021-03-26T12:33:04.673+00:00
Johnny Humphrey 186 Reputation points
5 answers One of the answers was accepted by the question author.

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
Azure App Service
Azure App Service is a service used to create and deploy scalable, mission-critical web apps.
8,984 questions
asked 2021-03-12T10:01:22.15+00:00
karanlik 21 Reputation points
answered 2021-03-23T06:43:04.443+00:00
karanlik 21 Reputation points
2 answers One of the answers was accepted by the question author.

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
asked 2021-02-01T12:20:12.827+00:00
Sergei Kiselev 66 Reputation points
answered 2021-03-19T12:50:52.22+00:00
MANTOVANI Francesco 1 Reputation point
1 answer

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
asked 2021-03-18T14:17:32.253+00:00
Prince Kumar Rastogi 31 Reputation points
commented 2021-03-18T19:36:39.527+00:00
Prince Kumar Rastogi 31 Reputation points
1 answer

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…

SQL Server on Azure Virtual Machines
Azure SQL Database
asked 2021-03-12T18:52:10.177+00:00
Shubhi Jain 1 Reputation point
commented 2021-03-18T09:47:23.533+00:00
Shubhi Jain 21 Reputation points