SQL Server on Azure Virtual Machines
An Azure service that is used to provision Windows and Linux virtual machines.
376 questions
0 answers
Cross subscription Azure SQL VM database restore using Azure CLI
Hi , Anyone tried restoring sql database running on Azure SQL VM and backed up via Azure Backup . Via recovery vault , we are able to perform the cross subscription restore but not using the Azure CLI . All desired permissions in place as documented by…
asked 2024-10-14T08:16:53.7466667+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, 94%, 12%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ENV%3C/text%3E%3C/svg%3E)
Nikhil Verma
40
Reputation points
commented 2024-10-14T12:31:24.61+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(252.8, 60%, 34%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMK%3C/text%3E%3C/svg%3E)
Mahesh Kurva
245
Reputation points Microsoft Vendor
1 answer
How to bring real-time data from Azure sql DB to Microsoft fabric Lakehouse without using Fabric Mirroring and scheduling of pipelines.
I need to bring real time data from Azure SQL database to Microsoft Fabric Lakehouse. I checked for the option of Fabric Mirroring but there are many challenges in it so i need an alternative solution with realtime data availability. Please help me with…
asked 2024-10-04T10:49:14.6533333+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, 44%, 14%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJL%3C/text%3E%3C/svg%3E)
Jothi Lakshmi P M
0
Reputation points
commented 2024-10-14T09:27:05.0133333+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
16,005
Reputation points Microsoft Vendor
0 answers
Currently we are using Microsoft Azure SQL RTM developer edition 100 CAL licensed , my management asking me increase the Existing core values from 1 to 4 , how to do this with out any cost involving , is it possible ? pls share How to increase the cores .
Currently we are using Microsoft Azure SQL RTM developer edition 100 CAL licensed , my management asking me increase the Existing core values from 1 to 4 , how to do this with out any cost involving , is it possible ? pls share How to increase the cores…
asked 2024-10-10T07:56:40.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(6.4, 44%, 10%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESN%3C/text%3E%3C/svg%3E)
Srinivas Naraipeddi
0
Reputation points
commented 2024-10-14T09:18:03.2766667+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(35.2, 49%, 13%)' 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)
Vijayalaxmi Kattimani (Quadrant Resource LLC)
5
Reputation points Microsoft Vendor
0 answers
SQL Managed Instance Link failback feature issue
Dears, I would need assistance on Azure SQL Managed Instance Link feature. I have one managed SQL Instance (Primary role) and SQL Server 2022 update 15 running on virtual machine (Secondary role). I performed following steps and worked fine: Connection…
asked 2024-10-09T08:24:54.1766667+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(313.6, 44%, 40%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EWM%3C/text%3E%3C/svg%3E)
Waqar Mustafa
0
Reputation points
commented 2024-10-14T08:37:12.5066667+00:00
Vijayalaxmi Kattimani (Quadrant Resource LLC)
5
Reputation points Microsoft Vendor
0 answers
Login Issues with SQL Authentication After Enabling Entra ID Authentication
Previously, SQL Server was authenticated using SQL authentication, and I enabled Microsoft Entra ID authentication to allow direct connections to the database via SSMS. I implemented Entra ID authentication without removing the existing SQL…
asked 2024-10-14T06:20:53.25+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(12.8, 64%, 11%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EML%3C/text%3E%3C/svg%3E)
Mithila Lishan
166
Reputation points
commented 2024-10-14T08:09:30.5166667+00:00
MikeyQiaoMSFT-0444
3,105
Reputation points
2 answers
What is the best way to migrate SQL database to another SQL server in Azure. Minimal downtime.
Hi! I am fairly new to Azure, but have good onprem experience. Asked to migrate two databases (both used by an app) to another subscription/rg/location. Databases are hosted on Azure SQL Logical Serve, that is also the target. Standard tier. So the…
asked 2024-10-12T09:25:12.3266667+00:00
|_SQLViking_|
26
Reputation points
answered 2024-10-14T05:36:07.1933333+00:00
LucyChenMSFT-4874
4,750
Reputation points
1 answer
optimize connection pooling in PostgreSQL Flexible Server
I m currently using PostgreSQL Flexible Server on Azure for a web application that experiences variable traffic spikes throughout the day. I noticed performance degradation during peak time particularly with connectin management. What are the best…
asked 2024-10-14T03:41:57.5766667+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(256, 27%, 34%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERM%3C/text%3E%3C/svg%3E)
Rubens Max
80
Reputation points
edited an answer 2024-10-14T04:31:52.6033333+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, 46%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ENN%3C/text%3E%3C/svg%3E)
NIKHILA NETHIKUNTA
2,630
Reputation points Microsoft Vendor
1 answer
Unable to create a database in SQL Server | "The specified max size is invalid"
I am trying to create a database in SQL server under a subscription and its resource group through Python code, the response I get in the code is 202 but upon checking the logs, it shows failed. I am trying to copy the database from another sub and its…
asked 2024-10-13T13:01:06.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(57.599999999999994, 67%, 15%)' 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)
NoobSlayer
0
Reputation points
answered 2024-10-13T16:52:16.87+00:00
Alberto Morillo
33,866
Reputation points MVP
1 answer
One of the answers was accepted by the question author.
how to download microsoft SQL server management studio with Azure Data Studio in it?
how to download Microsoft SQL server management studio with Azure Data Studio in it? There's no "with Azure Data Studio" when I'm installing the sql (kindly refer to the screenshot below). I already uninstall then reinstall but nothing works. I…
asked 2024-10-13T04:29:12.52+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, 8%, 25%)' 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)
rizi
20
Reputation points
edited the question 2024-10-13T10:12:28.1+00:00
Erland Sommarskog
111.6K
Reputation points MVP
2 answers
One of the answers was accepted by the question author.
Vulnerability Scan on Azure SQL Server and found unexpected TLS 1.0, TLS 1.1, TLS 1.2 and SWEET32 issue
Hi there, Recently, I used the most popular vulnerability scanner to scan the Azure SQL Server (DB), and the results were unexpected. It showed a few vulnerabilities found, all of which were unexpected: TLS 1.0 FOUND TLS 1.1 FOUND TLS 1.2 with Weak…
![](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(76.8, 91%, 17%)' 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)
![](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(166.4, 44%, 26%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EFC%3C/text%3E%3C/svg%3E)
1 answer
One of the answers was accepted by the question author.
Setting up SQL server and database I did not have option to choose location US (East)
I got this error when setting up sql server: "Your subscription does not have access to create a server in the selected region. For the latest information about region availability for your subscription, go to aka.ms/sqlcapacity. Please try another…
asked 2024-10-09T18:12:13.83+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, 53%, 35%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ELM%3C/text%3E%3C/svg%3E)
Linda Mitchell
20
Reputation points
accepted 2024-10-12T18:39:54.0933333+00:00
Linda Mitchell
20
Reputation points
1 answer
One of the answers was accepted by the question author.
Error encountered while deploying Azure Data Sync Template
I am encountering the following errors while attempting to deploy an existing Azure Data Sync template to set up a new data sync. Failed to perform data sync operation: '' is invalid schema master (Code: SyncOperation_GenericFailure) Advisor…
asked 2024-10-10T16:51:55.9366667+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(128, 39%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESH%3C/text%3E%3C/svg%3E)
Subramanian Hariharan
20
Reputation points
commented 2024-10-12T10:14:02.73+00:00
Subramanian Hariharan
20
Reputation points
1 answer
Failed to connect to Azure SQL Database using Managed Identity: ('HYT00', '[HYT00] [Microsoft][ODBC Driver 18 for SQL Server]Login timeout expired (0) (SQLDriverConnect)')
Hello, I'm building an Azure Function in Python, this one will update an Azure SQL database. I've done this several times before successfully but this is the first time I have to do it with managed identity and it fails with Timeout. My Azure Function…
asked 2024-10-08T07:56:38.1166667+00:00
Philippe Vlaemminck
1
Reputation point
commented 2024-10-12T09:58:30.7466667+00:00
Vinodh247
21,226
Reputation points
2 answers
Access Azure Server database from azure portal without ip whitelist
I configure my Azure SQL server, such that Azure services is allowed to access my sql database server. But when login to azure and accessing my db, it is giving me error on ip not whitelisted. What need to be configured more if I do not want to add ip…
asked 2024-10-10T12:21:08.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(176, 53%, 27%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EVM%3C/text%3E%3C/svg%3E)
Vanessen Munisamy
0
Reputation points
answered 2024-10-12T02:53:51.02+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' %3ER%3C/text%3E%3C/svg%3E)
RahulRandive
9,666
Reputation points
1 answer
One of the answers was accepted by the question author.
Issue running job using Elastic Job Agent in dedicated SQL Pool (User Managed Identity)
I have an Azure SQL Server with a dedicated SQL Pool (probably prior to 2020) and a reporting database. I am trying to run elastic job agent using User Managed Identities (UMI) on all database in this Azure SQL Server. I have set up all the logins,…
asked 2024-09-11T22:08:23.3833333+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, 45%, 24%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EKG%3C/text%3E%3C/svg%3E)
Kshitij Gurung
20
Reputation points
commented 2024-10-10T22:02:41.7066667+00:00
Oury Ba-MSFT
19,176
Reputation points Microsoft Employee
1 answer
Azure Function App suddenly showing error on all environments
Since last saturday during the night we suddenly see an error appearing when an Azure Function is running. There were no changes from our end in the environment. The same thing happened on all environments, test ,staging and production. The Azure…
asked 2024-10-08T10:21:03.3233333+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(166.4, 66%, 26%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAV%3C/text%3E%3C/svg%3E)
Arjan Verus
0
Reputation points
answered 2024-10-10T20:21:19.95+00:00
Amira Bedhiafi
24,711
Reputation points
1 answer
Azure Sql database General Purpose: Gen5, 2 vCores pricing getting more from sept 2024 why?
Azure Sql database General Purpose: Gen5, 2 vCores pricing getting more from sept 2024 why?
asked 2024-10-10T11:55:00.59+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(278.4, 48%, 36%)' 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)
amreddy
0
Reputation points
answered 2024-10-10T19:36:47.2+00:00
Amira Bedhiafi
24,711
Reputation points
0 answers
Vulnerability Assessment is enabled on this server or one of its underlying databases with an incompatible version.
despite continuing to use the classic configuration, we are repeatedly encountering the same error. It seems that this issue persists even though we have not actually transitioned to the express configuration. Im trying to deploy using ARM template
asked 2024-10-03T18:10:35.47+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(89.60000000000001, 57.00000000000001%, 18%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EPA%3C/text%3E%3C/svg%3E)
Poovarasan Annadurai
20
Reputation points
commented 2024-10-10T16:18:59.9933333+00:00
Mahesh Kurva
245
Reputation points Microsoft Vendor
1 answer
How to restore Azure managed instance database Spilt backup or FILT backup files from Azure to Local server .
We are trying to restore Azure managed instance database Split or FILT backup files from azure to local server , how to restore multiple Split backup files in Local SQL server at a time .
asked 2024-10-08T10:57:00.45+00:00
Srinivas Naraipeddi
0
Reputation points
commented 2024-10-10T15:51:52.8466667+00:00
Mahesh Kurva
245
Reputation points Microsoft Vendor
1 answer
Azure SQL Managed Instance - How does the new database created in the portal reference the restored database from on-prem?
Hi All, I`m in the process of migrating SQL databases from on-premise to Azure SQL Managed instance. I have followed the "back up and restore" outlined here…
asked 2024-10-10T10:00:28.03+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(147.20000000000002, 74%, 24%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESE%3C/text%3E%3C/svg%3E)
Scott Evans
0
Reputation points
commented 2024-10-10T15:24:19.35+00:00
Mahesh Kurva
245
Reputation points Microsoft Vendor