Azure SQL Database
An Azure relational database service.
6,670 questions
1 answer
Unexpected billing for the Azure SQL Database Service tier Basic
Hi, I have been using the Azure SQL Server Database with the Basic level service tier for many months now. But just for the last month I got the bill of around 200 Euros and the bill was for the SQL Database Single/Elastic Pool General Purpose - SQL…
Azure SQL Database
asked 2025-12-09T21:50:29.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(204.8, 21%, 29%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMU%3C/text%3E%3C/svg%3E)
Muhammad Usman
0
Reputation points
commented 2025-12-17T23:31:30.97+00:00
Muhammad Usman
0
Reputation points
4 answers
One of the answers was accepted by the question author.
How to back up Azure SQL DB into BAK file?
I am trying to create a Bak file format from Azure SQL DB into Azure Storage (like Blob storage) on a daily basis for an external client. Previously, I had an external client to log into that Azure SQL DB to perform query, but it appears that it is too…
Azure SQL Database
Azure SQL Database
An Azure relational database service.
6,670 questions
asked 2025-12-11T23:07:08.4066667+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, 39%, 11%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJD%3C/text%3E%3C/svg%3E)
Justin Doh
880
Reputation points
accepted 2025-12-17T23:13:31.27+00:00
Justin Doh
880
Reputation points
3 answers
Unable to Enable CDC on Azure SQL Database Using Server Admin Login - Error 22902 "Caller is not authorized"
We are unable to enable Change Data Capture (CDC) on our Azure SQL Database despite using the server-level admin login (DBAdmin) and Entra ID service administrator. Steps Performed: Connected to the master database using the SQL server admin login . …
Azure SQL Database
Azure SQL Database
An Azure relational database service.
6,670 questions
asked 2025-12-17T14:14:54.9166667+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(70.4, 42%, 16%)' 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)
RM
0
Reputation points
answered 2025-12-17T22:39:12.25+00:00
Erland Sommarskog
129.1K
Reputation points MVP
Volunteer Moderator
3 answers
Issue with Query Store Showing “Restricted Text” in Azure SQL Managed Instance
I am experiencing an issue with Azure SQL Managed Instance where some of the long-running queries in Query Store are displayed as “Restricted Text” instead of the actual query text. Details: Environment: Azure SQL Managed Instance I have admin access,…
Azure SQL Database
Azure SQL Database
An Azure relational database service.
6,670 questions
asked 2025-12-17T19:00:48.9733333+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(243.2, 45%, 33%)' 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)
Aditya Rangineni
0
Reputation points
answered 2025-12-17T22:34:09.4933333+00:00
Erland Sommarskog
129.1K
Reputation points MVP
Volunteer Moderator
2 answers
Switch Azure SQL Provisioned to Serverless and back to Provisioned
Hi Can we switch Azure SQL from "Provisioned" to "Serverless" and back to "Provisioned" without any data loss / minimal downtime? Wanted to observe how serverless works for a week. Data should never be lost while switching…
Azure SQL Database
Azure SQL Database
An Azure relational database service.
6,670 questions
asked 2025-12-17T20:15:24.1066667+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(272, 69%, 36%)' 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)
RJ
326
Reputation points
answered 2025-12-17T22:22:28.8633333+00:00
Erland Sommarskog
129.1K
Reputation points MVP
Volunteer Moderator
3 answers
One of the answers was accepted by the question author.
Can't find what is preventing auto-pause from working
I have a General Purpose - Serverless database set-up. Auto-pause was initially working, but as of sometime yesterday, it will not pause. I initially found that I had SSMS open and suspected that was the issue. However, it has been closed for hours…
Azure SQL Database
Azure SQL Database
An Azure relational database service.
6,670 questions
asked 2025-12-12T17:34:22.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(112.00000000000001, 49%, 20%)' 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)
P Christel
0
Reputation points
accepted 2025-12-17T21:31:44.7933333+00:00
P Christel
0
Reputation points
4 answers
Cannot establish ODBC 18 Connection via Interactive authentication
I have been unable to create an ODBC interactive connection to an Azure database. The credentials work fine in SSMS and using the SQLCMD. The browser window opens and allows me to authenticate. I have tried using the ODBC manager (32-bit) as well as…
Azure SQL Database
Azure SQL Database
An Azure relational database service.
6,670 questions
asked 2025-12-08T16:01:05.7033333+00:00
P Christel
0
Reputation points
answered 2025-12-17T21:29:01.6333333+00:00
P Christel
0
Reputation points
1 answer
Not getting an option to restore serverless Azure sql database in paired region
I have a Azure SQL database (serverless Gen 5) in US west region. I am trying to restore this database from Geo redundant backups in US west central region but not getting an option to restore.
Azure SQL Database
Azure SQL Database
An Azure relational database service.
6,670 questions
asked 2025-12-16T17:12:25.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(67.2, 67%, 16%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAD%3C/text%3E%3C/svg%3E)
Ankit Dwivedi
0
Reputation points
commented 2025-12-17T18:46:44.0733333+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, 24%, 11%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EPP%3C/text%3E%3C/svg%3E)
Pilladi Padma Sai Manisha
595
Reputation points Microsoft External Staff
Moderator
0 answers
We no longer have access to view our tables in our DB
Hi, So we have a database in our account called "bayer-server-test." After a bit of turnover in our agency, we seem to have misplaced the actual admin credentials to this DB. We do have a user that can connect to the DB, but we can't view our…
Azure SQL Database
Azure SQL Database
An Azure relational database service.
6,670 questions
asked 2025-12-04T14:35:27.9+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, 21%, 39%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ECV%3C/text%3E%3C/svg%3E)
Chris Vuletich
0
Reputation points
commented 2025-12-17T18:41:46.9333333+00:00
Pilladi Padma Sai Manisha
595
Reputation points Microsoft External Staff
Moderator
3 answers
One of the answers was accepted by the question author.
Inconsistency in Null Values While copying data from delta lake to AzSQL
We build a ADF pipeline to copy data from delta lake to Azure SQL db. Below are Sink configuration in ADF copy activity Write Behaviour: Insert Bulk Insert Table lock: No Autocreate Table: None enable staging: Yes when the data loaded to sql table, empty…
Azure SQL Database
Azure SQL Database
An Azure relational database service.
6,670 questions
Azure Databricks
Azure Databricks
An Apache Spark-based analytics platform optimized for Azure.
2,789 questions
Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
11,998 questions
asked 2024-01-20T03:09:35.68+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(144, 12%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERR%3C/text%3E%3C/svg%3E)
Rakesh Reddy
0
Reputation points
recommended 2025-12-17T10:47:54.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(60.8, 22%, 15%)' 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)
JuliaMarvin
17,195
Reputation points
Volunteer Moderator
1 answer
SSIS ETL Jobs fails on the SSIS SQL server with the 504 Gateway Time-out issue
The ETL job runs on the SSIS SQL server. It connects to Azure BLOB and loads data from on-prem tables into Azure Blob and then runs executescript within the same job to call the Azure pipelines. While the Azure pipelines are still running, ETL jobs fails…
Azure SQL Database
Azure SQL Database
An Azure relational database service.
6,670 questions
asked 2025-12-09T19:25:39.3166667+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(204.8, 99%, 29%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ENH%3C/text%3E%3C/svg%3E)
Noveen Haseeb
45
Reputation points
edited the question 2025-12-17T10:12:34.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(179.20000000000002, 96%, 27%)' 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)
Rekha
0
Reputation points Microsoft External Staff
Moderator
3 answers
Not able to login to wordpress -Database Error
I was transferring wordpress website from local to live server azure hosting and due to problems with migration plugin my website has crashed and i cannot login to wordpress.Its showing message"Error in Establishing Database Connection".Because…
Azure SQL Database
Azure SQL Database
An Azure relational database service.
6,670 questions
asked 2022-07-04T20:29:16.863+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, 87%, 40%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAM%3C/text%3E%3C/svg%3E)
Azka Munawar
11
Reputation points
commented 2025-12-17T09:27:53.15+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(243.2, 70%, 33%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ECD%3C/text%3E%3C/svg%3E)
calculo de Salario
0
Reputation points
2 answers
Sync Azure SQL Database across Tenants
Hi A customer wants to access some table that we host for them, we don't want then to have access to our database, so we have proposed looking into Sync Azure SQL Database is this available across Tenants (mine and theirs)? Also i need to cost this for…
Azure SQL Database
Azure SQL Database
An Azure relational database service.
6,670 questions
asked 2025-12-03T16:40:32.4733333+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, 65%, 36%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERC%3C/text%3E%3C/svg%3E)
Richard Clark
0
Reputation points
commented 2025-12-17T04:30:44.3366667+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, 18%, 35%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EVP%3C/text%3E%3C/svg%3E)
VRISHABHANATH PATIL
2,540
Reputation points Microsoft External Staff
Moderator
2 answers
Reconnect Issues in SSMS to Azure SQL DB with Microsoft Entra MFA After Role Reactivation
Connecting to Azure SQL DB with Microsoft Entra MFA from SSMS was successful previously. However, after the role assignment to the Privileged Identity Management Group expired and was re-activated, reconnection from the same SSMS instance fails to invoke…
Azure SQL Database
Azure SQL Database
An Azure relational database service.
6,670 questions
asked 2025-04-17T07:06:14.6233333+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(246.4, 36%, 33%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJH%3C/text%3E%3C/svg%3E)
Jermy Hoffman
0
Reputation points
answered 2025-12-17T01:47:49.3466667+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, 77%, 16%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EBC%3C/text%3E%3C/svg%3E)
Brendan Cole
0
Reputation points
2 answers
SQL export job stuck
I'm trying to export an SQL-database hosted in Azure, but it gets stuck on 1% and does not seem possible to cancel the export and start again? How do I proceed?
Azure SQL Database
Azure SQL Database
An Azure relational database service.
6,670 questions
asked 2025-12-05T10:51:40.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(230.39999999999998, 64%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EH%3C/text%3E%3C/svg%3E)
Henrik
40
Reputation points
edited a comment 2025-12-16T17:50:33.1866667+00:00
Pilladi Padma Sai Manisha
595
Reputation points Microsoft External Staff
Moderator
1 answer
I have deleted a SQL server that needs to be recovered
I have deleted a SQL Server because of redeployment. Before doing the redeployment I have exported the databases to BACPAC files in a storage account, but now it turns out there's no data in these bacpac files.
Azure SQL Database
Azure SQL Database
An Azure relational database service.
6,670 questions
asked 2025-12-12T15:00:16.9333333+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(54.400000000000006, 1%, 15%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EK%3C/text%3E%3C/svg%3E)
Kim
0
Reputation points
commented 2025-12-16T17:37:14.8533333+00:00
Pilladi Padma Sai Manisha
595
Reputation points Microsoft External Staff
Moderator
2 answers
How to fix access to sql server?
My Error: Cannot open server 'test-sqlserver' requested by the login. Client with IP address 'x.xx.xx.xx' is not allowed to access the server. To enable access, use the Azure Management Portal or run sp_set_firewall_rule on the master database to…
Azure SQL Database
Azure SQL Database
An Azure relational database service.
6,670 questions
asked 2025-12-13T21:38:07.2066667+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(169.60000000000002, 3%, 26%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJR%3C/text%3E%3C/svg%3E)
James R
0
Reputation points
recommended 2025-12-15T21:48:06.8666667+00:00
Erland Sommarskog
129.1K
Reputation points MVP
Volunteer Moderator
1 answer
Timeline for Release of NEXT GEN Feature for Managed Service in Azure
What is the timeline for the release of the NEXT GEN feature for managed service in Azure? It has been in testing since March 2024. When will it be out of preview mode for general use?
Azure SQL Database
Azure SQL Database
An Azure relational database service.
6,670 questions
Azure Managed Applications
Azure Managed Applications
An Azure service that enables managed service providers, independent software vendors, and enterprise IT teams to deliver turnkey solutions through the Azure Marketplace or service catalog.
200 questions
SQL Server | Other
14,625 questions
asked 2025-01-07T15:40:00.9233333+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, 8%, 22%)' 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)
Anonymous
commented 2025-12-15T08:42:04.68+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, 33%, 15%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESL%3C/text%3E%3C/svg%3E)
Sten Lomme
0
Reputation points
2 answers
One of the answers was accepted by the question author.
Question about GA for Next-gen GP for Azure SQL Managed Instance
Hi, Public-preview for Next-gen GP for Azure SQL Managed Instance is available since 21 March 2024, especially support for 32TB (https://techcommunity.microsoft.com/t5/azure-sql-blog/introducing-azure-sql-managed-instance-next-gen-gp/ba-p/4092647). Are…
Azure SQL Database
Azure SQL Database
An Azure relational database service.
6,670 questions
asked 2024-10-08T13:19:07.2333333+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(73.60000000000001, 15%, 17%)' 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)
Marcin Kycia
25
Reputation points
answered 2025-12-15T08:41:24.23+00:00
Sten Lomme
0
Reputation points
1 answer
how to fix below question in azure sql data base i am already created table
Req 8: Crate a pipeline to move data from on premises CCardTrans table into Azure SQL DB by creating a new table, when pipeline runs for the first it has to move all the rows from the source table, but if you rerun the same pipeline it should not process…
Azure SQL Database
Azure SQL Database
An Azure relational database service.
6,670 questions
asked 2025-12-13T18:26:16.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(128, 22%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESP%3C/text%3E%3C/svg%3E)
subhashini panidepu
0
Reputation points
answered 2025-12-15T03:10:30.32+00:00
VRISHABHANATH PATIL
2,540
Reputation points Microsoft External Staff
Moderator