Azure SQL Database
An Azure relational database service.
5,876 questions
0 answers
Getting error creating database in SQL Elastic Pool, but can do it through the portal
I have a SQL Elastic Pool, MyPool, configured with 200 eDTUs and 800 GB storage It contains a database, DBPrimary, with data space used = 127 GB, max storage = 300 GB I have another database outside of the pool, DBProd, with data space used = 117 GB, Max…
asked 2024-12-26T21:50:02.2966667+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, 99%, 38%)' 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)
Joe DeNicola
0
Reputation points
edited a comment 2024-12-27T02:48:05.5133333+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
1,470
Reputation points Microsoft Vendor
1 answer
Connecting Azure SQL Database through Spark
I am trying to connect to Azure SQL through a Spark session using spark-mssql-connector but the code keeps erroring out with the message: Could not find driver This is the code : var jdbc_df =…
asked 2024-12-26T05:09:09.8+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, 3%, 24%)' 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)
Sachin Nandanwar
25
Reputation points
answered 2024-12-27T02:34:06.14+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
740
Reputation points Microsoft Vendor
1 answer
Database XXX on server XXX is not currently available
Today I woke up and tried to use my Azure Development Database but encountered this issue: "Please retry the connection later. If the problem persists, contact customer support, and provide them the session tracing ID of…
asked 2024-12-26T20:16:32.48+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, 42%, 32%)' 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)
Antonio Gastelum Quevedo
0
Reputation points
answered 2024-12-26T21:20:44.14+00:00
Alberto Morillo
34,166
Reputation points MVP
3 answers
Block ping and telnet Azure SQL database
You can block ping and telnet from public networks to an Azure SQL database, considering that I already have a private link configured?
asked 2024-12-26T18:58:43.73+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(86.4, 54%, 18%)' 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)
Julian Steven Lavayen Gómez
0
Reputation points
answered 2024-12-26T20:25:24.81+00:00
TP
100.9K
Reputation points
0 answers
Querying Azure SQL Extended Event not returning any data
I created an extended event in Azure SQL database to capture query data. The data is being written to Azure blog storage, and there is definitely data in the files: I verified that data exists by downloading one of the files and opening it in SSMS. I…
asked 2024-12-23T18:53:21.0233333+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(9.6, 18%, 10%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESK%3C/text%3E%3C/svg%3E)
Scott Klein
5
Reputation points
commented 2024-12-26T11:38:12.29+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, 69%, 29%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESR%3C/text%3E%3C/svg%3E)
Sai Raghunadh M
1,605
Reputation points Microsoft Vendor
1 answer
Azure data studio table designer error execution time out
An error occurred while generating preview report: One or more errors occurred. (Execution Timeout Expired. The timeout period elapsed prior to completion of the operation or the server is not responding.) at…
asked 2024-12-25T03:46:11.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(272, 38%, 36%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EGB%3C/text%3E%3C/svg%3E)
Ganbaatar Bold
0
Reputation points
commented 2024-12-26T10:18:42.73+00:00
Vijayalaxmi Kattimani
740
Reputation points Microsoft Vendor
1 answer
One of the answers was accepted by the question author.
Azure Web App: TLS support for OLEDB-driver
Hi I have trouble running a website on Azure, using the Microsoft 'Web App'. The website is unable to connect to the SQL Server database running in the same resource group (received error: "The connection's current state is closed"). …
asked 2024-12-21T02:03:32.4833333+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, 40%, 14%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ECE%3C/text%3E%3C/svg%3E)
Claes Eriksson
20
Reputation points
commented 2024-12-26T09:19:28.74+00:00
Vijayalaxmi Kattimani
740
Reputation points Microsoft Vendor
1 answer
Azure SQL and Logic Apps: Are We Paying for a Managed Service or Managing Azure’s Shortcomings?
Details: I’m Sasha Froyland, founder of Help4Access, and I’m reaching out to the Azure community because my team and I have spent the past six months troubleshooting what should be a "managed" service—Azure SQL Database—and Logic Apps. Instead,…
asked 2024-12-23T03:50:03.9266667+00:00
Sasha Froyland
1
Reputation point
commented 2024-12-26T07:52:52.91+00:00
Vijayalaxmi Kattimani
740
Reputation points Microsoft Vendor
1 answer
POST API Call Failing with 405 Error in Azure Static Web Apps
A Blazor WebAssembly app is configured to connect to a SQL database following the guidance in this article: How to host static web apps. The API status is healthy, and GET calls work as expected. However, POST calls to add records to the database return…
asked 2024-12-02T16:13:21.29+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, 21%, 13%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESR%3C/text%3E%3C/svg%3E)
Shreyas Rastogi
225
Reputation points
commented 2024-12-26T05:42:44.04+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(153.6, 92%, 24%)' 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)
ajkuma
27,851
Reputation points Microsoft Employee
1 answer
One of the answers was accepted by the question author.
Fix the azure portal for students
Dear Microsoft Support Team, I hope this mail finds you well. I am writing on behalf of Starex University to address an issue that our students are experiencing while trying to access Azure Portal services. Our institution’s official domain is…
asked 2024-12-25T09:50:55.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(288, 12%, 37%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERT%3C/text%3E%3C/svg%3E)
Ratan Thakur
20
Reputation points
edited the question 2024-12-26T05:09:39.3633333+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(220.8, 4%, 31%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESM%3C/text%3E%3C/svg%3E)
ShaktiSingh-MSFT
16,086
Reputation points
1 answer
One of the answers was accepted by the question author.
Why did my free Azure SQL database disappear?
I spent several days creating a free Azure SQL database, and it used up all the resources for two months to do it. Later in the second month, it disappeared. What's up?
asked 2024-12-24T08:51:35.39+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(201.6, 73%, 29%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ECT%3C/text%3E%3C/svg%3E)
Christopher Tillman
0
Reputation points
commented 2024-12-25T22:20:49.96+00:00
Christopher Tillman
0
Reputation points
0 answers
alert not triggering on azure sql
Hi , we configured alert rule for static ,aggregation type average, greater then , threshold 40% on sql db ealier alerts was worked last few days not working this prod db we are facing lot of issue unless see the metrics then we know the cpu status…
asked 2024-12-18T14:04:00.7733333+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, 85%, 35%)' 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)
Surapally Sravan Kumar
0
Reputation points
commented 2024-12-25T17:43:26.5+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
4,005
Reputation points Microsoft Vendor
1 answer
SQL server with Trace flags 2371 and 7745
Hi Team, We are migrating the SQL server databases to Azure managed instance . The DMA reported that 2371 and 7745 trace flags enabled on SQL instance. i think 2371 and 7745 trace flages auto enabled on Managed instance. Please let me know if changes…
asked 2024-12-20T10:18:09.9266667+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, 92%, 19%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESK%3C/text%3E%3C/svg%3E)
Sanjeev K
20
Reputation points
commented 2024-12-24T16:15:03.2166667+00:00
Mahesh Kurva
1,470
Reputation points Microsoft Vendor
1 answer
One of the answers was accepted by the question author.
Azure SQL Database export operation stuck at cancelling
Azure SQL Database export operation stuck at EXPORT DATABASE Cancelling in progress: 50% Some 4-5 Hours already, deleted the storage account it was going to be exported to and server is set to private network access already
asked 2024-12-23T19:27:54.12+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(86.4, 77%, 18%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EHS%3C/text%3E%3C/svg%3E)
Hugo Souza Almeida
20
Reputation points
accepted 2024-12-24T12:45:48.37+00:00
Hugo Souza Almeida
20
Reputation points
2 answers
Azure SQL Import/Export
We have multiple databases within a single server sizing way above 100GB of data hosted in Azure. Normally we tend to restore the same production copy to our non-prod environments using SSMS .backpac method of export and import, however in bigger data…
asked 2024-12-21T14:24:28.0433333+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(156.8, 78%, 25%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ECP%3C/text%3E%3C/svg%3E)
Chetan Prakash Saraswat
26
Reputation points
commented 2024-12-24T01:40:10.6233333+00:00
Vijayalaxmi Kattimani
740
Reputation points Microsoft Vendor
3 answers
Azure SQL Ongoing operations cancel
I tried to export Azure SQL database and that got stuck for several hours in 1%. After that I cancelled export process with Powershell and now it's stuck for cancel in progress... I have tried to scale database but that didn’t do anything. What…
asked 2022-03-29T18:35:42.133+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(96, 78%, 19%)' 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)
ronis
21
Reputation points
answered 2024-12-23T19:35:42.1433333+00:00
Hugo Souza Almeida
20
Reputation points
2 answers
How to expand my db for more markets ?
Right now SQL server db is running in one region and right now we have enabled solution for one market, in future we need to roll out for more markets and need to run in multiple regions . When we enable more markets we will millions of records . can you…
asked 2024-12-16T15:51:16.31+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(249.60000000000002, 22%, 34%)' 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)
Siva
0
Reputation points
commented 2024-12-23T14:03:29.3633333+00:00
Sai Raghunadh M
1,605
Reputation points Microsoft Vendor
2 answers
One of the answers was accepted by the question author.
Azure SQL to Azure SQL Migration using Full & Differential Backup Feasible?
I have to migrate Azure SQL Database completely from one environment to another Azure SQL Database environment. There is no direct network connection between the two environments. Can Azure SQL Database Server backups (Full & Differential Backup)…
asked 2024-12-20T03:31:29.29+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, 33%, 21%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERS%3C/text%3E%3C/svg%3E)
Rajeskumar S L
20
Reputation points
accepted 2024-12-23T13:53:57.91+00:00
Rajeskumar S L
20
Reputation points
1 answer
Login failed for user '<token-identified principal>'.
Hello, I am encountering the following error when trying to connect via Microsoft Entra Service Principal in SSMS. I -As Username I am using the Application ID. (I tried with dieguitico0007_hotmail.com#EXT#@dieguitico0007hotmail.onmicrosoft.com but it…
asked 2024-12-16T02:36:55.21+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(265.6, 36%, 35%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EDC%3C/text%3E%3C/svg%3E)
Diego Cedeño
0
Reputation points
commented 2024-12-23T02:18:57.0766667+00:00
Vijayalaxmi Kattimani
740
Reputation points Microsoft Vendor
1 answer
I have migrated my SQL database and web app to azure database and web app services successfully while running the domain the login page shows proper but when i am inserting data and clicking on submit it give error : Named Pipes Provider, error: 40
I have migrated my SQL database and web app to azure database and web app services successfully while running the domain the login page shows proper but when i am inserting data and clicking on submit it give Error: A network-related or instance-specific…
asked 2024-12-16T11:24:58.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(28.799999999999997, 94%, 12%)' 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)
Ashraf Khan
20
Reputation points
answered 2024-12-22T22:05:14.0566667+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, 74%, 13%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EDG%3C/text%3E%3C/svg%3E)
Divyesh Govaerdhanan
155
Reputation points