6,207 questions with Azure SQL Database tags

Sort by: Updated
1 answer

Azure password apparently wrong, secondary email for Microsoft verification code no longer active = can't log into Azure account!

Hi all, I have an absolutely infuriating problem with my Microsoft Azure account and I'm desperate for help. Backstory - the Azure account was set up by a previous friend/freelancer who I'm no longer on talking terms with. I have a customer SQL database…

Azure SQL Database
asked 2025-05-03T19:59:11.2133333+00:00
Cem R 0 Reputation points
answered 2025-05-03T21:38:48.0833333+00:00
Chiugo Okpala 1,195 Reputation points MVP
0 answers

Azure password apparently wrong, secondary email for Microsoft verification code no longer active = can't log into Azure account!

Hi all, I have an absolutely infuriating problem with my Microsoft Azure account and I'm desperate for help. Backstory - the Azure account was set up by a previous friend/freelancer who I'm no longer on talking terms with. I have a customer SQL database…

Azure SQL Database
asked 2025-05-03T19:41:22.6133333+00:00
Cem R 0 Reputation points
edited the question 2025-05-03T19:46:29.4566667+00:00
Cem R 0 Reputation points
1 answer

Help! My verified student email doesn't work with my free Azure account - it says "Ineligible" after approval. I can't create a subscription. I need a solution to this problem.

Hi, i used my email to sign up an account for a free azure account but i got an error YOU ARE NOT ELIGIBLE FOR FREE ACCOUNT. i used my student email, which i got an email for vetting and verification and I have confirmed. I am still unable to access…

Azure SQL Database
asked 2025-05-03T14:18:43.91+00:00
Karim Mahrous Ahmed Mohamed 0 Reputation points
answered 2025-05-03T19:23:48.39+00:00
hossein jalilian 10,580 Reputation points
1 answer

SQL Elastic Pool Stuck on Scaling for 22 Hours

For performance testing I've scaled my SQL Elastic Pool from: General Purpose - 18 vCores - 2TB Storage to Business Critical - 128 vCores - 3TB Storage The main database in the pool has between 1TB to 1.5TB of data in, the rest have under 100GB and the…

Azure SQL Database
asked 2025-05-01T08:11:05.06+00:00
Finlay 0 Reputation points
edited an answer 2025-05-03T19:17:53.9066667+00:00
Alberto Morillo 34,656 Reputation points MVP
2 answers One of the answers was accepted by the question author.

Cannot load query details for Azure SQL Query performance insight

Cannot load query details for Azure SQL Query performance insight. There are a bunch of errors in browser development console, see screenshot attached.

Azure SQL Database
asked 2025-05-01T02:15:45.1366667+00:00
Michael Terletskyy 0 Reputation points
accepted 2025-05-03T16:32:18.9533333+00:00
Michael Terletskyy 0 Reputation points
2 answers

Recover deleted sql server on azure.

Need to recover deleted sql server on azure. The server was accidentally deleted and need to recover it.

Azure SQL Database
asked 2025-04-25T14:18:44.71+00:00
Trevor Clendenin 0 Reputation points
answered 2025-05-03T14:01:54.2466667+00:00
RahulRandive 10,401 Reputation points
0 answers

Error: "SSISDB database has been found on the server but it is not recognized as an integration services catalog"

Attempting to create an Integration Services Catalog on a SQL Server 2022 Developer Edition on an Azure Windows VM. I Right-click on "Integration Services Catalogs" in SSMS v20.2 and select "Create Catalog" . Fill in all the right…

Azure SQL Database
asked 2025-05-03T04:38:39.0666667+00:00
Frank Melvin IV 0 Reputation points
0 answers

Azure SQL Server - Query failing

Hi Team, SQL server - SQL Database Configuration Hyperscale - Serverless: Gen5, 6 vCores [Scaled up the cores from 2 to 6 after query failure] Below query is failing execute - SELECT top 100 * FROM [table1] a LEFT JOIN [dbo].[table2] b ON…

Azure SQL Database
asked 2025-05-02T20:56:41.31+00:00
Nalini Bhavaraju 40 Reputation points
commented 2025-05-02T21:28:54.18+00:00
Adithya Prasad K 750 Reputation points Microsoft External Staff
0 answers

Azure SQL Server not properly federating at runtime with Microsoft Entra ID

Hello, I am building a web app for internal users to submit queries to my Azure SQL database from a web app. I created a registered app to grant access to Microsoft Graph User.Read and Azure SQL Database user_impersonation. I verified a successful…

Azure SQL Database
asked 2025-05-01T22:07:49.1233333+00:00
Cody P 0 Reputation points
commented 2025-05-02T17:48:39.05+00:00
Oury Ba-MSFT 20,736 Reputation points Microsoft Employee
1 answer One of the answers was accepted by the question author.

Azure SQL Query Performance Insight Query details are not loaded

Hi ! I am having an issue with loading the query details under query performance insight section. After clicking on any of these. The information is not displayed as it used to. Does anyone have any tips or how to resolve this? Thanks Ryan.

Azure SQL Database
asked 2025-04-29T00:45:09.6633333+00:00
Ryan Lee 60 Reputation points
commented 2025-05-02T17:18:51.95+00:00
Joshua Dela Cruz 0 Reputation points
0 answers

Azure SQL managed instance - SQL login with mixed login modes

We are migrating from SQL server (2022) to an Azure managed instance. Our tenant is @contoso.com We have an Azure Managed instance sqltest We have a singular database MyTestDB We have enabled mixed logins (SQL authentication and Entra ID…

Azure SQL Database
asked 2025-04-28T11:18:31.9533333+00:00
Maarten Clauwaert 31 Reputation points
commented 2025-05-02T16:21:04.28+00:00
PratikLad 960 Reputation points Microsoft External Staff
1 answer

Azure RBAC for SQL Server Access Control

How can Azure Role-Based Access Control (RBAC) be configured for Azure SQL Server to meet the following requirements? Two databases exist under the same SQL server within a resource group. Users should have the ability to view all…

Azure SQL Database
asked 2025-04-29T18:09:13.96+00:00
Nalini Bhavaraju 40 Reputation points
commented 2025-05-02T16:03:15.8833333+00:00
Adithya Prasad K 750 Reputation points Microsoft External Staff
1 answer

how can i set up an azure virtual machine running sql server to allow connection from the internet

I have a windows virtual machine in azure subscription that i installed SQL server on. I need to be able to allow a single IP address from the internet to be able to connect to the sql instance. I have enabled TCP/IP and shared memory, allowed the…

Azure SQL Database
asked 2025-04-25T17:10:46.67+00:00
Angel Garcia 0 Reputation points
commented 2025-05-02T15:49:24.7833333+00:00
Sai Raghunadh M 3,315 Reputation points Microsoft External Staff
0 answers

SQL VM deployment failed

I'm trying to deploy a SQL Server virtual machine and get this error: The resource write operation failed to complete successfully, because it reached terminal provisioning state 'Failed'. In the operation details I find this error: { …

Azure SQL Database
asked 2025-05-01T13:30:01.0766667+00:00
Simon Cannon 0 Reputation points
commented 2025-05-02T12:00:46.63+00:00
Saraswathi Devadula 2,175 Reputation points Microsoft External Staff
2 answers

How to revoke access to a schema for a specific user ?

I did create new schemas and they are all visible when I connect as admin to the Azure SQL database. I use this query to revoke permissions for the user 'userReport': -- Revoke any existing permissions on the tables REVOKE SELECT, INSERT, UPDATE, DELTE…

Azure SQL Database
asked 2025-04-30T11:12:49.1666667+00:00
Thorsten Hock 0 Reputation points
commented 2025-05-02T11:38:15.4133333+00:00
Mallaiah Sangi 650 Reputation points Microsoft External Staff
1 answer

Insufficient Permissions Error with Azure Service Principal on CREATE DATABASE AS COPY OF

An attempt is being made to execute the CREATE DATABASE AS COPY OF statement that references a source database on the same Azure SQL Server and elastic pool. The implementation uses an external login mapping to an Azure app registration The login…

Azure SQL Database
asked 2025-04-24T14:50:01.6966667+00:00
55671899 0 Reputation points
commented 2025-05-02T07:41:39.2566667+00:00
PratikLad 960 Reputation points Microsoft External Staff
1 answer

Our SQL managed instance stopped responding, can't be stopped or deleted

We have a SQL managed instance. It stopped responding to a query. We've tried stopping the SQL MI, but after 18 hours it was still in a "Stopping" state. It couldn't be started or stopped. So we tried deleting the SQL managed instance. Now…

Azure SQL Database
asked 2025-04-29T08:56:27.25+00:00
Chris 0 Reputation points
commented 2025-05-02T04:04:33.3066667+00:00
Prasad Chaganti 415 Reputation points Microsoft External Staff
4 answers

Retirement notice: Azure SQL Database 2014-04-01 APIs will be retired on 31 October 2025

We’re constantly making updates to Azure SQL Database APIs to ensure optimal security and performance. As part of these updates, we’ll retire Azure SQL Database API version 2014-04-01 on 31 October 2025. See our documentation for a detailed list of all…

Azure SQL Database
asked 2022-11-02T22:58:09.407+00:00
GeethaThatipatri-MSFT 29,537 Reputation points Microsoft Employee
commented 2025-05-01T14:17:40.9666667+00:00
Dalton Reeves 136 Reputation points
0 answers

Login failed for user '<token-identified principal>'.

Hi, I am suddenly experiencing issues trying to use the query editor preview where it is throwing up this error. I cannot seem to access anything. Microsoft Entra authentication Login failed for user '<token-identified principal>'. Continue as…

Azure SQL Database
asked 2025-04-30T09:24:12.6366667+00:00
Thomas 0 Reputation points
commented 2025-05-01T07:36:00.8133333+00:00
Saraswathi Devadula 2,175 Reputation points Microsoft External Staff
0 answers

Exporting Azure SQL Database to bacpac failure

Hi Team, I am attempting to export one of our azure SQL database, getting following error. Please let us know what I am missing here and what should be done to export this successfully. The UserName M365DevPortals-DB-Connection-PPE and password were…

Azure SQL Database
asked 2025-04-23T11:07:30.1766667+00:00
Sheenam Yadav 0 Reputation points Microsoft Employee
commented 2025-05-01T03:56:35.4733333+00:00
Mallaiah Sangi 650 Reputation points Microsoft External Staff