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
Query regarding SQL production license to setup SQL server on Windows VM
Query regarding SQL production license to setup SQL server on Windows VM
asked 2024-03-14T17:05:00.21+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(236.8, 20%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERS%3C/text%3E%3C/svg%3E)
Ramit Sharma
0
Reputation points
answered 2024-03-15T01:26:34.5+00:00
ZoeHui-MSFT
34,996
Reputation points
1 answer
Data Migration from One Environment to Other
I have a graph database on cosmos dB, and I need to migrate the data to a different environment. Need suggestions on how to move this. I did some research and figured out an Azure Data Migration tool but I am not sure what would be the partition key for…
asked 2024-03-07T16:59:36.0966667+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, 57.99999999999999%, 12%)' 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)
Surya
0
Reputation points
commented 2024-03-11T18:13:14.82+00:00
Oury Ba-MSFT
17,791
Reputation points Microsoft Employee
1 answer
How to solve the SQL Server is not connected in Azure when deploy the website?
My website is on fabjoey23.azurewebsites.net. Help to avoid this two errors: Error. An error occurred while processing your request. Request ID: 00-9fe33736939a1a5c2963eb30d4b132ed-3d31b53b23b27dea-00 Development Mode Swapping to Development environment…
asked 2024-03-06T05:49:50.4466667+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, 24%, 36%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ETF%3C/text%3E%3C/svg%3E)
Thibaut Fabrice
0
Reputation points
commented 2024-03-08T17:02:21.0366667+00:00
deherman-MSFT
35,316
Reputation points Microsoft Employee
2 answers
High cost of my Azure subscription for a small SQL server and couple of web services
Setting this first time in my life Have registered for Azure subscription and deployed my web services. Also setup a sql server. Herein the cost is going too high for a extra small company owner like me. Tried to setup SQL Sever VM. But all options I…
asked 2024-03-03T14:43:11.5366667+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(220.8, 68%, 31%)' 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)
Sameer
0
Reputation points
edited a comment 2024-03-05T18:07:37.3366667+00:00
Oury Ba-MSFT
17,791
Reputation points Microsoft Employee
1 answer
Retrieve an SQL standard license for in place upgrade
We are running a SQL virtual machine SQL server under a developer license that needs to be upgraded to a standard SQL license. The payment for the SQL license is done through Azure so no license keys in our control. Now with the upgrade through the…
asked 2023-10-26T06:57:14.84+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(294.40000000000003, 49%, 38%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EB%3C/text%3E%3C/svg%3E)
bauke
0
Reputation points
commented 2024-03-04T06:17:29.01+00:00
Andy Lau Pik Hui
65
Reputation points
2 answers
Unexplained network latency between AKS and SQL-Server on AzureVM
We have an application running on our Azure-AKS-Service , that is connected to an SQL-Server running on a VM, also in Azure. AKS-Version: 1.25.6 SQL-VM: SQL2017-CU31 on WindowsServer 2016 The AKS and the SQL-VM are in different VNET, however these…
asked 2023-07-24T12:30:41.6633333+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, 62%, 28%)' 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)
Justin Vieth
10
Reputation points
answered 2024-03-02T00:25:26.71+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(137.6, 70%, 23%)' 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)
Pionerd
0
Reputation points
1 answer
One of the answers was accepted by the question author.
Azure marketplace: SQL Server 2022 image embedded on VM
Hello everyone, the Windows Server 2022 images with embedded SQL comes with a Premium 1TB disk, I know that it is done intentionally by design, by MS, because they consider that this disk is the one that gives the appropriate performance. But if I would…
![](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(137.6, 73%, 23%)' 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)
6 answers
One of the answers was accepted by the question author.
Error 18456, Severity 14, State 1, Windows Authentication
I created a VM with its own username and password. When I load the VM and open the SQL Management Server, Windows Authentication is automatically selected and my VM credentials are auto filled. But when I hit connect, Error 18456, Severity 14, State 1 is…
asked 2021-12-23T20:45:25.793+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(57.599999999999994, 35%, 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)
Krishna Mandal
21
Reputation points
answered 2024-02-26T12:22:55.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(195.2, 44%, 28%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMS%3C/text%3E%3C/svg%3E)
Marc Snijders
0
Reputation points
1 answer
One of the answers was accepted by the question author.
Will the SQL Server License option on a dedicated host be in the Rest API?
Hello. I'm working on distributing a dedicated host with RestAPI. I'm going to distribute the same settings as the previously distributed dedicated host, but I don't have a SQL Server license option, so I always have to deal with this in Azure Portal.…
![](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(272, 51%, 36%)' 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)
4 answers
Restore SQL Server databases in Azure VMs across subscription
I'm generating a runbook to execute a PowerShell script that takes a backup of a SQL Server on an Azure virtual machine and restores it to another SQL Server on a different virtual machine but in a different subscription. The code is giving me errors of…
asked 2024-02-05T20:14:52.6+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(313.6, 50%, 40%)' 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)
Miguel Angel Mela Lozoya
0
Reputation points
answered 2024-02-14T17:29:24.9766667+00:00
Oury Ba-MSFT
17,791
Reputation points Microsoft Employee
3 answers
if i deploy Always on availability group in multi subnet do we need to mention multisubnetfailover=true as compulsary
we have an AX application that has Databases configured with the Always On availability group. we have deployed the Always On availability group in a single subnet, currently, we are facing issues with the connections through the Load balancer to the…
asked 2024-02-09T12:24:19.0166667+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, 86%, 12%)' 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)
SaikrishnaE
51
Reputation points
commented 2024-02-12T02:57:15.46+00:00
Ben Miller-(DBADuck)
0
Reputation points MVP
1 answer
Azure SQL VM high availability, Join Domain Issue
I am trying to create an Azure SQL virtual machine with high availability. But it gives an error: Join the domain, After creating the VM, and it cancle all the next steps to create the failover cluster I am using AADDS, and its DNS IP address is added to…
asked 2024-01-31T12:49:42.7866667+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(272, 23%, 36%)' 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)
Muhammad Hammad Naeem
0
Reputation points
answered 2024-02-05T16:40:22.25+00:00
deherman-MSFT
35,316
Reputation points Microsoft Employee
0 answers
Microsoft Entra authentication for SQL Server on Azure VMs
Good morning, I have a SQL server on Azure virtual machine. SQL version: SQL Server 2022 Virtual machine OS: Windows (Windows Server 2022 Datacenter) I have the VM linked to my azure domain, and have user accounts that can login to the VM with their…
asked 2023-12-21T09:10:48.8166667+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, 18%, 25%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ECA%3C/text%3E%3C/svg%3E)
Cristopher Aguilera
91
Reputation points
commented 2024-01-31T00:22:47.8066667+00:00
Oury Ba-MSFT
17,791
Reputation points Microsoft Employee
7 answers
SqlThreatDetection_Audit on all Azure SQL Virtual Machines
I recently began seeing failures in my SQL Error logs relating to SQL Audits. We do not utilize SQL Audits in our environment so I began investigating. I found that an audit named SqlThreatDetection_Audit was created and enabled on all of my IAAS…
asked 2020-08-13T14:04:41.373+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, 49%, 36%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EGB%3C/text%3E%3C/svg%3E)
Garry Bargsley
1
Reputation point
answered 2024-01-19T22:38:41.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(73.60000000000001, 55.00000000000001%, 17%)' 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)
Abimbola Adeniran
46
Reputation points
1 answer
On-Premises SQL HA Availability with Azure SQL
@GitaraniSharma-MSFT I am wondering if it is possible to create a SQL Always On Availability Group with on-premises servers and SQL Azure VMs. Please validate two scenarios below.
asked 2024-01-01T07:38:41.52+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(313.6, 23%, 40%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ENA%3C/text%3E%3C/svg%3E)
Nitin Arora
25
Reputation points
edited a comment 2024-01-17T09:56:26.7766667+00:00
Nitin Arora
25
Reputation points
1 answer
PowerBi Service to Azure VM Sql
Good Morning, I am trying to connect to a SQL thats hosted on a Azure VM. Can anyone confirm that Service Tags and Ports I need to add to allow the connection? Thank you
asked 2024-01-10T11:21:13.11+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(96, 24%, 19%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAB%3C/text%3E%3C/svg%3E)
Andrew Bilham
0
Reputation points
commented 2024-01-16T20:09:41.69+00:00
Oury Ba-MSFT
17,791
Reputation points Microsoft Employee
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
25,861
Reputation points
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,261
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
LiHongMSFT-4306
25,646
Reputation points