Azure SQL Database
An Azure relational database service.
6,087 questions
1 answer
database "master" on Azure SQL server not available
Database 'master' on 'nsmazucaedb02.database.windows.net' not available. Session tracing ID of '{52C18183-CDB2-4756-A86C-466A96F6E3D6}'. (Error: 40613)
asked 2025-03-13T13:20:04.0833333+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, 28.999999999999996%, 36%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ENA%3C/text%3E%3C/svg%3E)
NSM Admin
0
Reputation points
answered 2025-03-15T14:10:29.7066667+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
10,306
Reputation points
1 answer
Azure Sql Automatic tuning is not working
How to fix Azure Sql Automatic Tuning? on the Azure portal, the recommendations page never loads. and when I run: select * from sys.database_automatic_tuning_options I get the following error: GetRecommendedActions operation failed. Error occured at…
![](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, 41%, 13%)' 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
We are locked out of our azure admin account. How can we restore access?
A developer has locked us out of our Azure SQL DB. How can we restore access if we are the product owner?
asked 2025-03-14T21:20:49.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(102.4, 73%, 19%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAG%3C/text%3E%3C/svg%3E)
Angela Gillisse
0
Reputation points
answered 2025-03-15T14:01:14.94+00:00
RahulRandive
10,306
Reputation points
0 answers
Trouble connecting Azure SQL Database to from my PC SSMS
I have paid for Support yet this form seems to be destined for a community forum (to judge by instructions above the box for input of Details. In the first instance how do I obtain the private support paid for, please?
asked 2025-03-14T13:59:14.95+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, 54%, 34%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJ6%3C/text%3E%3C/svg%3E)
JonathanPegg-6724
20
Reputation points
commented 2025-03-15T05:22:19.7566667+00:00
JonathanPegg-6724
20
Reputation points
1 answer
One of the answers was accepted by the question author.
Raise private support request
I have paid for support on Dev plan, confirmed in a receipt, yet Help + Support page does not show option to raise ticket for private support. The payment transaction was today so perhaps there's a lag time? So very opaque!
asked 2025-03-14T14:34:43.4933333+00:00
JonathanPegg-6724
20
Reputation points
commented 2025-03-15T05:18:51.5+00:00
JonathanPegg-6724
20
Reputation points
1 answer
Is Azure SQL Database 2014-04-01 API retirement affecting Microsoft.EntityFrameworkCore.SqlServer 1.1.1?
We received an email saying Azure SQL Database 2014-04-01 APIs will be retired on 31 Oct 2025. We have programs using Microsoft.EntityFrameworkCore.SqlServer version 1.1.1 to access the Azure SQL database service. I would like to know whether we are…
asked 2025-03-13T15:56:19.49+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, 99%, 18%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EEC%3C/text%3E%3C/svg%3E)
Edwin Chan
25
Reputation points
commented 2025-03-15T04:08:41.57+00:00
Edwin Chan
25
Reputation points
1 answer
How to shrink 10 TB database in Azure Managed Instance
How to shrink 10 TB database in Azure Managed Instance. is it possible?
asked 2025-03-06T05:26:58.82+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, 46%, 11%)' 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)
Vijay Kumar
2,036
Reputation points
commented 2025-03-14T23:58:46.3133333+00:00
Vijay Kumar
2,036
Reputation points
1 answer
IMPOSSIBLE TO OPEN AN AZURE BILLING SUPPORT TICKET!
I created a free serverless SQL database limited with 100,000 vCore seconds (that surprisingly only lasted for the database creation) and had to enable charging for it. Days later upon checking the billing forecast, I saw that it would triple my average…
asked 2025-03-12T12:47:40.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(76.8, 74%, 17%)' 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)
Geter Moura
0
Reputation points
commented 2025-03-14T21:05:35.2966667+00:00
Oury Ba-MSFT
20,446
Reputation points Microsoft Employee
4 answers
Azure SQL - can't drop system versioned tables
Hello. I'm can't drop system versioned tables in master db in Azure SQL I have a docs - https://learn.microsoft.com/en-us/sql/relational-databases/tables/stopping-system-versioning-on-a-system-versioned-temporal-table?view=azuresqldb-current but…
asked 2025-02-26T09:06:45.93+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, 26%, 15%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EVB%3C/text%3E%3C/svg%3E)
Vitalii Bohachov
0
Reputation points
commented 2025-03-14T18:14:01.3366667+00:00
Oury Ba-MSFT
20,446
Reputation points Microsoft Employee
2 answers
I'm experiencing problems with EF and SQL Server when running on Azure Webservice. The same code runs fine from VS with same db.
If I turn debugging on and connect my VS to the process, the error doesn't occur. Also I can run the code just fine from Visual Studio towards the same database. I do not Lazy Load. All Queries ens with ToFirstAsync() or ToListAsync() and has a Select to…
Entity Framework Core
Entity Framework Core
A lightweight, extensible, open-source, and cross-platform version of the Entity Framework data access technology.
779 questions
Azure SQL Database
Azure SQL Database
An Azure relational database service.
6,087 questions
Azure App Service
Azure App Service
Azure App Service is a service used to create and deploy scalable, mission-critical web apps.
8,461 questions
Azure Startups
Azure Startups
Azure: A cloud computing platform and infrastructure for building, deploying and managing applications and services through a worldwide network of Microsoft-managed datacenters.Startups: Companies that are in their initial stages of business and typically developing a business model and seeking financing.
630 questions
asked 2025-02-15T10:00:46.1533333+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, 73%, 12%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ETE%3C/text%3E%3C/svg%3E)
Tomas Ekenman
0
Reputation points
answered 2025-03-14T18:00:23.37+00:00
Tomas Ekenman
0
Reputation points
0 answers
SQL Managed Instance November 2022 Feature Wave - Azure Government
Does anyone have any idea when the November 2022 Feature Wave for SQL Managed Instance is going to come to Azure Government. Every time I ask support I get the typical "We do not have a date at this time". It is so old and rolled out its in the…
asked 2025-03-13T12:35:32.0033333+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(118.4, 11%, 21%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJA%3C/text%3E%3C/svg%3E)
Joe Alonge
0
Reputation points
commented 2025-03-14T15:00:19.8166667+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(300.8, 25%, 39%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EDP%3C/text%3E%3C/svg%3E)
david perez
0
Reputation points
2 answers
Azure sql database check current active running session and query
I would like to have a query to check in Azure sql database, where I can see the current running active query from which spid , user ,host,ip program . Any one has the idea ?
asked 2021-04-09T10:18:23.723+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(137.6, 40%, 23%)' 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)
sakuraime
2,336
Reputation points
commented 2025-03-14T03:46:09.5633333+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, 16%, 29%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJS%3C/text%3E%3C/svg%3E)
Jaideep Singh
0
Reputation points
1 answer
One of the answers was accepted by the question author.
SQL Azure Firewall setting
Hi, We received a brute force attack notification for our SQL Azure server. Upon investigation, we noticed that the attacker was using .Net SqlClient and returning error 18456. If I check error 18456, it refers to failed authentication... but strange…
![](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(124.80000000000001, 28.999999999999996%, 22%)' 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)
0 answers
our web based application on SQL database will notopen
I need to connect with someone to help me troubleshoot my our web based application hosted on Azure is notworking
asked 2025-03-13T14:17:01.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(262.40000000000003, 82%, 35%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3E8%3C/text%3E%3C/svg%3E)
82959036
0
Reputation points
edited the question 2025-03-13T22:53:39.2733333+00:00
Erland Sommarskog
119.5K
Reputation points MVP
1 answer
One of the answers was accepted by the question author.
Wanted to replicate Azure SQL hosted in UK West to US North central does it need any networking
i have a requirement to sync Azure sql managed db instance data between 2 Regions US and UK replication type Transactional, both the 2 database instances are PEP Enabled with its own VNET. The data replication does it need any network setup between 2…
asked 2025-03-11T19:28:37.51+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, 8%, 34%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ENC%3C/text%3E%3C/svg%3E)
Narendra Chimakurthi
20
Reputation points
accepted 2025-03-13T21:38:30.9933333+00:00
Narendra Chimakurthi
20
Reputation points
1 answer
Request for Waiver of Unintended Azure Charges & Support Ticket Issue
I recently created an Azure subscription to explore its services. I mistakenly provisioned a high-end SQL Server instance, leading to unexpected charges of over $800, even though I was not actively using the service. Additionally, I attempted to create a…
asked 2025-03-10T19:55:34.8566667+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, 92%, 11%)' 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)
shujaat siddiqui
0
Reputation points
commented 2025-03-13T19:55:33.0066667+00:00
TP
109.8K
Reputation points
1 answer
Could not connect azure sql db from ssms
Couldnt connect live SQL db TITLE: Connect to Server Cannot connect to dbowemp.database.windows.net. ADDITIONAL INFORMATION: A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found…
asked 2025-03-11T14:32:19.9666667+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(112.00000000000001, 89%, 20%)' 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)
Sabita Sahoo
0
Reputation points
commented 2025-03-13T16:47:53.8366667+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, 4%, 34%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EPC%3C/text%3E%3C/svg%3E)
Prasad Chaganti
80
Reputation points Microsoft External Staff
0 answers
Power BI, Dataverse, Project Online help
My client uses Power BI to report on a portfolio of projects in Project Online. They would like to be able to view detailed reporting over time within Power BI. They have a ton of Power BI Pro licenses. We would need some place to store the historical…
![](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(137.6, 48%, 23%)' 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)
0 answers
Azure Support expected db relication issue resolution time
Hello, I have a replication issue with Azure Postgres Flexible db. Resource health event has a status that someone is working on this issue. How can I get a time frame for resolving the issue? The issue started on Mar 6 and still ongoing (6 days in a…
asked 2025-03-11T14:12:28.0833333+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(121.6, 88%, 21%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAK%3C/text%3E%3C/svg%3E)
Andrii Kuzminskyi
0
Reputation points
commented 2025-03-13T08:41:34.6133333+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(300.8, 60%, 39%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EP%3C/text%3E%3C/svg%3E)
PratikLad
320
Reputation points Microsoft External Staff
1 answer
while deploying dacpac using dacservice, facing System.IO.IOException: The directory name is invalid
While deploying DacServices, facing below error Note: after restarting machine its working fine. Issue occurred intermediate System.IO.IOException: The directory name is invalid. at System.IO.__Error.WinIOError(Int32 errorCode, String…
asked 2025-03-12T08:53:37.9133333+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(195.2, 42%, 28%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAR%3C/text%3E%3C/svg%3E)
Aleem, Rabiul
0
Reputation points
edited the question 2025-03-13T02:55:59.9833333+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(64, 85%, 16%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJX%3C/text%3E%3C/svg%3E)
Jiale Xue - MSFT
49,126
Reputation points Microsoft External Staff