373 questions with SQL Server on Azure Virtual Machines tags
How to get the SQL Server version details (CU) install in sql server VM from cloud shell?
Hi, What are the options available to get SQL server versions(CU) install in SQL Server VM. THis is needed to maintain the wiki package for multiple vm across the multiple environment, I have tried $serverName =…
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?
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…
Query regarding SQL production license to setup SQL server on Windows VM
Query regarding SQL production license to setup SQL server on Windows VM
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…
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…
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…
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…
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…
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…
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…
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.…
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…
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…
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…
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…
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…
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.
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
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. …