SQL Server on Azure Virtual Machines
An Azure service that is used to provision Windows and Linux virtual machines.
358 questions
358 questions with SQL Server on Azure Virtual Machines tags
2 answers
Comparable version of AzureSQL PaaS with SQLServer on VM/On-Prem
All, We are in the process of migrating SQLServer 2012 databases onto AzureSQL PaaS. I was thinking of setting up a comparable/compatible edition of SQLServer On-Prem onto which we can migrate the data and then eventually copy (bacpac) the data to…
asked 2020-11-23T19:41:53.28+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, 51%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EG%3C/text%3E%3C/svg%3E)
grajee
346
Reputation points
commented 2020-11-25T08:45:19.487+00:00
CathyJi-MSFT
21,096
Reputation points Microsoft Vendor
1 answer
SQL Hybrid benefit not able to change for SQL on Azure VM with 1 year or 3 year reservation
My question is regarding the azure pricing site (https://azure.microsoft.com/en-us/pricing/calculator/) , for the option of SQL Pricing on Azure VM. i am not able to change the SQL Hybrid benefit option ( to sql hybrid) for SQL on Azure VM with 1…
![](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, 71%, 19%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMT%3C/text%3E%3C/svg%3E)
3 answers
One of the answers was accepted by the question author.
SQL Always On Active Active Cross premises
Hi fellows, Can an on-premises SQL AlwaysOn Cluster (2 Node) be extended to Azure (2 additional nodes as Azure VMs) in an active-active model? On-premises SQL cluster has three availability groups. Objective is to convert applications to…
asked 2020-11-16T12:24:46.397+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(262.40000000000003, 9%, 35%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJA%3C/text%3E%3C/svg%3E)
Junaid Ahmed
21
Reputation points
commented 2020-11-18T06:25:53.237+00:00
Junaid Ahmed
21
Reputation points
1 answer
How can I install sql server 2019 standard to azure vm from image manually?
I would like to install three SQL server 2019 standard instance to Azure VM. I would like to do the whole installation process by myself. Are there any solution to do this?
asked 2020-11-11T10:06:20.74+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(230.39999999999998, 90%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESZ%3C/text%3E%3C/svg%3E)
Szabó Zsolt
1
Reputation point
answered 2020-11-14T01:49:40.397+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(118.4, 98%, 21%)' 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)
KarishmaTiwari-MSFT
18,612
Reputation points Microsoft Employee
5 answers
SQL Always On for report services
Hi, in my searches I found that the report server should not be used in scenarios with SQL Always On, as some information is specific to the report services and even if replicated to another server it will not work. To work it is necessary to make a…
![](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(105.60000000000001, 10%, 20%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EG%3C/text%3E%3C/svg%3E)
1 answer
Does SQL Server 2000 Support High-Availability
I have a SQL Server 2000 Standard Edition, will it support High-Availability? And I want to move one of my server to 2014 server. Is SQL Server 2000 is compatible with 2014+ editions? Also, I have SA for SQL VM. Azure has Hybrid benefit on Azure SQL…
asked 2020-11-06T12:11:41.297+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(160, 57.00000000000001%, 25%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESP%3C/text%3E%3C/svg%3E)
Sarvesh Pandey
141
Reputation points
commented 2020-11-10T14:09:58.087+00:00
prmanhas-MSFT
17,891
Reputation points Microsoft Employee
1 answer
SQL VM - R Services - Python Not working
i have a azure SQL VM and have r services configured at single build time my basic r script is working however python doesn't work i get this error Msg 39021, Level 16, State 1, Line 27 Unable to launch runtime for 'Python' script. Please check…
asked 2020-10-27T20:53:41.707+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, 76%, 12%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJT%3C/text%3E%3C/svg%3E)
Jamie Templeman
1
Reputation point
commented 2020-11-02T13:01:47.82+00:00
prmanhas-MSFT
17,891
Reputation points Microsoft Employee
0 answers
Windows node in AKS can not connect to service in linux pool
Node pools: 2 (Linux and Windows) Kafka installed in Linux nodes along with other asp.net core services. So far so good. asp.net framework 4.8 app in a container is on win node. Kafka client is not able to resolve the names. Using…
asked 2020-10-23T20:17:37.817+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, 16%, 36%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESA%3C/text%3E%3C/svg%3E)
Savinder Arora
6
Reputation points
commented 2020-10-26T22:04:57.68+00:00
Savinder Arora
6
Reputation points
1 answer
One of the answers was accepted by the question author.
Azure Backup: Does Azure Backup use SQL AlwaysOn AG Backup Preferences?
Following the setup process outlined here: https://learn.microsoft.com/en-us/azure/backup/backup-sql-server-database-azure-vms. I am using a three server Azure SQL VM AlwaysOn AG, with a backup policy applied to the AlwaysOn AG. The AG backup…
![](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, 38%, 36%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJ%3C/text%3E%3C/svg%3E)
1 answer
Azure TLS証明書の更新の影響
SQL Server in VM -Windows 上のIISにWebサイトをホストしており、そのWebサイトにはLet'sEncryptの証明書を設定しています。 AzureからTLS証明書の更新のアナウンスがされていますが、上記VMについて何か対応が必要でしょうか。
asked 2020-10-22T01:53:11.18+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(67.2, 7.000000000000001%, 16%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EN%3C/text%3E%3C/svg%3E)
natsu
1
Reputation point
answered 2020-10-22T23:07:16.897+00:00
KarishmaTiwari-MSFT
18,612
Reputation points Microsoft Employee
1 answer
One of the answers was accepted by the question author.
SQL Always On did not failover
Hi, we did several failover tests with SQL Always On, restarting the server and disconnecting the network card everything worked perfectly. But in a specific test we noticed that the failover did not occur and it shows the server status as…
2 answers
One of the answers was accepted by the question author.
Setup Alwayson with one node onprem and one azure vm node
Is it possible to Setup Alwayson with one node on-prem and one azure VM node. This is going to be a new setup. I have read all about extending "existing" Availabiity groups etc, But have not found setting up new one node on-prem plus one node…
asked 2020-10-03T19:46:04.01+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(67.2, 96%, 16%)' 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)
MANINDER SINGH
21
Reputation points
accepted 2020-10-05T18:26:41.44+00:00
MANINDER SINGH
21
Reputation points
2 answers
backup and recovery for AAG on Azure VM
Recovery Services vault is able to backup database on the SQL installed on VM , as well as AAG. Suppose i am having 3 nodes AAG , 2 on east asia , 1 on south east asia. if somehow, I will need to use the backup(maybe rebuild the whole AAG) from…
asked 2020-09-17T02:59:29.553+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, 40%, 23%)' 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)
sakuraime
2,321
Reputation points
commented 2020-10-05T18:26:06.157+00:00
prmanhas-MSFT
17,891
Reputation points Microsoft Employee
1 answer
Azure Backup : Autoprotect is not working for AAG
Autoprotect is not working for AAG , added new database to the AG , but the next backup schedule is not including the backup of the database. (test3 was added to the AG)
asked 2020-09-22T03:43:24.877+00:00
sakuraime
2,321
Reputation points
commented 2020-09-29T08:11:26.72+00:00
SadiqhAhmed-MSFT
38,891
Reputation points Microsoft Employee
1 answer
One of the answers was accepted by the question author.
Are Instance Pools and Elastic Pools same when it comes to Azure SQL PaaS?
Are Instance Pools and Azure SQL Elastic Pools same thing when it comes to Azure SQL PaaS ? In the video https://www.youtube.com/watch?v=aRwJGaB3zsA it mentions about Instance Pool, so i would like to know if it is same as Elastic Pool or not. Thanks
asked 2020-09-26T01:04:47.093+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(0, 7.000000000000001%, 10%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EPC%3C/text%3E%3C/svg%3E)
Pallab Chakraborty
401
Reputation points
accepted 2020-09-28T19:22:28.04+00:00
Pallab Chakraborty
401
Reputation points
0 answers
Azure Logic Apps Import csv from BLOB storage into Azure SQL VM
I have a logic app process that downloads email attachments and moves them into blob storage. I am wanting to move from blob storage into Azure SQL VM and I get the following error: "error": { "message": "A value must be…
asked 2020-09-16T14:33:56.433+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(19.2, 45%, 11%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJS%3C/text%3E%3C/svg%3E)
Jason Squires
1
Reputation point
commented 2020-09-28T12:59:19.133+00:00
Jason Squires
1
Reputation point
1 answer
Load Simulation - Compare SQL performance on-prem to Azure
(I'll cross-post this to Azure Q&A as well...) I need to perform a load simulation against an on-prem SQL Server and against a Azure VM running SQL Server. The purpose is to compare latency, response time, etc. I get there are many variables…
asked 2020-09-17T04:26:02.8+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(150.4, 89%, 24%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EDC%3C/text%3E%3C/svg%3E)
David C
191
Reputation points
commented 2020-09-28T11:22:51.737+00:00
prmanhas-MSFT
17,891
Reputation points Microsoft Employee
4 answers
Sync new records in Prod to QA in Azure SQL Managed Instance
We have two Azure SQL Managed Instance QA and Prod they are in the same Subscription. Any new records in Prod (minus the identity column) we would like to include it into the QA as we don't want to replicate the table as the Prod has unique identity…
![](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(134.4, 90%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EK%3C/text%3E%3C/svg%3E)
![](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, 80%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJ%3C/text%3E%3C/svg%3E)
1 answer
Configure secondary replica on Alwayson Availability Group
Hi, I am configuring Always On and I would like to know if it is possible to configure the secondary replica to remain in Recovery, without read access (Like Database mirroring)? I already made some settings but I couldn't. Could someone…
asked 2020-09-06T13:37: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(275.2, 12%, 36%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EFS%3C/text%3E%3C/svg%3E)
fernando satonni
1
Reputation point
commented 2020-09-16T19:16:14.117+00:00
prmanhas-MSFT
17,891
Reputation points Microsoft Employee
1 answer
Azure Web App accessing the Sql Server running in Azure VM(IaaS) Solution
Hi I have Azure Web App running in EAST us region and associated with the Virtual network. 1) I have Sql Server Database running on my On premise Environment,I need to access On premise SqlServer database from Azure Web App. 2) I have another Sql Server…
asked 2020-09-11T06:22:51.53+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(265.6, 76%, 35%)' 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)
Amar-Azure-Practice
656
Reputation points
commented 2020-09-13T18:30:51.763+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(153.6, 92%, 24%)' 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)
ajkuma
22,766
Reputation points Microsoft Employee