371 questions with SQL Server on Azure Virtual Machines tags
Questions Using the Azure Temp Drive for TempDB
I have seen several articles around the Internet describing the use of the Azure temporary drive for TempDB storage. It brought up a couple of questions for me. 1. What is the temp drive physical hardware, Standard SSD, Premium SSD, Ultra SSD? How can I…
Deploying SQL Server with High Availability fails due to access denied error
I'm having trouble deploying SQL Server with High Availability from the Azure Marketplace. VMs and storage deploy successfully, but it fails on the Create new or update existing availability group listener step with the AccessDenied error seen…
![](https://techprofile.blob.core.windows.net/images/Ui4mhP2_BgAAAAAAAAAAAA.png?8DBD40)
Use SQL Server 2022 License Key to Install SQL Server 2019
Hi, I have installed SQL Server 2019 on our cloud EC2 Windows server machine using the SQL Server Evaluation Edition with a 180-day free trial. We intend to purchase the SQL Server 2022 Standard Edition key. Can we use this key to activate the SQL Server…
![](https://techprofile.blob.core.windows.net/images/SClx3RWTrEKkXmthAyq7Tw.png?8DC805)
How do I set up a Virtual Server
i purchased a Support Plan and there's no way of accessing it, nor any phone numbers. I need help - this is new to me.
OperationalError: ('HYT00', '[HYT00] [Microsoft][ODBC Driver 17 for SQL Server]Login timeout expired (0) (SQLDriverConnect)')
Hi, I am encountering an issue while trying to connect to an SQL database using a Python script in my Jupyter notebook. The connection attempt results in the following error message: OperationalError: ('HYT00', '[HYT00] [Microsoft][ODBC Driver 17 for SQL…
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…
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…
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.
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 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…
![](https://techprofile.blob.core.windows.net/images/11383538604a4ebf917c4c483d39cbda.png)
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…
![](https://techprofile.blob.core.windows.net/images/J-cKqdzNMkWeJv8idBgCcQ.png?8DC812)
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
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…
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…
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
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…
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…
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 =…
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?
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…
![](https://techprofile.blob.core.windows.net/images/kjzQAO5Oq0Oj37wdNf6qTQ.png?8D8E42)