395 questions with SQL Server on Azure Virtual Machines tags

Sort by: Updated
1 answer

How to disable Storage Pools/Disks to be available to other nodes in SQL Cluster?

I am creating a SQL Cluster in Azure. This SQL cluster is mostly based on the Microsoft documentation article called "Tutorial: Configure an availability group in multiple subnets (SQL Server on Azure VMs)". This way you can create an SQL…

SQL Server on Azure Virtual Machines
asked 2025-01-20T13:46:16.21+00:00
Eldin Egrlic 0 Reputation points
answered 2025-01-31T18:18:25.31+00:00
Vijayalaxmi Kattimani 1,080 Reputation points Microsoft Vendor
0 answers

how to user correctly function OPENROWSET to access excel spreadsheet as SQL table?

see bellow the commands that I used and the mistakes that I received and the same error happend in SQL server management Studio and Azure Data Studio. USE [master] --CONFIGURANDO À INSTÂNCIA SQL PARA ACEITAR OPÇÕES AVANÇADAS EXEC sp_configure 'show…

SQL Server on Azure Virtual Machines
asked 2025-01-21T15:25:31.4566667+00:00
CARLITO SENA 0 Reputation points
commented 2025-01-29T20:19:02.48+00:00
Oury Ba-MSFT 20,106 Reputation points Microsoft Employee
2 answers One of the answers was accepted by the question author.

Issue with the sandbox being unavailable on Microsoft Azure Fundamentals

Hey everyone, I’ve been trying to use the MS Learn Sandbox for a module, but I keep running into this annoying error message: “The sandbox for this module is currently unavailable. We're working to resolve this as quickly as possible. In the meantime,…

SQL Server on Azure Virtual Machines
Azure Machine Learning
Azure Machine Learning
An Azure machine learning service for building and deploying models.
3,103 questions
Azure Virtual Machines
Azure Virtual Machines
An Azure service that is used to provision Windows and Linux virtual machines.
8,313 questions
Microsoft Teams
Microsoft Teams
A Microsoft customizable chat-based workspace.
10,814 questions
Azure OpenAI Service
Azure OpenAI Service
An Azure service that provides access to OpenAI’s GPT-3 models with enterprise capabilities.
3,618 questions
asked 2025-01-02T21:25:40.71+00:00
luis baldassari 45 Reputation points
commented 2025-01-21T18:02:30.31+00:00
Oury Ba-MSFT 20,106 Reputation points Microsoft Employee
1 answer

Backup SQL VM, Cancel/Delete SQL VM resources and reservation

I am in the process of archiving an SQL VM and I would like to take backup of that resource and download it outside of the environment. After the backup is completed I would like to delete the VM and all of its associated resources and reservations.…

SQL Server on Azure Virtual Machines
Azure Backup
Azure Backup
An Azure backup service that provides built-in management at scale.
1,354 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,422 questions
asked 2024-12-31T20:32:23.9066667+00:00
Neuro Alert 0 Reputation points
commented 2025-01-06T08:54:22.7833333+00:00
Vijayalaxmi Kattimani 1,080 Reputation points Microsoft Vendor
1 answer One of the answers was accepted by the question author.

The certificate with identifier used to sign the client assertion is expired on application

Hi Team, I am trying to create some external tables from the azure synapse on the parquet files that I have load into the Azure Data Lake storage Gen2. I also created the app in azure directly and extended the expiry date and also provided the Synapse…

SQL Server on Azure Virtual Machines
Azure SQL Database
Azure Data Lake Storage
Azure Data Lake Storage
An Azure service that provides an enterprise-wide hyper-scale repository for big data analytic workloads and is integrated with Azure Blob Storage.
1,537 questions
Azure Synapse Analytics
Azure Synapse Analytics
An Azure analytics service that brings together data integration, enterprise data warehousing, and big data analytics. Previously known as Azure SQL Data Warehouse.
5,170 questions
asked 2022-10-18T17:49:34.617+00:00
Prashant Meshram 46 Reputation points
commented 2025-01-06T00:54:14.8833333+00:00
Rustin Davitt 20 Reputation points
2 answers One of the answers was accepted by the question author.

What is the replacement for SQL Insights for SQL Server in Azure VM?

Hi, I am just wondering about the below Note on the SQL Insights Preview feature. What is the replacement monitoring tool for SQL Server in Azure VM as SQL Insights has retired and database watcher does not support SQL in Azure…

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,422 questions
asked 2025-01-02T15:31:13.3333333+00:00
Ammara Sheikh 40 Reputation points
commented 2025-01-02T23:38:46.0966667+00:00
Oury Ba-MSFT 20,106 Reputation points Microsoft Employee
1 answer One of the answers was accepted by the question author.

How to Rename an Azure SQL VM and Managed Disks without Affecting SQL Server?

We have a SQL Server Azure Virtual Machine (Win/SQL 2022) that was deployed using a marketplace image and is currently running. This VM was set up as part of a SQL Server Migration project from on-premises to the cloud, where some databases have already…

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,313 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,422 questions
asked 2025-01-02T09:34:52.93+00:00
Abimbola Adeniran 66 Reputation points
accepted 2025-01-02T10:54:30.63+00:00
Abimbola Adeniran 66 Reputation points
2 answers One of the answers was accepted by the question author.

In azure sql virtual machine deployment can we use specific (additional) disk for SQL installation

In azure sql virtual machine deployment can we use separate (additional) managed disk for SQL installation instead of the C drive or OS drive

SQL Server on Azure Virtual Machines
asked 2024-12-24T10:55:57.69+00:00
Stalin Rayala (External) 20 Reputation points
commented 2024-12-27T22:00:23.5866667+00:00
Erland Sommarskog 116.4K Reputation points MVP
1 answer One of the answers was accepted by the question author.

Unable to Send Emails from SQL Server

There is an issue with sending emails from SQL Server, accompanied by the following error message: The mail could not be sent to the recipients because of the mail server failure. (Sending Mail using Account 2 (2024-12-03T11:05:46). Exception Message:…

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,422 questions
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,641 questions
SQL Server Analysis Services
SQL Server Analysis Services
A Microsoft online analytical data engine used in decision support and business analytics, providing the analytical data for business reports and client applications such as Power BI, Excel, Reporting Services reports, and other data visualization tools.
1,310 questions
asked 2024-12-23T08:38:01.5766667+00:00
Avinash 20 Reputation points
commented 2024-12-23T11:44:18.4133333+00:00
Naveen Kumar M 75 Reputation points
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,313 questions
Active Directory
Active Directory
A set of directory-based technologies included in Windows Server.
6,853 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,023 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 2,310 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,988 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 2,310 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 1,080 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 2,670 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 4,430 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,352 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,323 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,422 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,422 questions
Windows Server
Windows Server
A family of Microsoft server operating systems that support enterprise-level management, data storage, applications, and communications.
13,651 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