SQL Server on Azure Virtual Machines
An Azure service that is used to provision Windows and Linux virtual machines.
371 questions
371 questions with SQL Server on Azure Virtual Machines tags
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
17,946
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
26
Reputation points
accepted 2023-05-17T05:32:44.59+00:00
Sandeep Sobti
26
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
17,946
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
23,051
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
1 answer
Getting Timeout Error[258] Unable to complete login process due to delay in prelogin response.
Restored a TFS Database in CUS region in Azure SQL VM. Not able to connect to database from Client machine which is an on-prem machine. Getting the following error when using SQLCMD utility: Sqlcmd: Error: Microsoft ODBC Driver 17 for SQL Server : TCP…
asked 2023-04-02T19:17:10.34+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(0, 90%, 10%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EU%3C/text%3E%3C/svg%3E)
@umesh
0
Reputation points
commented 2023-04-12T23:26:26.1466667+00:00
Oury Ba-MSFT
17,946
Reputation points Microsoft Employee
1 answer
SQL auth password with special characters (quotes) is corrupted during SQL Server on Azure VM deployment
Hello! I've met an issue while trying to deploy an SQL Server on Azure VM: https://azure.microsoft.com/en-us/services/virtual-machines/sql-server/ I cannot login to the SQL Server with the SQL auth credential I've set during deployment - I get the…
asked 2021-04-27T11:11:42.757+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(297.6, 59%, 38%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMH%3C/text%3E%3C/svg%3E)
Mykola Honcharenko
1
Reputation point
edited the question 2023-04-10T06:10:03.62+00:00
vipullag-MSFT
26,016
Reputation points
1 answer
One of the answers was accepted by the question author.
Working with Dotnet and Sql edge on M1 mac nuget packages
Hello, Im new to mac, I have an M1 mac mini, Im using Visual Studio for M1 mac as well Recently I have Installed docker with sql edge container in it. In order to make my Web API projects more efficient, I couldn't figure it out if I need some…
SQL Server on Azure Virtual Machines
SQL Server on Azure Virtual Machines
An Azure service that is used to provision Windows and Linux virtual machines.
371 questions
.NET
.NET
Microsoft Technologies based on the .NET software framework.
3,637 questions
C#
C#
An object-oriented and type-safe programming language that has its roots in the C family of languages and includes support for component-oriented programming.
10,639 questions
ASP.NET API
ASP.NET API
ASP.NET: A set of technologies in the .NET Framework for building web applications and XML web services.API: A software intermediary that allows two applications to interact with each other.
317 questions
asked 2022-04-25T21:04:30.397+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(172.8, 1%, 26%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EM%3C/text%3E%3C/svg%3E)
Moshiko_Az
21
Reputation points
commented 2023-04-09T06:00:52.6433333+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(227.2, 80%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJM%3C/text%3E%3C/svg%3E)
Josué Mercadillo
1
Reputation point
1 answer
Azure SQL Managed Instance - Long term Retention
Hello all, I can setup LTR policies -PITR, weekly, yearly backups for all existing databases that are created on Azure SQL MI. However, the policies DO NOT apply for any new databases created after the policy is created. Is there a way to create…
asked 2022-10-13T21:27:06.923+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, 4%, 34%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMA%3C/text%3E%3C/svg%3E)
Mandar Alawani
1
Reputation point
answered 2023-04-08T12:06:23.4366667+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(147.20000000000002, 27%, 24%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EV%3C/text%3E%3C/svg%3E)
VasimTamboli
4,785
Reputation points
1 answer
One of the answers was accepted by the question author.
Compliance
Hi, Is Azure App service compliant with ISO 27001 and is SQL Server on Azure Virtual Machines compliant with GDPR?
asked 2023-04-04T11:23:13.1633333+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(176, 66%, 27%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ETT%3C/text%3E%3C/svg%3E)
Tamasgen Teshome
80
Reputation points
accepted 2023-04-06T11:04:40.8033333+00:00
Tamasgen Teshome
80
Reputation points
1 answer
Read-only database in azure cloud from on-prem database
Hello, Can you provide me a way to sync full database and have read only version of on-prem database on azure cloud? Seems like High Availability is not working, there are Data Sync / replication options but they are only table level. I want full…
asked 2023-03-13T12:36:05.7666667+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(172.8, 56.00000000000001%, 26%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EVS%3C/text%3E%3C/svg%3E)
Vujatovic, Srdjan
0
Reputation points
commented 2023-04-04T17:08:31.4066667+00:00
Oury Ba-MSFT
17,946
Reputation points Microsoft Employee
2 answers
All physical cores of Host server on premise is licensed with "SQL Server Enterprise"- Can we use SA benefit unlimited virtualization to license VM deployed on licensed Server with "Azure arc enabled SQL server" .
All physical cores of Host on premise server is licensed with "SQL Server Enterprise". Can we use SA benefit "unlimited virtualization" to license VM deployed on licensed Server with "Azure arc enabled SQL server" ? or we…
asked 2023-04-02T20:27:34.6733333+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(249.60000000000002, 20%, 34%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
Ajit
0
Reputation points
edited the question 2023-04-03T14:30:58.72+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(275.2, 41%, 36%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAM%3C/text%3E%3C/svg%3E)
AnuragSingh-MSFT
21,246
Reputation points
1 answer
One of the answers was accepted by the question author.
GuestConfig agent failed to compute compliance status for Windows Server 2022 in Azure
Hello Team, I'm trying to Compliant the "Windows Web Server ha Secure Communication Protocols" Policy for my azure VM. The Compliance Status shows me Non-Compliant because of GuestConfig agent failed to compute the compliance status. Cannot…
![](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)
2 answers
RTO for cross region restore of sql on VM
Based on this article there is an RPO definition for using cross region restore for a sql database on VM I couldn't find what is the RTO for this type of ability? Is it documented somewhere?
![](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(28.799999999999997, 88%, 12%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAL%3C/text%3E%3C/svg%3E)
1 answer
Unclear RPO and RTO for SQL always on availability group
The article about BCDR for SQL Server provides a descriptive information regarding RTO and RPO for using Always On availability group for SQL Server on Azure VM (RTO: The time taken to make the secondary replica as primary, RPO: Because replication to…
1 answer
A network-related or instance-specific error occurred while establishing a connection to SQL Server.
I am using a macbook m1 pro while i am connecting to azure data base it is showing an error but i have done everything correctly but i dont know what is the problem occured please help me with this
asked 2023-02-04T18:34:19.05+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, 8%, 36%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAA%3C/text%3E%3C/svg%3E)
Ahamed Ajas
0
Reputation points
commented 2023-02-27T20:59:36.7033333+00:00
Oury Ba-MSFT
17,946
Reputation points Microsoft Employee