387 questions with SQL Server on Azure Virtual Machines tags

Sort by: Updated
1 answer One of the answers was accepted by the question author.

How to register my Azure VM with the SQL IaaS Agent Extension

I deployed a Azure VM and installed SQL 2019 (as opposed to deploying a SQL Server VM from marketplace with SQL pre-installed). I was reading about the benefits of SQL IaaS Agent Extension. See the following article: "Register SQL Server VM…

SQL Server on Azure Virtual Machines
asked 2021-06-28T20:55:18.807+00:00
David C 191 Reputation points
commented 2024-12-09T04:04:55.3433333+00:00
Andrew Janke 65 Reputation points
0 answers

Listener IP Not Reachable from Primary Server in Hybrid Availability Group Setup

Hello there, I have configured a 3-node SQL Server Availability Group with the following setup: Primary Node: On-premises (10.10.1.10) HA Node: On-premises (10.10.1.11) DR Node: Azure VM (10.0.0.4) The listener is configured with two IP addresses…

SQL Server on Azure Virtual Machines
Azure Virtual Machines
Azure Virtual Machines
An Azure service that is used to provision Windows and Linux virtual machines.
8,167 questions
Active Directory
Active Directory
A set of directory-based technologies included in Windows Server.
6,762 questions
Windows Server Clustering
Windows Server Clustering
Windows Server: A family of Microsoft server operating systems that support enterprise-level management, data storage, applications, and communications.Clustering: The grouping of multiple servers in a way that allows them to appear to be a single unit to client computers on a network. Clustering is a means of increasing network capacity, providing live backup in case one of the servers fails, and improving data security.
1,017 questions
asked 2024-11-28T09:32:15.04+00:00
kedar giri 81 Reputation points
commented 2024-12-03T15:52:32.7433333+00:00
Sai Raghunadh M 1,450 Reputation points Microsoft Vendor
4 answers

SSRS license on a separate sql server vm

I have a VM on Azure IaaS Sql server 2019 Standard. I would like to install SSRS on a separate VM. Would I need a new license for this?

SQL Server on Azure Virtual Machines
Azure SQL Database
SQL Server Reporting Services
SQL Server Reporting Services
A SQL Server technology that supports the creation, management, and delivery of both traditional, paper-oriented reports and interactive, web-based reports.
2,957 questions
asked 2024-11-26T16:13:05.8833333+00:00
PHILIPE RIBEIRO MENDONCA 0 Reputation points
commented 2024-11-29T10:39:19.67+00:00
Sai Raghunadh M 1,450 Reputation points Microsoft Vendor
1 answer

Connect to SQL Server on Azure VM with Microsoft Entra managed identity authentication failed

I enabled Microsoft Entra authentication for SQL Server on Azure VM, and I can connect with this sql server using user assigned manage identity with SSMS successfully, but when I try to connect to this sql server in C#, I get below error…

SQL Server on Azure Virtual Machines
asked 2024-11-13T09:46:32.2+00:00
Huichao Gong (Shanghai Wicresoft Co Ltd) 0 Reputation points Microsoft Vendor
commented 2024-11-21T08:51:03.9966667+00:00
Vijayalaxmi Kattimani 660 Reputation points Microsoft Vendor
1 answer One of the answers was accepted by the question author.

Error installing SqlIaasExtension during VM deployment

N-th attempt to create and deploy an Azure SQL VM fails with the status "conflict" in operations details and the following details: { "status": "Failed", "error": { "code":…

SQL Server on Azure Virtual Machines
asked 2024-11-13T14:19:01.2866667+00:00
TATYANA GRIBNIKOVA 20 Reputation points
accepted 2024-11-18T18:28:36.9233333+00:00
TATYANA GRIBNIKOVA 20 Reputation points
1 answer

SQL Server 2019 SKU Upgrade for Entra

I am looking to upgrade our 2019 instance to 2022 with in place upgrade.   The database and server was created using a template in Azure for "SQL Server Standard 2019 on Windows Server 2022". We would like to enable Entra Authentication.  …

SQL Server on Azure Virtual Machines
Microsoft Entra
asked 2024-11-13T16:56:05.1366667+00:00
Robin Halabicki 1 Reputation point
commented 2024-11-18T13:36:17.7933333+00:00
Mahesh Kurva 1,470 Reputation points Microsoft Vendor
2 answers

SQl server is not connecting.

Hi Team, We are facing an issue with SQL Server connectivity. We hosted windows SQL 2022 Server in Azure. and every 30 days the connection to the Database is crashing and getting this below error message. Can anybody help on this issue? A…

SQL Server on Azure Virtual Machines
asked 2024-11-05T06:25:09.55+00:00
Vishakhan K 5 Reputation points
edited the question 2024-11-11T05:32:37.14+00:00
NIKHILA NETHIKUNTA 3,920 Reputation points Microsoft Vendor
1 answer One of the answers was accepted by the question author.

UK region Multi AZ query

Hi, I am looking to design a multi AZ highly available application on Azure. Please let me know if multi AZ is supported in UK West region? We are looking to host our SQL DB on an Azure VM with application content store as Azure Files.

SQL Server on Azure Virtual Machines
Azure Files
Azure Files
An Azure service that offers file shares in the cloud.
1,329 questions
asked 2024-11-09T12:41:30.62+00:00
Ankit Rana 20 Reputation points
accepted 2024-11-09T13:49:10.9266667+00:00
Ankit Rana 20 Reputation points
1 answer One of the answers was accepted by the question author.

Connection Challenges with Azure Databricks and SQL Server On VM in Serverless compute.

We successfully configured VNet peering between the SQL VM's VNet and the Databricks VNet, allowing access to the SQL Server on VMs. Testing the connection from Databricks using a job cluster yielded successful results, confirming that everything…

SQL Server on Azure Virtual Machines
Azure Databricks
Azure Databricks
An Apache Spark-based analytics platform optimized for Azure.
2,283 questions
asked 2024-10-28T05:19:04+00:00
Vetrivel Dhakshinamoorthy 20 Reputation points
accepted 2024-10-30T04:39:44.5666667+00:00
Vetrivel Dhakshinamoorthy 20 Reputation points
1 answer One of the answers was accepted by the question author.

SQL server databases discovery for Azure migrate assessments

Hi Team, We are planning to migrate the SQL databases to Azure SQL VM using Azure Migrate(lift and shift). Can you please help me to what all configuration need to collect for assessments. SQL server versions. Monitoring tools Backups tools.…

SQL Server on Azure Virtual Machines
SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
14,207 questions
asked 2024-10-28T08:14:49.88+00:00
Sanjeev Reddy 30 Reputation points
accepted 2024-10-29T05:37:41.6566667+00:00
Sanjeev Reddy 30 Reputation points
2 answers

Custom SQL Server Startup Script

I'm hoping someone here has faced a similar challenge and could offer insights on how to best approach this. We are running several SQL Server virtual machines in our environment, and we're using the SQL Server IaaS Extension in Azure. We're relying on…

SQL Server on Azure Virtual Machines
SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
14,207 questions
Windows Server
Windows Server
A family of Microsoft server operating systems that support enterprise-level management, data storage, applications, and communications.
13,468 questions
asked 2024-10-21T16:08:00.77+00:00
Jeffrey Beck 0 Reputation points
commented 2024-10-24T21:34:53.7666667+00:00
Jeff Beck 5 Reputation points
0 answers

How to restore certificates used for the Azure SQL VM Automated Backup

I'm testing out encryption for encrypting the SQL backups taken for Azure SQL VM databases, however, I'm unable to restore the certificates generated when setting up encryption as I cannot find the .pvk files. Are these stored in another location or…

SQL Server on Azure Virtual Machines
asked 2024-07-25T12:02:13.1633333+00:00
Keiran Royston 0 Reputation points
commented 2024-10-23T21:32:02.26+00:00
Oury Ba-MSFT 19,826 Reputation points Microsoft Employee
2 answers

Cross subscription Azure SQL VM database restore using Azure CLI

Hi , Anyone tried restoring sql database running on Azure SQL VM and backed up via Azure Backup . Via recovery vault , we are able to perform the cross subscription restore but not using the Azure CLI . All desired permissions in place as documented by…

SQL Server on Azure Virtual Machines
Azure Backup
Azure Backup
An Azure backup service that provides built-in management at scale.
1,316 questions
Azure SQL Database
asked 2024-10-14T08:16:53.7466667+00:00
Nikhil Verma 40 Reputation points
commented 2024-10-22T10:56:27.8733333+00:00
Larry Ja 0 Reputation points
1 answer

How to filter out Azure VM's compute, license, and underlying software cost from cost details data

What are all the line items that give info about the compute cost of VM and its license cost, and any preinstalled software cost for an Azure resource/VM? Example: We are running SQL Server on windows , and I want to separate out the cost for VM compute,…

SQL Server on Azure Virtual Machines
Azure Cost Management
Azure Cost Management
A Microsoft offering that enables tracking of cloud usage and expenditures for Azure and other cloud providers.
2,826 questions
Windows Server Licensing
Windows Server Licensing
Windows Server: A family of Microsoft server operating systems that support enterprise-level management, data storage, applications, and communications.Licensing: Rules, regulations, and restrictions that define how software can be used and distributed.
74 questions
asked 2024-05-11T14:17:16.05+00:00
JagaariHemanth-6179 5 Reputation points
edited the question 2024-10-15T14:03:03.84+00:00
JagaariHemanth-6179 5 Reputation points
2 answers

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…

SQL Server on Azure Virtual Machines
SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
14,207 questions
asked 2023-10-26T06:57:14.84+00:00
bauke 5 Reputation points
commented 2024-10-02T05:09:37.73+00:00
Ben Miller-(DBADuck) 190 Reputation points MVP
1 answer One of the answers was accepted by the question author.

OperationalError: ('HYT00', '[HYT00] [Microsoft][ODBC Driver 17 for SQL Server]Login timeout expired (0) (SQLDriverConnect)')

Hi, I am encountering an issue while trying to connect to an SQL database using a Python script in my Jupyter notebook. The connection attempt results in the following error message: OperationalError: ('HYT00', '[HYT00] [Microsoft][ODBC Driver 17 for SQL…

SQL Server on Azure Virtual Machines
Azure SQL Database
SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
14,207 questions
asked 2024-07-05T06:27:34.9366667+00:00
Nguyễn Thanh Tú 170 Reputation points
accepted 2024-10-02T03:45:01.9666667+00:00
Nguyễn Thanh Tú 170 Reputation points
1 answer

SQL Server on Azure VM Backup minimizing data duplication

A while back, a Microsoft support engineer recommended using SQL on VM backups. The suggestion was to create an SQL DB in an Azure VM job and an Azure VM job, excluding the disks that host the SQL files, to avoid data duplication. If the VM is deleted…

SQL Server on Azure Virtual Machines
Azure Backup
Azure Backup
An Azure backup service that provides built-in management at scale.
1,316 questions
SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
14,207 questions
asked 2024-09-29T01:18:07.9433333+00:00
Josue Del Valle 20 Reputation points
commented 2024-10-01T15:11:50.9566667+00:00
Sai Raghunadh M 1,450 Reputation points Microsoft Vendor
2 answers

sql server virtual machine

been trying to deploy a sql server vm but it keeps failing ,returning a failed iaas server extention ..any idea what could be the problem..please see attached imagefailed.png

SQL Server on Azure Virtual Machines
asked 2024-08-22T06:47:38.3133333+00:00
lusanda fadana 0 Reputation points
answered 2024-09-14T07:13:07.93+00:00
Atif Sheikh 0 Reputation points
2 answers

Authenticating with FILESTREAM SQL Server from Azure App Service

I am currently dealing with an application which is being migrated from on-prem to Azure - this is a .Net Web Application which is planned to be hosted on an Azure Web App resource. Additionally, the application depends on a SQL Server database, which in…

SQL Server on Azure Virtual Machines
Azure Virtual Machines
Azure Virtual Machines
An Azure service that is used to provision Windows and Linux virtual machines.
8,167 questions
SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
14,207 questions
Azure App Service
Azure App Service
Azure App Service is a service used to create and deploy scalable, mission-critical web apps.
8,084 questions
Microsoft Entra ID
Microsoft Entra ID
A Microsoft Entra identity service that provides identity management and access control capabilities. Replaces Azure Active Directory.
22,620 questions
asked 2024-08-26T13:42:14.9333333+00:00
Drew C 0 Reputation points
commented 2024-09-03T00:49:28.9533333+00:00
Mahesh Kurva 1,470 Reputation points Microsoft Vendor
3 answers

SQL Managed Instance and Virtual Cluster Stuck Deleting

I have a sql managed instance and virtual cluster stuck on delete for over 24 hours. I'm not sure the details leading up to this, but the SQL MI was created, but now it shows deleting and is stuck there. The managed instance is showing it is in deletion…

SQL Server on Azure Virtual Machines
Azure SQL Database
Azure
Azure
A cloud computing platform and infrastructure for building, deploying and managing applications and services through a worldwide network of Microsoft-managed datacenters.
1,029 questions
SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
14,207 questions
asked 2024-06-12T15:18:12.3833333+00:00
Jeff Brown 11 Reputation points
commented 2024-08-09T19:29:05.69+00:00
Oury Ba-MSFT 19,826 Reputation points Microsoft Employee