SQL Server on Azure Virtual Machines
An Azure service that is used to provision Windows and Linux virtual machines.
362 questions
362 questions with SQL Server on Azure Virtual Machines tags
1 answer
Linked server between a SQL Managed Instance and an Azure VM-based SQL Server in different virtual networks?
We have a requirement to set up a linked server connection from our Azure SQL Managed Instance which sits in VNET A to a 'regular' SQL Server installation running on an Azure VM, which sits in VNET B (which is in a different region). Despite various…
asked 2023-09-08T15:05:41.6933333+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, 93%, 13%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EES%3C/text%3E%3C/svg%3E)
Elliot Stansfield
1
Reputation point
answered 2023-09-08T21:39:38.88+00:00
Oury Ba-MSFT
16,901
Reputation points Microsoft Employee
1 answer
Xollam Ransomware in Azure Hosted SQL server
We got attacked by Xollam Ransomware to our SQL server which is hosted in Azure, what is the mitigation steps for it ?
asked 2023-08-21T20:12:14.7566667+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, 1%, 37%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EP%3C/text%3E%3C/svg%3E)
PR
130
Reputation points
commented 2023-08-29T04:26:01.24+00:00
vipullag-MSFT
25,126
Reputation points
3 answers
One of the answers was accepted by the question author.
We need to migrate the 1.5 TB data (prod env) from Oracle on premises, what's the best target database to migrate?
Hi, I want to migrate the 1.5 TB data from the oracle on premises to the below target database. We want low latency, high performance. On premises sql server. Azure sql database. Managed sql database. Tool for Migration- ADF Does ADF support…
asked 2023-08-09T08:22:58.1966667+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(3.2, 68%, 10%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ER%3C/text%3E%3C/svg%3E)
Rahul
251
Reputation points
edited a comment 2023-08-14T15:19:27.49+00:00
Alberto Morillo
33,161
Reputation points MVP
1 answer
Does azure SQL server in the VM support transactions are synchronized at various sites
Dear Whether the Azure SQL Server in the VM supports data synchronization across sites？ We have serval servers; one is the azure VM, Others are the local servers. We deployed the SQl server in the azure VM as the data central server. Please refer to the…
![](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(38.4, 26%, 13%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EYN%3C/text%3E%3C/svg%3E)
1 answer
One of the answers was accepted by the question author.
My Azure VM - SQL2008R2SP3 is scheduled for deprecation. Will it continue to work after deprecation date and what will be if after that date my VM crashes for any reason?
I have software from many years ago and the latest MS SQL it can work is the one I have on my VM on Azure (SQL2008R2SP3). I don't want to get rid of it and also I want my database on Azure VM. Upgrading is impossible because of complex code source. So,…
asked 2023-07-20T17:35:24.6033333+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(22.400000000000002, 22%, 12%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EDG%3C/text%3E%3C/svg%3E)
Darko Golubovic
20
Reputation points
accepted 2023-07-22T18:08:05.48+00:00
Darko Golubovic
20
Reputation points
1 answer
One of the answers was accepted by the question author.
How to Configure SQL IaaS backup when We use Ultra Disks
We have Azure SQL (IaaS) and the backup option is grayed out because we are using Ultra disks. In that case how we can configure SQL backup?
asked 2023-06-21T04:39:12.3633333+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(67.2, 65%, 16%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EPS%3C/text%3E%3C/svg%3E)
PV, Sunesh
20
Reputation points
edited the question 2023-06-27T04:00:10+00:00
Alberto Morillo
33,161
Reputation points MVP
2 answers
One of the answers was accepted by the question author.
Azure SQL Server on Managed Instance not the best fit for Data Warehouse + ETL workloads! Do you agree?
Hi, I currently have a Data Warehouse on an Azure Managed Instance and SSIS Packages hosted on the SSISDB Catalog of the same instance being executed via Azure-SSIS Integration Runtime. By looking at the features offered by a Microsoft Managed Instance,…
asked 2023-06-07T15:01:15.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(182.40000000000003, 88%, 27%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMB%3C/text%3E%3C/svg%3E)
Marcelo Barbieri
30
Reputation points
edited a comment 2023-06-20T13:55:44.75+00:00
Marcelo Barbieri
30
Reputation points
0 answers
Azure SQL VM Automatic Patching not working
Hello Team, My SQL Azure VM has Automatic Patching Enabled to Install Windows updates on every Saturday after 11 PM. Also, VM has Active hours between 6 AM to 12 AM. But still found Unepxted Restart by "svschost.exe" process complete…
![](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, 89%, 28%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ER%3C/text%3E%3C/svg%3E)
1 answer
One of the answers was accepted by the question author.
Securing access to the Azure SQL Server Database via SSMS using Privatelink ?
My company already using the Azure Express route circuit to allow secure and quicker data access across the WAN. I am trying to secure access to my SQL database in Azure from my user laptop across the globe. Turn off the Public Endpoint for all SQL…
asked 2023-06-14T05:32:57.09+00:00
EnterpriseArchitect
4,896
Reputation points
accepted 2023-06-14T12:45:58.6366667+00:00
EnterpriseArchitect
4,896
Reputation points
2 answers
Azure SQL server 2022 images on WS2019
We planning to upgrade our SQL servers on azure VMs from SQL 2016 -WS2012R2 to SQL2022- WS2019. We are not seeing SQL 2022 images with WS2019 available in the marketplace and instead have SQL2022 with WS022. Firstly, is this correct ? if so what's the…
asked 2023-03-10T19:23:49.7766667+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(268.8, 77%, 36%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EVY%3C/text%3E%3C/svg%3E)
Venkata Yeleswarapu
0
Reputation points
answered 2023-06-11T09:22:14.08+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(156.8, 50%, 25%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EKS%3C/text%3E%3C/svg%3E)
Kumar Saurav
0
Reputation points
1 answer
What to do if Cryptographic provider version in dll is different from the guid recorded in system catalog?
I am attempting to establish EKM with AKV, thus far I have followed the instructions provided here but I am now faced with an error at part 5 which states Cryptographic provider version '01.00.0004.00' in dll is different from the guid recorded in…
asked 2022-06-22T19:00:37.643+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(124.80000000000001, 71%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ES%3C/text%3E%3C/svg%3E)
still_sheik
6
Reputation points
commented 2023-06-02T18:45:30.33+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(64, 88%, 16%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EPL%3C/text%3E%3C/svg%3E)
Phong Le
0
Reputation points
2 answers
One of the answers was accepted by the question author.
is it possible to configure WSUS server in azure with SQL paas database
is it possible to configure WSUS server in azure with SQL PAAS database , instead of IAAS sql db https://learn.microsoft.com/en-us/azure/architecture/example-scenario/wsus/
asked 2020-11-11T11:49:14.683+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(51.2, 74%, 14%)' 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)
Abhishek Singh
381
Reputation points
commented 2023-05-31T21:36:48.66+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, 7.000000000000001%, 34%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ECG%3C/text%3E%3C/svg%3E)
Cory Granata (SC-ALT)
0
Reputation points Microsoft Employee
2 answers
One of the answers was accepted by the question author.
How does automated patching work?
How does automated patching work for a 3-node Always On AG cluster with SQL on Azure VMs? Does it use a rolling update process that leaves the original primary node still as primary after the patching is completed?
asked 2023-02-20T06:53:12.7233333+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, 56.00000000000001%, 21%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ECD%3C/text%3E%3C/svg%3E)
Cooper, David A. [ISS] (Contractor)
71
Reputation points
commented 2023-05-22T11:18:47.8466667+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(86.4, 90%, 18%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EGO%3C/text%3E%3C/svg%3E)
George Ollis
86
Reputation points
1 answer
How to archive an on-premise sql server database of about eight terabytes to azure
We have an on-premise sql server database of about eight terabytes that we are trying to archive to Azure. How can I go about it? This archive needs to be accessible because we might need to pull data from it in the future.
asked 2023-05-16T17:17:58.36+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(12.8, 74%, 11%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EDO%3C/text%3E%3C/svg%3E)
David Onajobi
0
Reputation points
edited a comment 2023-05-19T22:46:44.7466667+00:00
Oury Ba-MSFT
16,901
Reputation points Microsoft Employee
1 answer
Azure VM locall SSD use for TempDB
[Edited] Kinda late to the game of SQL on Azure VM with Always On AG. Per this article, it's recommended practice to put TempDB on the ephemeral temp drive D: which is low-latency…
asked 2023-02-07T21:04:28.3166667+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
answered 2023-05-17T19:22:04.29+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(12.8, 93%, 11%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ETH%3C/text%3E%3C/svg%3E)
Tamarick Hill
11
Reputation points Microsoft Employee
1 answer
One of the answers was accepted by the question author.
Migration to Azure SQL VM Named Instances using Azure Data Studio Migration Extension
Hi, We are trying to migrate databases using Azure Data Studio Migration Extension. We have an Azure SQL VM with one Default SQL Instance (running on port 1433) and 4 SQL Named Instances (running on dynamic ports). But, ADS Migration Extension…
asked 2022-11-21T15:04:23.913+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(76.8, 27%, 17%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESS%3C/text%3E%3C/svg%3E)
Sandeep Sobti
21
Reputation points
accepted 2023-05-17T05:32:44.59+00:00
Sandeep Sobti
21
Reputation points
1 answer
Error 10060: Configure Azure NSG for Azure DB and Azure DW Connectivity
I have created an Azure SQL server and database and am trying to connect through SQL Server Management Studio. I am not able to connect and get the following error message: TITLE: Connect to Server ADDITIONAL INFORMATION: A network-related or…
asked 2023-03-28T17:33:22.37+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(182.40000000000003, 45%, 27%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJV%3C/text%3E%3C/svg%3E)
Jonpier Veliz
0
Reputation points
commented 2023-05-15T18:33:38.6433333+00:00
Oury Ba-MSFT
16,901
Reputation points Microsoft Employee
2 answers
SQL Logs reporting multiple "Login failed for domain\Computer...." Error: 18456 every minute. How do I resolve this?
New SQL Server build. Comprises of 2x Azure VMs "LiveDB1" and a "LiveDB2". Configured with WSFC and Always On HA. There is an Availability Group listener that is load-balanced using Azure Load Balancer. The system is being tested…
asked 2023-05-10T11:14:08.7033333+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(76.8, 71%, 17%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ELC%3C/text%3E%3C/svg%3E)
Lee Calcutt-Scott
1
Reputation point
commented 2023-05-10T15:04:28.23+00:00
Lee Calcutt-Scott
1
Reputation point
1 answer
SQL on Azure VM AlwaysOn with DNN listener
Hi: I have created a 2 nodes SQLServer AlwaysOn on Azure VM, with DNN listener. SQLServer version is 2019 CU15, Window version is 2019. e.g. node1 (10.0.2.15) node2 (10.0.2.16) WindowCluster (DNN) DNNListener (DNN, port 6789) WindowCluster…
asked 2022-03-17T08:03:46.42+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(204.8, 57.00000000000001%, 29%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EVL%3C/text%3E%3C/svg%3E)
Vince Lam
1
Reputation point
edited the question 2023-04-27T04:54:55.59+00:00
Prrudram-MSFT
22,836
Reputation points
1 answer
can I use an Azure Integration runtime to UPSERT data from ADF to SQL Server on azure VM?
Hi, I'm trying to UPSERT data from ADF to a SQL server hosted on Azure Virtual Machine since SHIR is not supported in Mapping dataflows. I've created an Azure Integration Runtime with Virtual Network Enable, however when I tried to create an endpoint I…
asked 2023-03-13T22:34:13.6233333+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(166.4, 45%, 26%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJG%3C/text%3E%3C/svg%3E)
Javier Guerrero
61
Reputation points
commented 2023-04-21T14:56:31.0733333+00:00
Javier Guerrero
61
Reputation points