SQL Server on Azure Virtual Machines
An Azure service that is used to provision Windows and Linux virtual machines.
355 questions
355 questions with SQL Server on Azure Virtual Machines tags
1 answer
Dataflow sink table as a source
I am trying to add the sink as source in order to implement exist and lookup for SCD Type 2 but the source table (from the sink) is blank no column names or data, does anyone perhaps know why that is? How can I resolve this?
asked 2024-04-17T09:26:25.06+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(259.20000000000005, 55.00000000000001%, 35%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMR%3C/text%3E%3C/svg%3E)
Mogale Rickie
0
Reputation points
commented 2024-04-18T05:07:30.5033333+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' %3EST%3C/text%3E%3C/svg%3E)
Smaran Thoomu
9,045
Reputation points Microsoft Vendor
1 answer
migrating Database backup from One subscription to another frequently
As a user, I currently have one SQL Server deployed in a single Azure subscription. While I don't currently have any automation set up, I believe I can create automation within the same Azure subscription. However, I'm exploring the possibility of…
asked 2024-03-27T10:50:15.94+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(179.20000000000002, 34%, 27%)' 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)
Muhammad Ahmer
0
Reputation points
edited the question 2024-04-04T21:48:32.5366667+00:00
Oury Ba-MSFT
16,076
Reputation points Microsoft Employee
3 answers
How to backup SQL database in Azure VM from SQL agent?
Hello, we are intending to transfer all SQL database baackups to Azure and have several backups that we need to run manually/on-demand using SQL agent jobs. I have created a backup policy specifically for on-demand backups, and while some online sources…
asked 2024-03-25T15:02:53.0866667+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(224.00000000000003, 57.00000000000001%, 31%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESK%3C/text%3E%3C/svg%3E)
Sridhar.Kamala
5
Reputation points
answered 2024-03-26T06:06:31.27+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, 4%, 31%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESM%3C/text%3E%3C/svg%3E)
ShaktiSingh-MSFT
13,271
Reputation points Microsoft Employee
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
32,426
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
16,076
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
33,141
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
16,076
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
40
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…
asked 2023-08-03T14:28:28.56+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, 73%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAG%3C/text%3E%3C/svg%3E)
Andrea Galli
66
Reputation points
accepted 2024-03-01T07:52:02.56+00:00
Andrea Galli
66
Reputation points
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
16,076
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
![](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(144, 57.00000000000001%, 23%)' 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)
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
33,141
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
51
Reputation points
commented 2024-01-31T00:22:47.8066667+00:00
Oury Ba-MSFT
16,076
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
21
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
16,076
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