SQL Server on Azure Virtual Machines
An Azure service that is used to provision Windows and Linux virtual machines.
356 questions
356 questions with SQL Server on Azure Virtual Machines tags
2 answers
All physical cores of Host server on premise is licensed with "SQL Server Enterprise"- Can we use SA benefit unlimited virtualization to license VM deployed on licensed Server with "Azure arc enabled SQL server" .
All physical cores of Host on premise server is licensed with "SQL Server Enterprise". Can we use SA benefit "unlimited virtualization" to license VM deployed on licensed Server with "Azure arc enabled SQL server" ? or we…
asked 2023-04-02T20:27:34.6733333+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(249.60000000000002, 20%, 34%)' 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)
Ajit
0
Reputation points
edited the question 2023-04-03T14:30:58.72+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, 41%, 36%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAM%3C/text%3E%3C/svg%3E)
AnuragSingh-MSFT
20,016
Reputation points
1 answer
One of the answers was accepted by the question author.
GuestConfig agent failed to compute compliance status for Windows Server 2022 in Azure
Hello Team, I'm trying to Compliant the "Windows Web Server ha Secure Communication Protocols" Policy for my azure VM. The Compliance Status shows me Non-Compliant because of GuestConfig agent failed to compute the compliance status. Cannot…
![](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(195.2, 89%, 28%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ER%3C/text%3E%3C/svg%3E)
2 answers
RTO for cross region restore of sql on VM
Based on this article there is an RPO definition for using cross region restore for a sql database on VM I couldn't find what is the RTO for this type of ability? Is it documented somewhere?
![](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(28.799999999999997, 88%, 12%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAL%3C/text%3E%3C/svg%3E)
1 answer
Unclear RPO and RTO for SQL always on availability group
The article about BCDR for SQL Server provides a descriptive information regarding RTO and RPO for using Always On availability group for SQL Server on Azure VM (RTO: The time taken to make the secondary replica as primary, RPO: Because replication to…
1 answer
A network-related or instance-specific error occurred while establishing a connection to SQL Server.
I am using a macbook m1 pro while i am connecting to azure data base it is showing an error but i have done everything correctly but i dont know what is the problem occured please help me with this
asked 2023-02-04T18:34:19.05+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, 8%, 36%)' 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)
Ahamed Ajas
0
Reputation points
commented 2023-02-27T20:59:36.7033333+00:00
Oury Ba-MSFT
16,391
Reputation points Microsoft Employee
1 answer
error with msodbc installation on docker
I had a container where I installed msodbc successfully 2023-02-11T19:37:57.4354185Z Step 26/48 : RUN sudo ACCEPT_EULA=Y apt-get install -y msodbcsql17 2023-02-11T19:37:57.4581744Z ---> Running in 4a4103163268 2023-02-11T19:37:58.7290566Z Reading…
asked 2023-02-14T16:39:23.99+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(227.2, 10%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EHA%3C/text%3E%3C/svg%3E)
Huhn, Alexander
95
Reputation points
commented 2023-02-24T18:09:32.9233333+00:00
deherman-MSFT
33,471
Reputation points Microsoft Employee
2 answers
One of the answers was accepted by the question author.
Azure SQL Database and General Azure Questions
Hello everyone, We are experinced in on-premise world, but when it comes to cloud world we are rookie. So, we have some questions to understand Azure Cloud. Like Oracle SQL and ODI in on-premise world, What is the best tool combination in terms of…
asked 2023-02-20T08:10:34.9266667+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(105.60000000000001, 73%, 20%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EKK%3C/text%3E%3C/svg%3E)
Kerem Kabil
20
Reputation points
commented 2023-02-22T08:33:43.5366667+00:00
Kerem Kabil
20
Reputation points
3 answers
I installed the sql server in Azure Windows VM(IAAS) service to configure to azure webapp
I installed the SQL server in Azure Windows VM(IAAS) service to configure the azure web app using VNet Integration But it is not connected and also I set up the NSG rules to the VM. Can you plz suggest to me how to integrate IAAS SQL into Azure Web…
asked 2023-01-24T10:11:01.9933333+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(48, 75%, 14%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ECS%3C/text%3E%3C/svg%3E)
Chakali Sekshavali
0
Reputation points
edited the question 2023-02-16T02:40:45.44+00:00
Ryan Hill
25,826
Reputation points Microsoft Employee
1 answer
One of the answers was accepted by the question author.
Need to migrate from SQL 2016 onprem to Azure Synapse or SQL server on VM or MI, which option is best in terms of cost and compatibility. Total database size is around 110GB.
Need to migrate from SQL 2016 onprem to Azure Synapse or SQL server on VM or MI, which option is best in terms of cost and compatibility. Total database size is around 110GB.
asked 2023-02-14T05:21:32.9566667+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(3.2, 77%, 10%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EGU%3C/text%3E%3C/svg%3E)
gupta, Utkarsh
41
Reputation points
edited a comment 2023-02-14T17:51:48.26+00:00
gupta, Utkarsh
41
Reputation points
3 answers
One of the answers was accepted by the question author.
Should we use second network card for SQL Server AlwaysOn AG group private network on VMs?
We are using VMs for all SQL Servers. Network cards will be virtual as well. When we build AlwaysOn AG group, should we use two network cards for each nodes? One for private which can use for mirror/replication data, one for listener or public? Or…
asked 2023-02-09T23:51:30.1633333+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(41.6, 43%, 14%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESR%3C/text%3E%3C/svg%3E)
Sky River
66
Reputation points
answered 2023-02-12T02:39:20.0733333+00:00
vipullag-MSFT
24,206
Reputation points Microsoft Employee
2 answers
One of the answers was accepted by the question author.
How to restore azure sql server database from .bak file located in blob storage automatically with sql server agent jobs
Hi! My current setup consists of a blob storage account cointaining .bak backup files, in addition to an SQL server running on an Azure Virtual Machine. I want to automatically restore the database located at the sql server every night (when a new .bak…
asked 2023-01-14T18:46:17.87+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(188.79999999999998, 57.00000000000001%, 28%)' 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)
August Asheim Birkeland
20
Reputation points
commented 2023-01-28T11:32:00.1+00:00
August Asheim Birkeland
20
Reputation points
1 answer
How can I get SQL VM retail rates using REST API?
I want to get the platform retail rates of my SQL VMs that I have running, but through code using the REST API but can't find any rates for SQL VMs. I don't want to manually use the Azure Calculator and the rates and rate card attributes of resources are…
asked 2022-12-30T15:35:15.74+00:00
Matthew Blessing
46
Reputation points
edited a comment 2023-01-24T14:04:42.25+00:00
Matthew Blessing
46
Reputation points
1 answer
One of the answers was accepted by the question author.
Unable to connect to Azure SQL database from SSMS
Hi, I followed this blog to create SQL Virtual Machine. I am able to connect to the default DB within the VM itself, but Not able to connect through my ocal workstation(Laptop). TITLE: Connect to Server …
asked 2021-10-27T11:39:21.447+00:00
Rajesh Swarnkar
851
Reputation points
edited the question 2023-01-18T04:05:04.14+00:00
vipullag-MSFT
24,206
Reputation points Microsoft Employee
1 answer
One of the answers was accepted by the question author.
KQL to monitor Sql Server Performance for Azure SQLVM
All, I'm looking KQL query to monitor SQL Server performance for Azure SQLVm using Log analytics workspace. Thanks.
2 answers
One of the answers was accepted by the question author.
How to expand sql datadisk
Hello everyone. I have an VM sql server with a DATADISK of 128GB I need to extend the disk and I see this: When I try to add for example 32Gb I obtain an error: So...I need first to modify my Datadisk 128GB to 256gb? (not possible to add only 32…
asked 2023-01-10T18:16:22.473+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, 20%, 35%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EOM%3C/text%3E%3C/svg%3E)
Oscar Moyano
66
Reputation points
answered 2023-01-10T19:24:50.907+00:00
Oscar Moyano
66
Reputation points
1 answer
One of the answers was accepted by the question author.
Does Get-AzSqlDatabase pull info from a SQL instance on a Azure VM ? I get this when i try.
Get-AzSqlDatabase : Can not perform requested operation on nested resource. Parent resource 'SQLInstance' not found. At S:\BackupStatus\All SQLServers.ps1:13 char:9 Get-AzSqlDatabase -ResourceGroupName $server.ResourceGroupNam ... …
asked 2023-01-05T16:04:40.077+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(73.60000000000001, 43%, 17%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ENR%3C/text%3E%3C/svg%3E)
Narasimhan, Ranga
26
Reputation points
accepted 2023-01-05T19:31:15.24+00:00
Narasimhan, Ranga
26
Reputation points
5 answers
Azure VM Type
Hi Team, While calculating cost of the Azure VM (through Azure calculator) on which SQL Server Standard 2019 is to be installed, for Type dropdown, what is the difference between OS only and SQL Server? Does this means for calculating cost of an…
asked 2022-12-04T15:28:31.447+00:00
salilsingh-9961
346
Reputation points
answered 2023-01-02T02:04:12.567+00:00
Łukasz Przyjemski
11
Reputation points
1 answer
One of the answers was accepted by the question author.
Backup PostgreSQL
Hi All i have Azure Database for PostgreSQL server(Resource Type: Azure Database for PsotgreSQL flexible server). I want to take the backup as application team is performing an upgrade.
asked 2022-12-28T05:45:08.29+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(179.20000000000002, 7.000000000000001%, 27%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EGM%3C/text%3E%3C/svg%3E)
Glenn Maxwell
10,146
Reputation points
accepted 2022-12-28T11:05:52.737+00:00
Glenn Maxwell
10,146
Reputation points
3 answers
One of the answers was accepted by the question author.
Connect SQLCMD in Linux using root user
Hi, how to connect SQLCMD in Linux using root user? We have SA account which got automatically disabled and there is no other login available to enable the SA Account or login to SQL Server SSMS. So, is there any way to login to SQL Server using…
asked 2022-12-25T11:52:10.307+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(57.599999999999994, 31%, 15%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EGB%3C/text%3E%3C/svg%3E)
Gnana Balaji Kanagaraj
41
Reputation points
answered 2022-12-26T09:26:27.503+00:00
Gnana Balaji Kanagaraj
41
Reputation points
1 answer
One of the answers was accepted by the question author.
do we have option to retsore sqldb in azure sql backup to different subscription
Hi Team, Do we have option to restore sql db from one subscription to another one like azure vm backup? From azure portal, we are unable to see the selection if different subscription during the sqldb restore Can you please check and update?…
![](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(35.2, 93%, 13%)' 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)