SQL Server on Azure Virtual Machines
An Azure service that is used to provision Windows and Linux virtual machines.
356 questions
356 questions with SQL Server on Azure Virtual Machines tags
1 answer
One of the answers was accepted by the question author.
What Default 'sa' SQL Admin user Password
Hi All, I have created Azure VM with Win Server 2016 and SQL server 2016 from image available from Azure Custom Images . Now when VM is created a Default SQL instance gets created to which we can Login with SSMS with Windows authentication mode. …
asked 2021-10-25T04:22:44.237+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(188.79999999999998, 7.000000000000001%, 28%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EVB%3C/text%3E%3C/svg%3E)
Vilas Bhoge
31
Reputation points
commented 2024-01-09T16:16:41.16+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(6.4, 62%, 10%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMP%3C/text%3E%3C/svg%3E)
Mark Pasternak
0
Reputation points
1 answer
Can we Create Failover Cluster between Azure VM and On-Prem
Hello everyone, Is there any documentation or anyway of creating a Failover Cluster between Azure VM and On-premises VM. I need to create failover cluster as exactly as Domain Independent failover cluster on Azure VM and On-premises VM. Is there anyway…
asked 2023-10-31T04:17:06.53+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(44.800000000000004, 14.000000000000002%, 14%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EKG%3C/text%3E%3C/svg%3E)
kedar giri
61
Reputation points
commented 2023-11-30T06:53:24.1566667+00:00
vipullag-MSFT
24,206
Reputation points Microsoft Employee
0 answers
the data factory didn't send any traffic to the network
Hello all, I have an SQL Server hosted in Azure VM I'm trying to build a connection (linked service) between her and the data factory. Knowing that both are within the same virtual network and that the data factory is managed through the virtual network…
asked 2023-11-15T11:25:34.3266667+00:00
MUSTAFA AHMAD MUSTAFA AL-HUNAITI
166
Reputation points
commented 2023-11-16T17:59:13.4633333+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(54.400000000000006, 38%, 15%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EQ%3C/text%3E%3C/svg%3E)
QuantumCache
20,031
Reputation points
2 answers
Upgrading SQL Server from 2016 to 2022
Hello, We are looking to upgrade our virtual instance of SQL Server 2016 to SQL Server 2022. The issue is we don't necessarily have the resources or full knowledge on our team available to perform this duty. Does anyone have a recommendation of a…
asked 2023-10-30T16:18:22.0533333+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, 1%, 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)
Dustin Crowell
0
Reputation points
commented 2023-11-06T07:19:35.73+00:00
CosmogHong-MSFT
23,246
Reputation points Microsoft Vendor
2 answers
One of the answers was accepted by the question author.
Unexpected SQL server Azure VM (Windows 2016) reboot due to bugcheck + Thales Encryption
Hi Team, We have an windows 2016 Azure VM with SQL 2016 Always on configured on it. We have implemented Thales Encryption on few data folders for protecting SQL server data. Recently we have observed unexpected VM reboots due to bug check which is…
asked 2022-02-18T08:27:40.947+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(102.4, 30%, 19%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAF%3C/text%3E%3C/svg%3E)
Anshul Farkya
111
Reputation points
edited the question 2023-10-17T08:38:02.8533333+00:00
Prrudram-MSFT
22,211
Reputation points
0 answers
Provisioning failed while creating Azure SQL Virtual machine with High Availability
Quick start template referred by Azure portal is able to build the SQL VM's, Join the system to domain, Install SQL IaaS Agent but when configuring the agent getting error like below. We Have setup the Domain Controllers in Hub & Spoke model reason…
asked 2023-10-13T09:43:19.9433333+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(105.60000000000001, 14.000000000000002%, 20%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EBV%3C/text%3E%3C/svg%3E)
Balakrishnan, Vidhyasagar
1
Reputation point
commented 2023-10-16T22:02:31.77+00:00
Oury Ba-MSFT
16,241
Reputation points Microsoft Employee
1 answer
One of the answers was accepted by the question author.
Full mode of IaaS Agent extension in Linux (Ubuntu)
Is it possible to install IaaS Agent extension in full mode for Ubuntu with SQL Server? If not, is there any prediction of this happening?
asked 2023-10-10T17:32:11.9133333+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, 27%, 29%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ETP%3C/text%3E%3C/svg%3E)
Thiago Pereira da Silva
40
Reputation points
accepted 2023-10-13T12:27:13.28+00:00
Thiago Pereira da Silva
40
Reputation points
2 answers
One of the answers was accepted by the question author.
Azure AD authentication support for Azure SQL on VM
Is there any support for Azure AD - Service Principals / Users / Groups to authenticate to "Azure SQL on VM" hosted database? Currently looking to port from Azure SQL Managed Instance and are hoping we can re-use our application identity…
asked 2021-09-10T22:31:31.1+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, 34%, 38%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ECB%3C/text%3E%3C/svg%3E)
Chad Bentz
26
Reputation points Microsoft Employee
accepted 2023-10-12T15:23:01.7333333+00:00
Chad Bentz
26
Reputation points Microsoft Employee
2 answers
Questions Using the Azure Temp Drive for TempDB
I have seen several articles around the Internet describing the use of the Azure temporary drive for TempDB storage. It brought up a couple of questions for me. 1. What is the temp drive physical hardware, Standard SSD, Premium SSD, Ultra SSD? How can I…
asked 2021-02-22T15:55:43.247+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, 94%, 24%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ECS%3C/text%3E%3C/svg%3E)
Chris Stamey
1
Reputation point
edited an answer 2023-09-29T15:45:49.3866667+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(70.4, 25%, 16%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJH%3C/text%3E%3C/svg%3E)
John Heimiller
0
Reputation points
2 answers
End of Life Support for Azure Managed SQL instnces
I have an Azure-managed SQL server running: SQL Server 2014 SP3 Standard on Windows Server 2012 R2. Windows 2012 is approaching EOL (end of life) in October 2023, what kind of support will Azure provide after the EOL since it is an Azure-managed server?…
asked 2023-09-27T08:56:32.8433333+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(25.6, 38%, 12%)' 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)
Priyanka Srivastava
20
Reputation points
answered 2023-09-27T19:26:31.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(102.4, 60%, 19%)' 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)
Alvaro Mathis
0
Reputation points
1 answer
Microsoft.SqlServer.Management.SqlIaaSAgent Install fails with "maximum message size quota for incoming messages (65536) has been exceeded"
When attempting to install extension Microsoft.SqlServer.Management.SqlIaaSAgent v2.0.143.0 on our virtual machine we are seeing the following error The maximum message size quota for incoming messages (65536) has been exceeded. To increase the quota,…
asked 2023-08-21T23:24:06.0266667+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(83.2, 49%, 18%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EBM%3C/text%3E%3C/svg%3E)
Blair McClelland
0
Reputation points
commented 2023-09-27T07:48:35.76+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(54.400000000000006, 3%, 15%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EKM%3C/text%3E%3C/svg%3E)
kangupt-MSFT
20
Reputation points Microsoft Employee
2 answers
Random authentication issues between application and SQL using AAD DS
Hello, We are experiencing random authentication issues between applications and SQL that are members of AAD DS managed domain. Environment: Application Server - Azure VM with Windows Server 2019 with IIS and .Net application. Connecting to SQL…
asked 2021-05-27T09:59:07.51+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, 20%, 36%)' 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)
Sergei Stepanov
27
Reputation points
commented 2023-09-21T16:49:06.96+00:00
Sergei Stepanov
27
Reputation points
2 answers
One of the answers was accepted by the question author.
Can SQL Express 2019 running alongside our existing full version SQL 2014?
Hi, Can we use SQL Express 2019 running alongside your existing full version SQL 2014 on the same server? We need SQL2014 for Dynamics NAV and would like using SQL Express for DDM(low cost multi-CAD PDM/PLM solution)so I can work from home and not have…
asked 2023-09-12T14:45:28.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(131.20000000000002, 52%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ETS%3C/text%3E%3C/svg%3E)
Tudor Serban Nedelcu
20
Reputation points
commented 2023-09-13T20:48:17.16+00:00
Erland Sommarskog
101.1K
Reputation points MVP
0 answers
Azure Function connection issue with trusted SQL server connection
We have hosted our SQL server instance on Azure Virtual Machine with trusted connections (Windows Authenticator). Having issue to connect SQL server in azure function. the error message showing - Login failed. The login is from an untrusted domain and…
asked 2023-08-25T14:05:48.5866667+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, 81%, 16%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERJ%3C/text%3E%3C/svg%3E)
Raunak Jaiswal
0
Reputation points
commented 2023-09-11T10:41:19.9533333+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(230.39999999999998, 93%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EBG%3C/text%3E%3C/svg%3E)
Ben Gimblett
3,410
Reputation points Microsoft Employee
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,241
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
24,206
Reputation points Microsoft Employee
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
32,891
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
32,891
Reputation points MVP