SQL Server on Azure Virtual Machines
An Azure service that is used to provision Windows and Linux virtual machines.
364 questions
364 questions with SQL Server on Azure Virtual Machines tags
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
25,366
Reputation points
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.
![](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
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,551
Reputation points
accepted 2022-12-28T11:05:52.737+00:00
Glenn Maxwell
10,551
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)
1 answer
Azure Script to find IAAS disk configurations
Hi All, I am trying to use below PS script to find out azure IAAS disk configuration including (LUN,Data Caching,IO,Bandwidth). Connect-AzAccount Set-AzContext -Subscription 'SubName' $vm=Get-AzVM -ResourceGroupName ReGrpNAME -Name…
![](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(252.8, 84%, 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)
1 answer
One of the answers was accepted by the question author.
Azure IAAS VM's comparison
Hi All, I have two node identical replicas having AG's. They are lifted to Azure from On-prem. I found similar difference in configuration. They dont match the sku's and disk configurations. Eg:- Data drive is Standard SSD in one VM and Premium…
1 answer
One of the answers was accepted by the question author.
Minimum SQL Server role to check SQL Agent status with PowerShell?
I need to execute the PowerShell to remotely check the SQL backup job status on each SQL Database instance across multiple SQL servers but as a Read Only user account. What are the minimum credentials or SQL Server role that I can use to query the…
asked 2022-12-08T13:06:01.163+00:00
EnterpriseArchitect
4,916
Reputation points
commented 2022-12-08T14:09:40.457+00:00
Alberto Morillo
33,176
Reputation points MVP
1 answer
SQL Renaming a column of a temp table
I can't get what is not working in the below bold highlighted line. I would be grateful to anyone who could help me! DECLARE @AssetWithDrawStartDate DATE; DECLARE @AssetWithDrawDate DATE; DECLARE @TradeStartDate DATE; DECLARE @TradeDate …
asked 2022-11-29T11:56:34.63+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(316.8, 6%, 40%)' 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)
SamBa1927
1
Reputation point
commented 2022-12-02T05:08:04.287+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(220.8, 4%, 31%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESM%3C/text%3E%3C/svg%3E)
ShaktiSingh-MSFT
14,166
Reputation points Microsoft Employee
1 answer
One of the answers was accepted by the question author.
Restore TDE-Encrypted DataBase with BYOK in Azure Managed Instance to another Subscription
Is it Possible to Restore TDE-Encrypted Database with BYOK in Azure Managed Instance to another Subscription?
asked 2022-11-23T08:55:10.767+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(198.4, 54%, 29%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EYG%3C/text%3E%3C/svg%3E)
Youssef, Ghadeer
41
Reputation points
commented 2022-11-29T17:03:31.42+00:00
GeethaThatipatri-MSFT
28,462
Reputation points Microsoft Employee
2 answers
One of the answers was accepted by the question author.
Migrate SQL Server on a VM to Azure SQL Databases
Hi everyone, I hope you are very well! I need to migrate a SQL Server database that we have in a virtual machine to a running SQL Database in a SQL Server and I don't know how to do it. Some help please?
![](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, 94%, 35%)' 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)
2 answers
One of the answers was accepted by the question author.
On premise SQL server Licencing
Hi Team , Currently , We have an on-premise prod VM with SQL server along with BI tools (SSRS). Now, we are planning to provision two azure vm's for prod and dev environment on cloud. We are planning to use Azure SQL MI to host the Report databases. …
asked 2022-11-22T07:23:07.367+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(163.2, 30%, 25%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ETB%3C/text%3E%3C/svg%3E)
Thyagarajulu B M
121
Reputation points
accepted 2022-11-23T08:03:14.447+00:00
Thyagarajulu B M
121
Reputation points
3 answers
how to export bacpac file to azure blob storage from sql server using sqlpackage
I have some databases in the SQL server and I want to migrate them to the Azure SQL database for this I am using sqlpackage.exe for exporting and importing the databases. the issue is while exporting the database bacpac files are made in local disk, not…
asked 2021-09-07T08:57:13.73+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(28.799999999999997, 25%, 12%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESJ%3C/text%3E%3C/svg%3E)
Shubhi Jain
21
Reputation points
answered 2022-11-22T10:56:08.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(16, 94%, 11%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EDR%3C/text%3E%3C/svg%3E)
Danial Raj
1
Reputation point
0 answers
Manually run a SQL Policy in Azure Backup
I created a SQL policy in Azure backup that performs a Full DB backup every night at 11PM and also runs Hourly Log Backups. The target SQL server has 14 databases on it, and I want to manually run a backup of the entire server. It seems like I…
asked 2022-11-03T15:25:47.923+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(236.8, 19%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJC%3C/text%3E%3C/svg%3E)
Joe Correia
1
Reputation point
commented 2022-11-21T11:01:01.55+00:00
SadiqhAhmed-MSFT
39,726
Reputation points Microsoft Employee
2 answers
One of the answers was accepted by the question author.
Restore .bak into SQL Managed Instance
We have a requirement where a third-party vendor sends us .bak files every day and I have managed to find a way to restore the .bak into SQL managed instance using the Restore command. I need to know how much it will cost to restore and drop…
![](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(16, 38%, 11%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESB%3C/text%3E%3C/svg%3E)
2 answers
Azure App service failing to connect to the Azure SQL VM Server
The connection string of my .NET application to connect to the database has been provided in the configuration of an Azure App service and the database is present in an Azure SQL Virtual Machine, when trying to access the APIs of my application I see the…
asked 2022-11-07T08:29:56.457+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(102.4, 17%, 19%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EVK%3C/text%3E%3C/svg%3E)
VAMSY KRISHNA REDDY
6
Reputation points
answered 2022-11-07T08:52:27.983+00:00
Manu Philip
17,021
Reputation points MVP
1 answer
One of the answers was accepted by the question author.
Azure Virtual machine SQL web database limit per license
What is the number of databases you can have on a standard SQL web license on azure VM
asked 2022-11-02T11:41:03.423+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(211.20000000000002, 36%, 30%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJD%3C/text%3E%3C/svg%3E)
Janco De Wet
21
Reputation points
accepted 2022-11-02T11:48:20.013+00:00
Janco De Wet
21
Reputation points