Azure SQL Database
An Azure relational database service.
6,107 questions
1 answer
Cannot connect Power BI to Azure
I cannot connect Power BI to the Azure database. I am able to access the DB and query editor in Azure and SSMS, but I cannot establish a connection from Power BI. I submitted a support ticket in the Power BI service but was told that they cannot help?
asked 2025-03-16T06:27:52.6266667+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(105.60000000000001, 41%, 20%)' 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)
Erica Chown
0
Reputation points
commented 2025-03-22T05:16:21.1566667+00:00
VINODH KUMAR
30,346
Reputation points MVP
1 answer
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…
asked 2025-03-13T14:16:18.9533333+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, 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)
SusieMull
0
Reputation points
commented 2025-03-22T05:16:06.2666667+00:00
VINODH KUMAR
30,346
Reputation points MVP
0 answers
Azure SQL Managed Instance - Error log not appearing in the EventHub
We have 2 Azure SQL Managed Instances that we have configured the Diagnostic Settings to write allLogs and Audit information into an Event Hub, using an Event Hub policy name (SendPermissions). However, there are no entries from the SQL Error Log that i…
asked 2025-03-21T17:14:07.8933333+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, 98%, 35%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EGD%3C/text%3E%3C/svg%3E)
Gerads, Dennis(IT)
5
Reputation points
commented 2025-03-21T23:16:05.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(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
95
Reputation points Microsoft External Staff
1 answer
i have multiple databases in one SQL managed instance, i wish to replicate only one the databases instead of all of them
I have multiple databases in my SQL managed instance, when create a failover group all the databases are replicated to failover group, instead i want only selective databases to be replicated.
asked 2025-03-19T16:31:47.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(268.8, 43%, 36%)' 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)
Jayesh Lakhiani
0
Reputation points
commented 2025-03-21T22:14:35.01+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
3,335
Reputation points Microsoft External Staff
0 answers
How to delete sql server which is created earlier ?
Hello, Am trying to delete mssql server from this account, getting error. PFA.
asked 2025-03-21T12:13:29.7666667+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, 92%, 27%)' 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)
STSI Support
0
Reputation points
commented 2025-03-21T21:43:19.3533333+00:00
Erland Sommarskog
119.9K
Reputation points MVP
0 answers
ARM/Bicep Microsoft.Sql/servers/databases Replica CreateMode. Only once?
I have bicep script that creates a SQL database used as a replica for a primary database. The bicep script, used for both creating and updating this database, has createMode set Secondary and the sourceDatabseId set to the primary database. Each the…
asked 2025-03-20T17:29:34.81+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, 47%, 24%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ECS%3C/text%3E%3C/svg%3E)
Christopher Schneider
0
Reputation points
commented 2025-03-21T17:45:36.12+00:00
Prasad Chaganti
95
Reputation points Microsoft External Staff
3 answers
Pls help me to remote connect to Azure windows SQL DB--fails at Uid/Pwd
i would like to run code scripts (R, SQL, YAML) to access my AZURE windows VM SQL DB. Please help--requesting online session to have successful connect code line for R, SQL, and YAML. For R script con <- DBI::dbConnect(odbc::odbc(), …
asked 2025-03-20T15:25:35.1+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(297.6, 10%, 38%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESV%3C/text%3E%3C/svg%3E)
Sheila Varga
0
Reputation points
commented 2025-03-21T17:03:30.41+00:00
Mahesh Kurva
3,335
Reputation points Microsoft External Staff
2 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
edited an answer 2025-03-21T16:42:23.59+00:00
Oury Ba-MSFT
20,536
Reputation points Microsoft Employee
2 answers
One of the answers was accepted by the question author.
How do I kill a scaling job that is stuck?
Azure SQL Database scaling job which should complete in a few minutes has been running for 3 hours and is only at 16%. Need to kill this job and attempt manual scaling.
asked 2025-03-19T10:41:37.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(118.4, 60%, 21%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EID%3C/text%3E%3C/svg%3E)
Irvine, David
20
Reputation points
accepted 2025-03-21T12:49:46.8366667+00:00
Irvine, David
20
Reputation points
1 answer
System.Data.SqlClient.SqlException: Login failed for user '
I have an ASP MVC app on Azure App Service. The app uses Managed Identity to connect Azure SQL database. All is working correctly, but from time to time app stops working and I have an error System.Data.SqlClient.SqlException: Login failed for user '
asked 2025-02-12T15:58:54.23+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, 47%, 38%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERB%3C/text%3E%3C/svg%3E)
Robert Bosko
0
Reputation points
edited a comment 2025-03-21T12:34:01.08+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(192, 28.999999999999996%, 28%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EGK%3C/text%3E%3C/svg%3E)
Gaurav Kumar
80
Reputation points Microsoft External Staff
1 answer
Sql is in pausing state - Sql serverless model
Facing issue with the sql server as it's in pause state. Not able to drop or connect or change tier. Any recommendation on what to do.
asked 2025-03-19T10:05:25.34+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(38.4, 37%, 13%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ETG%3C/text%3E%3C/svg%3E)
Tushar Goel
0
Reputation points
commented 2025-03-21T12:28:09.89+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, 95%, 26%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESD%3C/text%3E%3C/svg%3E)
Saraswathi Devadula
310
Reputation points Microsoft External Staff
1 answer
I failing to set the Microsoft Entra admin for my Azure SQL server "Failed to set the Microsoft Entra admin for serverName: xxxxxx"
Using the Azure Portal, I checked in IAM and my logged in user is "Owner" for the Azure SQL server, but I am still unable to set the Microsoft Entra admin to my user, it keeps failing with the error "Failed to set the Microsoft Entra admin…
![](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, 51%, 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)
0 answers
INSERT INTO Fails in Azure Synapse Analytics with Error Code 1104.
Scenario: I am working on loading data from the EDWLanding table to the EDW table using a stored procedure in Azure Synapse Analytics. The stored procedure uses an INSERT INTO SELECT * statement to load data from EDWLanding table into EDW table. The…
asked 2025-03-18T10:06:03.38+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(281.6, 18%, 37%)' 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)
Akshay Gopal
0
Reputation points
commented 2025-03-21T09:17:17.4933333+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
475
Reputation points Microsoft External Staff
2 answers
Database is stuck on pausing
My Azure SQL database is stuck on pausing. The database is meant to autopause after an hour aof inactivity and then unpause when it detects activity. This has worked fine for years. Today it is stuck on pausing
asked 2025-03-19T09:10:02.86+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, 44%, 18%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EFM%3C/text%3E%3C/svg%3E)
Filipe McManus
0
Reputation points
answered 2025-03-21T08:36:36.88+00:00
Saraswathi Devadula
310
Reputation points Microsoft External Staff
2 answers
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
edited a comment 2025-03-21T04:11:14.33+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
1,720
Reputation points Microsoft External Staff
1 answer
Having intermittent issue with logging into Azure Managed instance using SSMS
Developers are having intermittent issues logging into SQL Managed instance in Azure. They are using SQL Server Management Studio. Diagnostics returned the following: We ran diagnostics between 2025-03-14 13:49 UTC and 2025-03-18 13:50 UTC and were…
asked 2025-03-18T14:01:09.35+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(28.799999999999997, 36%, 12%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EHM%3C/text%3E%3C/svg%3E)
Hajkowski, Michael
0
Reputation points
commented 2025-03-20T22:59:24.7233333+00:00
Prasad Chaganti
95
Reputation points Microsoft External Staff
1 answer
Unable to find content of functions (Sys.FunctionName)
Hi Team, Inside Stored Procedure of my Database, a function of a different Database is called using DBName.Sys.Functionname. Inside this function a no. of other functions are called using Sys.functionname. For few of these functions (inside…
asked 2025-03-18T19:47:10.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(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
40
Reputation points
commented 2025-03-20T20:40:14.22+00:00
Mahesh Kurva
3,335
Reputation points Microsoft External Staff
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-20T20:22:18.9366667+00:00
Oury Ba-MSFT
20,536
Reputation points Microsoft Employee
1 answer
MI Link Feature implemented - How to proceed offloading read-only workloads
Architecture: SQL Server 2019 on an Azure VM with the primary Replica and connected through MI Link Feature to SQL Managed Instance (General Purpose Tier) with the secondary Replica Now I want to point 3rd Party apps to the read-only Replica on the…
asked 2025-03-12T10:23:58.3333333+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, 34%, 11%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EVG%3C/text%3E%3C/svg%3E)
Vanhoefen, Guido
0
Reputation points
commented 2025-03-20T13:41:13.6733333+00:00
Vanhoefen, Guido
0
Reputation points
1 answer
One of the answers was accepted by the question author.
Serverless Database stuck in "Pausing" state
I have one SQL Database on the serverless tier which is stuck in the 'pausing' state and therefore allows no connections at all. The database paused correctly yesterday evening, but this morning will not resume. The change analysis in the Azure Portal…
asked 2025-03-19T09:47:49.0066667+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(316.8, 20%, 40%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EDS%3C/text%3E%3C/svg%3E)
Duncan Sutcliffe
20
Reputation points
accepted 2025-03-20T12:42:18.0733333+00:00
Duncan Sutcliffe
20
Reputation points