412 questions with SQL Server on Azure Virtual Machines tags

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

Error trying to connect an azure sql database with an sql instance installed on an azure virtual machine

I am trying to connect from my azure SQL database to link to the SQL database installed on an azure virtual machine If I try to connect to another azure database, the connection is successful However, when I try to run the same steps to connect to…

SQL Server on Azure Virtual Machines
Azure SQL Database
asked 2021-08-13T21:35:42.387+00:00
Carlos Eduardo Vasquez 46 Reputation points
commented 2021-08-31T18:55:01.507+00:00
Alberto Morillo 34,681 Reputation points
1 answer

Monitor on-premises SQL Server 2012 using Azure Monitor/Log analytics

Can we monitor on-premises SQL Server 2012 on Windows 2012 VM , by using Azure Monitor or Azure Log analytics. Basically i want to run check the health of my SQL database, by running an SQL Query. Please help SELECT DB_NAME() AS DbName, name AS…

SQL Server on Azure Virtual Machines
Azure Monitor
Azure Monitor
An Azure service that is used to collect, analyze, and act on telemetry data from Azure and on-premises environments.
3,669 questions
asked 2021-08-20T15:36:18.147+00:00
MS Techie 2,751 Reputation points
commented 2021-08-23T07:06:53.803+00:00
MS Techie 2,751 Reputation points
1 answer One of the answers was accepted by the question author.

SQL virtual machine create automatic

Hello to everyone, I have a big problem, well i have a virtual machine that have windows server 2016 and i have install SQL server express 2016 R2, that's okay. But when i go to my Azure portal and go to the resource group of that machine it have…

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.
9,068 questions
asked 2021-08-14T14:32:05.283+00:00
Danny Sánchez 21 Reputation points
commented 2021-08-17T22:31:00.52+00:00
KarishmaTiwari-MSFT 20,782 Reputation points Microsoft Employee Moderator
5 answers

sql on azure vm

dears, i need clarification on the below scenario: i already provisioned an azure VM. and now i want to install sql server media on it. any idea how i can license the sql? can i enter manually the key if i have one? or how it will be done? note:…

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.
9,068 questions
SQL Server | Other
asked 2021-08-15T11:37:14.017+00:00
eg1995 1,156 Reputation points
answered 2021-08-16T08:46:03.65+00:00
CathyJi-MSFT 22,396 Reputation points Microsoft External Staff
1 answer

How to connect and querying SQL Server dB from another VM

Hello, Would to ask your guidance, but to be honest I don't have any experience on SQL Server Administration, so probably need a clear "To do steps" over here. So currently I have two VM that both have its SQL Server DB installed. The…

SQL Server on Azure Virtual Machines
asked 2021-08-15T11:04:58.897+00:00
ShaqAX 1 Reputation point
answered 2021-08-15T11:12:56.79+00:00
Ronen Ariely 15,206 Reputation points
2 answers One of the answers was accepted by the question author.

SQL server enterprise license

Hi, I created new VM in azure portal with win server2019+SQL server ent2019 (VM size D16s_v3), now i want to use SQL hybrid benefit. And i want to purchase SQL server ent license from azure portal we are CSP. If it is 16 vCore VM how many…

SQL Server on Azure Virtual Machines
SQL Server | Other
asked 2021-08-04T02:30:02.573+00:00
SUNOJ KUMAR YELURU 15,496 Reputation points MVP
accepted 2021-08-07T09:26:29.873+00:00
SUNOJ KUMAR YELURU 15,496 Reputation points MVP
1 answer

Get Azure SQL server information using Powershell?

How can I get these information using the Azure Powershell module ? Subscription ResourceGrpName SQLServerName Region SQLFQDN(*.database.windows.net) SQLServerTLSVersion SQLServerPublicNetworkAccess …

SQL Server on Azure Virtual Machines
Azure SQL Database
asked 2021-07-21T11:36:20.94+00:00
EnterpriseArchitect 6,061 Reputation points
commented 2021-07-28T14:41:41.45+00:00
Oury Ba-MSFT 20,936 Reputation points Microsoft Employee Moderator
2 answers

SQL Server Slow Performance with Windows Authentication and Machine Accounts (Non-Domain) (LSASS Issue?)

I'm experiencing severe performance problems with SQL Server 2019 (any edition) when using Windows/integrated authentication but with machine accounts - NOT domain accounts. The simplest reproducible steps are: Have 1 VM ("web")…

SQL Server on Azure Virtual Machines
SQL Server | Other
asked 2021-07-25T13:03:01.443+00:00
Peter N. Moore 6 Reputation points
commented 2021-07-28T01:46:34.36+00:00
Cris Zhan-MSFT 6,661 Reputation points
1 answer One of the answers was accepted by the question author.

Configuring Azure Data Factory to Azure SQL VM private (not managed or Azure SQL)

An azure sql VM (not managed or Azure SQL) has a public IP (204.x.x.x) and a private IP (10.0.0.x) in the managed vnet. Data factory can connect and consume the public IP like any sql server without a fuss. There doesn't seem to be a way to…

SQL Server on Azure Virtual Machines
Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
11,661 questions
asked 2021-07-23T17:35:26.303+00:00
Steven Troccoli 96 Reputation points
accepted 2021-07-27T12:04:59.707+00:00
Steven Troccoli 96 Reputation points
0 answers

Restore Azure SQL Database to Alternate Location with PowerShell

Hello, I have been tasked with creating a powershell script that refreshes data from our production database to our beta database. Currently to refresh the data we'll use a point in time backup from production and restore to our beta database…

SQL Server on Azure Virtual Machines
Azure SQL Database
asked 2021-07-07T11:45:26.087+00:00
Charles Lerant 1 Reputation point
commented 2021-07-26T21:30:51.843+00:00
Oury Ba-MSFT 20,936 Reputation points Microsoft Employee Moderator
1 answer One of the answers was accepted by the question author.

Questions on SQL Server on Azure Vm

Hello, I am new to Azure, please bear with me if you find my questions silly or otherwise. I have installed SQL Server 2019 Dev on an Azure VM. Could you please help me finding answers for following questions ? I see backups blade on SQL…

SQL Server on Azure Virtual Machines
Azure SQL Database
asked 2021-02-25T09:35:02.433+00:00
anil kumar 1,646 Reputation points
commented 2021-07-13T05:23:53.473+00:00
anil kumar 1,646 Reputation points
1 answer One of the answers was accepted by the question author.

Can use Azure Virtual machine hybrid benefits + SQL server web edition pay-as-go ?

Current using scenario: Azure Virtual machine (Windows server 2019) - Hybrid benefits with reserved instance 1 year. SQL Express Edition 2016 Expected scenario: Azure Virtual machine (Windows server 2019) - Hybrid benefits with reserved…

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.
9,068 questions
asked 2021-07-08T03:30:07.923+00:00
Saravanan Arunagiri 26 Reputation points
accepted 2021-07-13T01:24:28.347+00:00
Saravanan Arunagiri 26 Reputation points
3 answers

Labs for AlwaysOn

Wanted to do some tests for alwayson. Can you please guide for Labs for alwayson AG or FCI setups for practice/tests

SQL Server on Azure Virtual Machines
asked 2021-07-10T17:34:56.417+00:00
Vishu 1,736 Reputation points
answered 2021-07-10T18:02:45.43+00:00
Anonymous
2 answers One of the answers was accepted by the question author.

Azure subscription requirements for running 3 legacy Windows 2008 R2 VM's

Hi, I'm considering migrating 3 on-prem Windows 2008 R2 VM's to run a VM's on Azure. One server hosts SQL 2008 R2 and the other 2 VM's run a legacy application. What are the Azure subscription requirements for running these 3 VM's? Thank you

SQL Server on Azure Virtual Machines
Windows for business | Windows Server | User experience | Other
asked 2021-06-24T18:06:14.477+00:00
MenloITAdmin 21 Reputation points
commented 2021-07-01T01:31:20.79+00:00
kobulloc-MSFT 26,811 Reputation points Microsoft Employee Moderator
1 answer One of the answers was accepted by the question author.

Stretch on-premise database

Hi there, I wonder if I can stretch my on-premise database to SQL Server in Azure VM. I have checked stretching my on-premise database on Azure SQL Server, but is it possible if I do the same thing on SQL Server installed in Azure VM. Your quick…

SQL Server on Azure Virtual Machines
Azure SQL Database
Azure Virtual Machines
Azure Virtual Machines
An Azure service that is used to provision Windows and Linux virtual machines.
9,068 questions
asked 2021-06-28T13:09:52.97+00:00
Shabbir Hussain 21 Reputation points
accepted 2021-06-30T07:02:57.963+00:00
Shabbir Hussain 21 Reputation points
1 answer One of the answers was accepted by the question author.

Export VM information

Hi All i have 2 subscriptions and i want to export all the VMS information to csv file. i want to export the below information to a csv file. Subscription Name Location Status Resource Group VMType Core Mem (MB) OS IP Zone …

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.
9,068 questions
Windows for business | Windows Server | User experience | PowerShell
asked 2021-06-06T19:06:48.383+00:00
Rising Flight 5,216 Reputation points
accepted 2021-06-25T14:23:09.757+00:00
Rising Flight 5,216 Reputation points
2 answers

Problem with merge replicaton on SQL Server 2019

I have setup a managed Windows Server and SQL Server 2019 in Azure. I have restored a database, created the distributor, created a publication for the database on the same SQL server, set the user in the database to be the owner and have rights to the…

SQL Server on Azure Virtual Machines
Azure SQL Database
SQL Server | Other
asked 2021-06-22T16:58:48.89+00:00
MR BILL 266 Reputation points
commented 2021-06-25T07:03:07.097+00:00
Seeya Xi-MSFT 16,661 Reputation points
2 answers One of the answers was accepted by the question author.

SQL Cluster migrate to Azure

Experts, Can you please suggest if a SQL Cluster can be moved from onpremise to azure using Azure Migrate

SQL Server on Azure Virtual Machines
Azure Migrate
Azure Migrate
A central hub of Azure cloud migration services and tools to discover, assess, and migrate workloads to the cloud.
930 questions
SQL Server | Other
asked 2021-06-17T13:11:22.33+00:00
Vishu 1,736 Reputation points
accepted 2021-06-22T14:30:22.363+00:00
Vishu 1,736 Reputation points
3 answers One of the answers was accepted by the question author.

Minimum SQL Version

Experts, Understanding is that using lift and shift migration strategy to migrate VM hosting SQL Server from On premise to Azure , the min SQL version is SQl 2008 SP4. Does it mean the migration will fail if the version/Service pack is below it or…

SQL Server on Azure Virtual Machines
SQL Server | Other
asked 2021-06-18T10:21:40.113+00:00
Vishu 1,736 Reputation points
accepted 2021-06-22T14:30:04.723+00:00
Vishu 1,736 Reputation points
1 answer

How do you create an alias for connection to a managed VM Windows Server 2019 with managed SQL Server 2019?

Cannot create an alias for connection to SQL Server 2019 other than port 1433 that will connect and work. I created an alias using a different port number 57XXX but i cannot connect to the server using that port. When I changed the alias to port 1433,…

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.
9,068 questions
SQL Server | Other
asked 2021-06-15T16:52:23.727+00:00
MR BILL 266 Reputation points
commented 2021-06-22T01:18:42.423+00:00
CarrinWu-MSFT 6,891 Reputation points