Azure SQL Database
An Azure relational database service.
5,768 questions
0 answers
ADO.NET connection failure to Azure Database from VS 2022 SSIS Package running against SQL Server 2022 using Microsoft SQLClient Data Provider
I have a SSIS package running on SQL Server 2022 in VS2022 that connects to a 3rd party Azure database as a source with ADO.NET using Microsoft Entra Password that has been running successfully for a few years. However, recently I needed to make…
asked 2024-11-12T13:59:46.06+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, 86%, 19%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ETT%3C/text%3E%3C/svg%3E)
Teresa Thomas
1
Reputation point
commented 2024-11-12T23:13:32.4366667+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
725
Reputation points Microsoft Vendor
1 answer
Restoring a Complete, Up-To-Date Database Across Azure SQL Managed Instances
I want to "move" a database from one SQL Managed Instance to another. My plan is to use the Azure Portal to manually: "Stop" the Web App writing to the database "Restore" the database to the new SQL Managed Instance …
asked 2024-11-11T18:29:03.6833333+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, 33%, 12%)' 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)
sguidos
5
Reputation points
commented 2024-11-12T21:54:50.0733333+00:00
Mahesh Kurva
725
Reputation points Microsoft Vendor
2 answers
Azure SQL Managed Instance authentication with Windows AD users
I am looking to migrate from Azure SQL VMs to Azure SQL Managed Instance and I had a few questions related to integrating this with an on-premises Windows Active Directory domain. We have some applications running on separate Windows VMs. These VMs are…
asked 2024-11-12T18:56:58.6033333+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(224.00000000000003, 62%, 31%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ET%3C/text%3E%3C/svg%3E)
testacc9877
0
Reputation points
edited an answer 2024-11-12T21:49:12.6566667+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, 4%, 33%)' 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)
Sina Salam
12,011
Reputation points
0 answers
Azure SQL Database Reappears After Deletion
While trying to delete an SQL database in my Azure subscription, I noticed that after deleting it twice, the database reappears after some time. Additionally, I was charged about 100 euros after the first deletion. What could be causing this, and how can…
asked 2024-11-10T15:10:48.5566667+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(304, 35%, 39%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ETT%3C/text%3E%3C/svg%3E)
Thanasis Tsolos
0
Reputation points
commented 2024-11-12T18:38:37.6566667+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
3,265
Reputation points Microsoft Vendor
0 answers
SSL Error connecting to Azure SQL
A connection was successfully established with the server, but then an error occurred during the pre-login handshake I am getting this error when testing from SSMS and also from linked servers and SSIS providers. Around the 4th November, this connection…
asked 2024-11-11T18:34:16.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(153.6, 69%, 24%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMF%3C/text%3E%3C/svg%3E)
Mike Fleming
0
Reputation points
commented 2024-11-12T16:53:21.7266667+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
415
Reputation points Microsoft Vendor
1 answer
One of the answers was accepted by the question author.
CXSYNC wait type appearing on Queries that didnt normally have it and TimeOuts occurr
In Azure SQL Managed Instnace: Queries that are complex but run in a timely way normally ... sometimes start getting this wait: CXSYNC_PORT and run until our App timeout threshold of 30sec. This has happened for various databases on the same Managed…
asked 2024-11-08T16:17: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(131.20000000000002, 42%, 22%)' 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)
John Heimiller
5
Reputation points
commented 2024-11-12T16:38:24.97+00:00
John Heimiller
5
Reputation points
2 answers
Issue with Deploying Azure SQL Server Managed Instances: “Your deployment failed”
Hello, I am encountering an issue while trying to deploy Azure SQL Server Managed Instances. The deployment process fails with the message “Your deployment failed.” I have attached a screenshot of the deployment details and included the error message…
asked 2024-11-05T09:15:43.5866667+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(310.4, 41%, 40%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ED%3C/text%3E%3C/svg%3E)
DoFast
26
Reputation points
commented 2024-11-12T16:16:53.0333333+00:00
Mahesh Kurva
725
Reputation points Microsoft Vendor
1 answer
How to capture the Rollback transactions in Azure managed instance , right now we are using general purpose tier
we are trying to update the table data , unfortunately we are getting rollback few rows of data only , example we updated 200 rows at a time , In the 200 rows 120 rows updated successfully left of the rows are rollback after few hours this was…
asked 2024-11-08T11:45:43.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(6.4, 44%, 10%)' 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)
Srinivas Naraipeddi
40
Reputation points
commented 2024-11-12T15:59:09.37+00:00
Vijayalaxmi Kattimani
415
Reputation points Microsoft Vendor
1 answer
Single Server and Flexible server performance
Our application has been hosted in the Azure Environment windows server and Database server. In the month of september, Database has been migrated from single server instance to Flexible server instance. After the migration , we feel the performance of…
asked 2024-11-12T07:57:24.7166667+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(240, 0%, 33%)' 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)
rv385
0
Reputation points
commented 2024-11-12T15:18:36.9933333+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,045
Reputation points Microsoft Vendor
1 answer
Unable to connect to Azure SQL Server from local machine
I have created a SQL Server DB and added required firewall rules. However, I am unable to connect to the DB from my local machine using any SQL Editor. For e.g., DBeaver. Though, I can connect the DB using Azure's in-built "Query Editor". I can…
asked 2024-11-12T12:18:09.66+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, 16%, 17%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESA%3C/text%3E%3C/svg%3E)
Singh, Abhinav (External)
0
Reputation points
commented 2024-11-12T14:57:20.68+00:00
Sina Salam
12,011
Reputation points
0 answers
How to fix "Selected user account does not exist in tenant 'Microsoft Services'" when using Microsoft Entra to access Azure SQL Server?
I'm encountering the following error when trying to access my Azure SQL Server using Microsoft Entra: Selected user account does not exist in tenant 'Microsoft Services' and cannot access the application '04b07795-8ddb-461a-bbee-02f9e1bf7b46' in that…
asked 2024-11-07T16:49:33.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(19.2, 53%, 11%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERM%3C/text%3E%3C/svg%3E)
Ryan M
0
Reputation points
commented 2024-11-12T12:52:04.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(166.4, 27%, 26%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERP%3C/text%3E%3C/svg%3E)
Raja Pothuraju
8,085
Reputation points Microsoft Vendor
0 answers
How to link on-premise SQL Server Management Studio / Azure Data Studio with Azure SQL Managed Instance
Hello all I hope my tag is correct - I couldn't see one for Managed Instance. So, I have created a new Managed Instance, which comes with: Network security Group Route table Virtual cluster Virtual network I'm trying to make this visible to my on-premise…
asked 2024-11-11T12:02:13.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(281.6, 52%, 37%)' 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)
Jonathan Hobdell
20
Reputation points
edited a comment 2024-11-12T11:13:56.8466667+00:00
Jonathan Hobdell
20
Reputation points
1 answer
Can i acknowledge this TLS warning message for Azure Mysql server ?
Can i acknowledge this message? I have require_secure_transport = OFF and tls_version = TLSv1.2 in the server parameters section. Will it cause any issues to the application that is connecting to this mysql server? Thanks
asked 2024-11-12T05:03:26.0933333+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(214.4, 97%, 30%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESJ%3C/text%3E%3C/svg%3E)
Sachin Jayaprakash
0
Reputation points
answered 2024-11-12T08:00:37.3733333+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(217.60000000000002, 24%, 31%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAA%3C/text%3E%3C/svg%3E)
akinbade abiola
18,465
Reputation points
1 answer
after creating login in Azure SQL server, getting error while login to DB using SSMS
Hi, i am trying to connect to Azure sql server using sql authentication. but it is throwing error. i have followed the below steps to create login. Error attached for reference. Thanks CREATE LOGIN [john_doe] WITH PASSWORD = 'MySecurePassword123!'; --…
asked 2024-11-07T08:53:18.8333333+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, 77%, 25%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ELN%3C/text%3E%3C/svg%3E)
Lakshmi Narayana Sarma Bhamidipati
90
Reputation points
commented 2024-11-12T07:49:32.9766667+00:00
Sai Raghunadh M
1,045
Reputation points Microsoft Vendor
1 answer
Unable to Connect to SQL Server Using ActiveDirectoryPassword Authentication
Encountering an issue while trying to connect to SQL Server using ActiveDirectoryPassword authentication. The error message states: "Failed to load MSAL4J Java library for performing ActiveDirectoryPassword authentication." For Info -> I…
asked 2024-11-05T10:49:37.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(188.79999999999998, 80%, 28%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAN%3C/text%3E%3C/svg%3E)
Akash Narvaria
0
Reputation points
commented 2024-11-12T07:21:51.6566667+00:00
Vijayalaxmi Kattimani
415
Reputation points Microsoft Vendor
1 answer
Command 'CREATE LOGIN FROM EXTERNAL PROVIDER' is not supported as Azure Active Directory is not configured for this instance.
We have an SQL Server on an Azure VM. For our main instance, which is our live one, Entra euthentication works without any problem. We can create and login directly using Entra authentication. We also have another instance of SQL on the same server…
asked 2024-10-16T11:17:39.85+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(217.60000000000002, 18%, 31%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERL%3C/text%3E%3C/svg%3E)
Rob Lewis
0
Reputation points
answered 2024-11-11T21:42:51.4133333+00:00
Erland Sommarskog
112.7K
Reputation points MVP
0 answers
Having trouble trying to remove the BATCH_COMPLETED_GROUP audit action item group from the auditing setup
Having trouble trying to remove the BATCH_COMPLETED_GROUP audit action item group from the auditing setup from a Azure SQL server instance
asked 2024-11-05T17:23:07.8533333+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(217.60000000000002, 30%, 31%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESA%3C/text%3E%3C/svg%3E)
Spaulding, Anthony
0
Reputation points
commented 2024-11-11T19:42:38.5733333+00:00
Spaulding, Anthony
0
Reputation points
2 answers
One of the answers was accepted by the question author.
How to copy all tables of a Schema to .csv file format in respective folders
Hi, I am trying to copy all tables of Schema-SALES from SQL Server to .csv file format in ADF and files of each table must copy in respetive folder for example. source (SQL SERVER Tables) SALES.Customer SALES. Address …
asked 2023-12-22T21:18:17.5066667+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, 10%, 12%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EZH%3C/text%3E%3C/svg%3E)
Zaeemul Haque
45
Reputation points
commented 2024-11-11T18:38:08.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(134.4, 84%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EWX%3C/text%3E%3C/svg%3E)
Wenrong Xu
0
Reputation points
2 answers
Issue when trying to use [AzureSqlSyncGroupSchemaModel]::new()
using namespace Microsoft.Azure.Commands.Sql.DataSync.Model $newSchema = [AzureSqlSyncGroupSchemaModel]::new() Running this command on cloud powershell fails with error InvalidOperation: Unable to find type [AzureSqlSyncGroupSchemaModel]. Im trying to…
asked 2024-11-05T15:23:31.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(249.60000000000002, 87%, 34%)' 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)
Aparna Manoharan
20
Reputation points
commented 2024-11-11T18:07:48.5466667+00:00
Vijayalaxmi Kattimani
415
Reputation points Microsoft Vendor
1 answer
Permission Issues with Application Registration for Creating External Users in Azure Synapse Databases
Hello everyone, I’m encountering an issue with an Application Registration in Azure AD that needs to create external users in several on-demand Azure Synapse databases across multiple environments. Despite configuring the necessary permissions in Azure…
asked 2024-11-06T08:14:30.0266667+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(44.800000000000004, 28.000000000000004%, 14%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EN4%3C/text%3E%3C/svg%3E)
NavasMiguel-4566
0
Reputation points
commented 2024-11-11T12:55:13.2466667+00:00
Raja Pothuraju
8,085
Reputation points Microsoft Vendor