SQL Server on Azure Virtual Machines
An Azure service that is used to provision Windows and Linux virtual machines.
367 questions
367 questions with SQL Server on Azure Virtual Machines tags
2 answers
Preventing Database Deletion in SSMS
prevent accidental database deletions within SQL Server Management Studio (SSMS). Currently, I am exploring options to enforce this restriction effectively implemented a DDL trigger Is the above DDL trigger approach appropriate for preventing…
asked 2024-06-28T13:20:16.26+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(96, 79%, 19%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ENK%3C/text%3E%3C/svg%3E)
Niket Kumar Singh
280
Reputation points
edited the question 2024-06-29T05:54:03.98+00:00
Niket Kumar Singh
280
Reputation points
2 answers
One of the answers was accepted by the question author.
Query on Data Disk
I want to instal SQL server on Azure VM. For test and Production. How many data disks are required and what should be sizes of each of them.
asked 2024-06-21T15:16:31.77+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(83.2, 64%, 18%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESG%3C/text%3E%3C/svg%3E)
Shailesh Ganesh Shripati
170
Reputation points
accepted 2024-06-22T04:27:30.78+00:00
Shailesh Ganesh Shripati
170
Reputation points
1 answer
How long are SQL VM Automated backup Shared Access Signature Tokens Valid for
As part of our security and compliance checks, we've been looking at the Automated backup functionality used to take SQL backups and store them in Azure Storage. As part of this, it looks like a Shared Access Signature Token is generated and stored in…
SQL Server on Azure Virtual Machines
SQL Server on Azure Virtual Machines
An Azure service that is used to provision Windows and Linux virtual machines.
367 questions
Azure
Azure
A cloud computing platform and infrastructure for building, deploying and managing applications and services through a worldwide network of Microsoft-managed datacenters.
1,070 questions
asked 2024-06-18T09:34:28.7+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(6.4, 94%, 10%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EKR%3C/text%3E%3C/svg%3E)
Keiran Royston
0
Reputation points
answered 2024-06-18T10:45:52.07+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,201
Reputation points Microsoft Employee
3 answers
SQL Managed Instance and Virtual Cluster Stuck Deleting
I have a sql managed instance and virtual cluster stuck on delete for over 24 hours. I'm not sure the details leading up to this, but the SQL MI was created, but now it shows deleting and is stuck there. The managed instance is showing it is in deletion…
SQL Server on Azure Virtual Machines
SQL Server on Azure Virtual Machines
An Azure service that is used to provision Windows and Linux virtual machines.
367 questions
Azure SQL Database
Azure SQL Database
An Azure relational database service.
5,329 questions
Azure
Azure
A cloud computing platform and infrastructure for building, deploying and managing applications and services through a worldwide network of Microsoft-managed datacenters.
1,070 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.
13,164 questions
asked 2024-06-12T15:18:12.3833333+00:00
Jeff Brown Tech
6
Reputation points
answered 2024-06-12T15:23:50.8733333+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, 79%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERR%3C/text%3E%3C/svg%3E)
Rahul Randive
9,011
Reputation points Microsoft Employee
1 answer
Query on VM SKU
Hi All, I have an Azure VM with SKU type E64-32ds v5 (32 vCPUs, 512 GiB memory). I am unable to add more disks as I have reached the maximum of 32. Do we have any SKU that supports more than 32 disks? The new SKU should still have 32 vCPUs, but the…
asked 2024-06-11T05:48:49.1966667+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, 72%, 35%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERR%3C/text%3E%3C/svg%3E)
Roger Roger
5,046
Reputation points
answered 2024-06-11T07:22:57.8233333+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(217.60000000000002, 24%, 31%)' 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)
akinbade abiola
6,420
Reputation points
5 answers
Upgrade required
Hi Team, I am having SQL Server 2022 Developer edition on my windows machine. I need to upgrade below (to avoid any security vulnerability) - SQL Server 2022 Developer edition OLEDB ODBC Please let me know the steps(links) for same. Let me know if…
asked 2024-05-29T18:03:08.4666667+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, 61%, 36%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESS%3C/text%3E%3C/svg%3E)
Salil Singh
20
Reputation points
commented 2024-06-04T06:32:29.47+00:00
LucyChenMSFT-4874
2,820
Reputation points
3 answers
How to monitor SQLServer in a windows Azure Virtual Machine and send logs to log analystic workspace
How to monitor SQLServer in a windows Azure Virtual Machine and send logs to log analystic workspace
asked 2024-05-31T07:57:25.2566667+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(134.4, 15%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EHP%3C/text%3E%3C/svg%3E)
Harsha Parasa
20
Reputation points
answered 2024-06-03T05:54:39.44+00:00
ShaktiSingh-MSFT
14,201
Reputation points Microsoft Employee
1 answer
Connecting Azure web app service (.net8) to SSRS on Azure VM by using private DNS
My azure web app service(.net8) connect to SSRS on VM by using the private DNS name provided by Azure to the VM, but my credentials did not work when I run the report on my azure web app server. The private DNS name works fine with my credentials via url…
asked 2024-05-29T19:10:30.8133333+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(246.4, 89%, 33%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EB%3C/text%3E%3C/svg%3E)
Billey
10
Reputation points
answered 2024-05-31T15:55:50.37+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(243.2, 72%, 33%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ECB%3C/text%3E%3C/svg%3E)
Chris Boyce
20
Reputation points
1 answer
Azure - Connecting web app service to SSRS using Auto assigned private DNS
I am working on a project using SSRS on a VM , SQL Managed instance and a Web app service (.net8) . I am trying to use the private DNS name provided by Azure to the VM and opened port 80 and connect via url I can hit the SSRS reports server through a…
asked 2024-05-17T06:05:06.3766667+00:00
Chris Boyce
20
Reputation points
answered 2024-05-24T16:04:36.3533333+00:00
Chris Boyce
20
Reputation points
1 answer
One of the answers was accepted by the question author.
How to delete this protected storage account?
Failed to delete storage account Failed to delete storage account 'tejas761'. Error: tejas761 is protected from deletion. Facing this problem how to solve this
![](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(92.8, 87%, 18%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EC%3C/text%3E%3C/svg%3E)
1 answer
One of the answers was accepted by the question author.
Azure Managed disk performance analysis for SQL Server DB Backup
We are currently trying to optimize cost in our Azure environment and are reviewing dedicated backup disks on servers. We have a few servers running single Premium SSD P50 - 4TB as backup disks, but the actual backup files on these drives are often less…
asked 2024-05-11T11:20:30.0233333+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, 55.00000000000001%, 17%)' 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)
Abimbola Adeniran
46
Reputation points
accepted 2024-05-14T08:39:12.5733333+00:00
Abimbola Adeniran
46
Reputation points
3 answers
How to backup SQL database in Azure VM from SQL agent?
Hello, we are intending to transfer all SQL database baackups to Azure and have several backups that we need to run manually/on-demand using SQL agent jobs. I have created a backup policy specifically for on-demand backups, and while some online sources…
asked 2024-03-25T15:02:53.0866667+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(224.00000000000003, 57.00000000000001%, 31%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESK%3C/text%3E%3C/svg%3E)
Sridhar.Kamala
5
Reputation points
commented 2024-05-10T03:31:01.96+00:00
ShaktiSingh-MSFT
14,201
Reputation points Microsoft Employee
2 answers
How to get the SQL Server version details (CU) install in sql server VM from cloud shell?
Hi, What are the options available to get SQL server versions(CU) install in SQL Server VM. THis is needed to maintain the wiki package for multiple vm across the multiple environment, I have tried $serverName =…
asked 2024-05-02T10:58:37.3566667+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(208, 53%, 30%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EUF%3C/text%3E%3C/svg%3E)
Ummer, Fazil
0
Reputation points
answered 2024-05-03T08:35:32.74+00:00
ShaktiSingh-MSFT
14,201
Reputation points Microsoft Employee
1 answer
Dataflow sink table as a source
I am trying to add the sink as source in order to implement exist and lookup for SCD Type 2 but the source table (from the sink) is blank no column names or data, does anyone perhaps know why that is? How can I resolve this?
asked 2024-04-17T09:26:25.06+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(259.20000000000005, 55.00000000000001%, 35%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMR%3C/text%3E%3C/svg%3E)
Mogale Rickie
0
Reputation points
commented 2024-04-18T05:07:30.5033333+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' %3EST%3C/text%3E%3C/svg%3E)
Smaran Thoomu
12,005
Reputation points Microsoft Vendor
1 answer
migrating Database backup from One subscription to another frequently
As a user, I currently have one SQL Server deployed in a single Azure subscription. While I don't currently have any automation set up, I believe I can create automation within the same Azure subscription. However, I'm exploring the possibility of…
asked 2024-03-27T10:50:15.94+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, 34%, 27%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMA%3C/text%3E%3C/svg%3E)
Muhammad Ahmer
0
Reputation points
edited the question 2024-04-04T21:48:32.5366667+00:00
Oury Ba-MSFT
17,556
Reputation points Microsoft Employee
2 answers
Query regarding SQL production license to setup SQL server on Windows VM
Query regarding SQL production license to setup SQL server on Windows VM
asked 2024-03-14T17:05:00.21+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, 20%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERS%3C/text%3E%3C/svg%3E)
Ramit Sharma
0
Reputation points
answered 2024-03-15T01:26:34.5+00:00
ZoeHui-MSFT
34,756
Reputation points
1 answer
Data Migration from One Environment to Other
I have a graph database on cosmos dB, and I need to migrate the data to a different environment. Need suggestions on how to move this. I did some research and figured out an Azure Data Migration tool but I am not sure what would be the partition key for…
asked 2024-03-07T16:59:36.0966667+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(25.6, 57.99999999999999%, 12%)' 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)
Surya
0
Reputation points
commented 2024-03-11T18:13:14.82+00:00
Oury Ba-MSFT
17,556
Reputation points Microsoft Employee
1 answer
How to solve the SQL Server is not connected in Azure when deploy the website?
My website is on fabjoey23.azurewebsites.net. Help to avoid this two errors: Error. An error occurred while processing your request. Request ID: 00-9fe33736939a1a5c2963eb30d4b132ed-3d31b53b23b27dea-00 Development Mode Swapping to Development environment…
asked 2024-03-06T05:49:50.4466667+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, 24%, 36%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ETF%3C/text%3E%3C/svg%3E)
Thibaut Fabrice
0
Reputation points
commented 2024-03-08T17:02:21.0366667+00:00
deherman-MSFT
34,841
Reputation points Microsoft Employee
2 answers
High cost of my Azure subscription for a small SQL server and couple of web services
Setting this first time in my life Have registered for Azure subscription and deployed my web services. Also setup a sql server. Herein the cost is going too high for a extra small company owner like me. Tried to setup SQL Sever VM. But all options I…
asked 2024-03-03T14:43:11.5366667+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, 68%, 31%)' 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)
Sameer
0
Reputation points
edited a comment 2024-03-05T18:07:37.3366667+00:00
Oury Ba-MSFT
17,556
Reputation points Microsoft Employee
1 answer
Retrieve an SQL standard license for in place upgrade
We are running a SQL virtual machine SQL server under a developer license that needs to be upgraded to a standard SQL license. The payment for the SQL license is done through Azure so no license keys in our control. Now with the upgrade through the…
asked 2023-10-26T06:57:14.84+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(294.40000000000003, 49%, 38%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EB%3C/text%3E%3C/svg%3E)
bauke
0
Reputation points
commented 2024-03-04T06:17:29.01+00:00
Andy Lau Pik Hui
65
Reputation points