Microsoft Q&A

Azure SQL Database

3,280 questions

An Azure relational database service.

Browse all Azure tags

3,280 questions with Azure SQL Database tags

Sort by: Updated
1 answer

How to connect to Azure Database using Managed Identity from Workflow framework?

Hi, I am trying to connect to Azure Managed Database Instance using Managed Identity connection string. My Connection string is in the following format: Data Source=<ServerName>; Authentication= Active Directory Managed Identity; Initial…

Azure SQL Database
Azure App Service Static Web Apps
asked 2023-01-11T09:13:59.21+00:00
Anish Reghunandanan 0 Reputation points
edited a comment 2023-01-28T01:22:29.98+00:00
Ryan Hill 15,991 Reputation points Microsoft Employee
2 answers

Access primary database instance from read replica instance

Since we are starting to use read replica in our projects, we are going to migrate the our data retrieval procedures to read only database. But, we are doing the performance track inside that procedures that we are moving to read only DB and it is…

Azure SQL Database
SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
8,467 questions
asked 2023-01-27T12:04:45.9166667+00:00
Mathankumar Rajendran 0 Reputation points
answered 2023-01-27T23:02:20.5533333+00:00
Erland Sommarskog 67,481 Reputation points Microsoft MVP
0 answers

App Architecture - Any suggestions

Hey Folks, We are developing an app using which: 1. Flow reports for KPIs should be triggered at regular intervals. 2. Users accessing the flow reports should be tracked for analytics. Anyone here has suggestions on what kind of architecture to follow.…

Azure SQL Database
Azure Web Apps
Azure Web Apps
A feature of Azure App Service used to create and deploy scalable, mission-critical web apps.
4,299 questions
Azure Service Fabric
Azure Service Fabric
An Azure service that is used to develop microservices and orchestrate containers on Windows and Linux.
200 questions
Azure Logic Apps
Azure Logic Apps
An Azure service that automates the access and use of data across clouds without writing code.
1,802 questions
Azure Container Apps
Azure Container Apps
An Azure service that provides a general-purpose, serverless container platform.
45 questions
asked 2023-01-27T22:16:23.0033333+00:00
Monisha Barooah 21 Reputation points Microsoft Employee
0 answers

Upsert to Azure SQL Database Failed because Interim Table Exists

I have created a Copy Activity on Azure Data Factory that moves the data from a CSV file hosted on Data Lake to Azure SQL Database. When I select the write behavior to be INSERT, the pipeline runs fine. But when I changed to UPSERT and provide the proper…

Azure SQL Database
Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
6,257 questions
asked 2023-01-27T22:07:31.5066667+00:00
Su Wang 0 Reputation points
0 answers

I understand that elastic jobs are not supported when using private end points using azure sql db,are elastic database querries supported

gettting the following error when trying to use elastic database query in azure sqldatabase trying to connect to a azure sql database using private end point from another azure sqldatabase getting the error failed (error -2146893022, state 0): A…

Azure SQL Database
asked 2023-01-27T22:03:15.32+00:00
Pamidimukkala, Ramakrishna 0 Reputation points
2 answers

3rd party tools for Azure SQL and Managed Instance

Hi. I want to backup Azure SQL DB (PaaS) and SQL Managed Instance using a 3rd party tool. Is it possible? any recommendation? If not possible, then do Azure Data Factory can assist in copy the data to a REST service? Thank you.

Azure SQL Database
asked 2023-01-27T13:55:46.41+00:00
Vivek Mishra 0 Reputation points
answered 2023-01-27T19:14:54.4333333+00:00
GeethaThatipatri-MSFT 14,941 Reputation points Microsoft Employee
1 answer

How to setup Vnet integration between ASP.NET 4.8 Azure Service V3 app and SQL Managed Instance?

I just created a simple ASP.NET Web Forms app to Azure Service - Premium V3 plan. This app runs fine as long it does not access our database in SQL Managed Instance (MI). When trying to access the database (a simple SQL SELECT statement in the…

Azure Web Apps
Azure Web Apps
A feature of Azure App Service used to create and deploy scalable, mission-critical web apps.
4,299 questions
Azure SQL Database
Azure Virtual Network
Azure Virtual Network
An Azure networking service that is used to provision private networks and optionally to connect to on-premises datacenters.
1,172 questions
ASP.NET Web Forms
ASP.NET Web Forms
A part of the ASP.NET web application framework that can be used to create ASP.NET web applications.
389 questions
ASP.NET
ASP.NET
A set of technologies in the .NET Framework for building web applications and XML web services.
1,173 questions
asked 2023-01-17T16:43:22.7466667+00:00
Jan J. Vopalensky 0 Reputation points
answered 2023-01-27T14:29:08.0133333+00:00
Jan J. Vopalensky 0 Reputation points
8 answers

Elastic Job Schedule

Hi, I have an elastic Job and I would like to schedule it to run Monday to Friday from 8.00 AM to 5.00 PM. Any idea how I can do it, please?

Azure SQL Database
asked 2022-02-23T17:21:14.217+00:00
John Paul Attard 1 Reputation point
edited an answer 2023-01-27T10:39:10.43+00:00
ramesh 0 Reputation points
1 answer

ETL logs in Azure Data Factory

Hello, I am trying to get some ETL logs in adf pipelines. Firstly i need to get the exact duration of dataflow run.You can see below. But when i check the logs,i cannot find the attribute in json logs. I can find duration as coreHour unit which…

Azure SQL Database
Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
6,257 questions
Azure Logic Apps
Azure Logic Apps
An Azure service that automates the access and use of data across clouds without writing code.
1,802 questions
asked 2023-01-25T13:45:51.4+00:00
Mustafa Ispir 21 Reputation points
answered 2023-01-27T08:13:18.86+00:00
Pratik Somaiya 4,026 Reputation points
2 answers

Azure SQL - Spatial Peformance Issues

Hi all, I've recently set up an Azure SQL Database with intentions to build high-performance spatial applications. Server Config: On-Prem -> SQL Server 2022 (Xeon E5-1630 CPU // 64GB 2133mhz DDR4 RAM // Samsung 870 EVO SSD) Azure SQL -> General…

Azure SQL Database
asked 2023-01-23T00:34:40.2433333+00:00
Lachlan Moerenhout 0 Reputation points
commented 2023-01-27T06:23:30.2033333+00:00
ShaktiSingh-MSFT 4,666 Reputation points Microsoft Employee
2 answers

Not able to copy database with name which is deleted.

We have deleted the database (ex "ABC_DB") and it is deleted successfully. now I am trying to copy a database with the same name ("ABC_DB") which we deleted but while coping it shows "A database with the same name already exists…

Azure SQL Database
asked 2023-01-18T05:13:23.32+00:00
manish singh 5 Reputation points
commented 2023-01-27T06:18:02.7333333+00:00
ShaktiSingh-MSFT 4,666 Reputation points Microsoft Employee
1 answer

Import .bacpac to local SQL Server failed with SQL72014 & SQL72045

I'm trying to create a copy from Azure SQL on my local server. I created a .bacpac file on my pc with SSMS, following the site such as [https://medium.com/awesome-azure/copy-azure-sql-database-to-local-server-bff89fd06992 Then I tried to import the…

Azure SQL Database
Azure Backup
Azure Backup
An Azure backup service that provides built-in management at scale.
774 questions
asked 2023-01-16T02:33:57.9466667+00:00
Kazuaki Mizota 0 Reputation points
commented 2023-01-27T06:07:42.5166667+00:00
ShaktiSingh-MSFT 4,666 Reputation points Microsoft Employee
4 answers

How to fix Error when requesting export database from REST API - "error": { "code": "InvalidAuthenticationTokenAudience" "message": "The access token has been obtained for wrong audience or resource" using postman

im getting an 401 error: "error": { "code": "InvalidAuthenticationTokenAudience" "message": "The access token has been obtained for wrong audience or resource" while attempting the request via…

Azure SQL Database
Azure Active Directory
Azure Active Directory
An Azure enterprise identity service that provides single sign-on and multi-factor authentication.
12,562 questions
asked 2023-01-13T20:24:10.0566667+00:00
Brian Cress 0 Reputation points
edited the question 2023-01-27T06:05:46.2233333+00:00
ShaktiSingh-MSFT 4,666 Reputation points Microsoft Employee
2 answers

Issue with connecting to Azure SQL MI from on prem with windows authentication

We are trying to connect to our SQL Managed Instance in Azure from an on Prem VM. We need to have it set up using Windows Authentication for our vendor. We are using AD Cloud sync to sync the vendor account over to AAD. I followed the documentation…

Azure SQL Database
asked 2023-01-12T18:51:15.2366667+00:00
Ryan Pighin 16 Reputation points
commented 2023-01-26T22:16:30.6233333+00:00
Ryan Pighin 16 Reputation points
0 answers

Azure Key Vault Bug in SSMS 19 Preview 4

Having an issue creating a new Column Master Key for Always Encrypted using Azure Key Vault. Getting the following exception. I logged in with my admin privileged account that has full access to the key vault and is an admin on the Azure SQL Server…

Azure SQL Database
Azure Key Vault
Azure Key Vault
An Azure service that is used to manage and protect cryptographic keys and other secrets used by cloud apps and services.
655 questions
asked 2023-01-25T18:59:01.8166667+00:00
Brown, Alex 1 Reputation point
commented 2023-01-26T22:09:29.3033333+00:00
Erland Sommarskog 67,481 Reputation points Microsoft MVP
3 answers

An exception of type System.Data.SqlClient.SqlException was thrown.

Recieved this error when running my sharepoint configuration. An exception of type System.Data.SqlClient.SqlException was thrown. Additional exception information: Cannot open database…

Azure SQL Database
asked 2023-01-03T13:49:18.473+00:00
Tevon2.0 571 Reputation points
edited the question 2023-01-26T19:01:39.7766667+00:00
Oury Ba-MSFT 9,561 Reputation points Microsoft Employee
1 answer

always encryted vs Transparent data encryption

hi friends in what situation best suited for TDE and when we should use always encrypted and what type of azure database it is supported MI or azure SQL database

Azure SQL Database
asked 2023-01-26T16:54:49.25+00:00
Anshal 816 Reputation points
answered 2023-01-26T17:50:56.2733333+00:00
Dimple Rane 636 Reputation points
1 answer One of the answers was accepted by the question author.

SQL settings for Azure AD connect server staging mode

Hi, I have a question regarding the SQL configuration for the second Azure AD connect server. Should it be configured to point to the instance already used by the active server? Thank you in advance for your answer.= and help.

Azure SQL Database
Azure Active Directory
Azure Active Directory
An Azure enterprise identity service that provides single sign-on and multi-factor authentication.
12,562 questions
asked 2023-01-25T22:54:02.61+00:00
Mamadou Coulibali 241 Reputation points
accepted 2023-01-26T15:40:51.0833333+00:00
Mamadou Coulibali 241 Reputation points
2 answers One of the answers was accepted by the question author.

Azure SQL databases ALL go online when connecting to server

Hi all, We have setup approx. 20 Azure SQL databases (serverless with 1 hour on auto-pause). Issue: When we make a connection with SSMS or Azure Data Studio with a server and a specified database, then only the specified database resumes and…

Azure SQL Database
asked 2022-12-08T13:25:36.183+00:00
Mark van Eck 56 Reputation points
accepted 2023-01-26T12:19:42.25+00:00
Mark van Eck 56 Reputation points
1 answer

Azure SQL with TDE - How to secure backups when TDE Protector key has been compromised

I am aware of the basic process that we need to perform when a key has been compromised, which basically involves rotating the key and revoking the compromised one - as per steps detailed in…

Azure SQL Database
asked 2023-01-24T22:10:20.98+00:00
Daniel H 6 Reputation points
edited a comment 2023-01-26T11:54:10.4366667+00:00
Daniel H 6 Reputation points