5,204 questions with Azure SQL Database tags

Sort by: Updated
1 answer

Issues with EF Update Command and Azure Credentials in ASP.NET Core Application

I am encountering errors while attempting to run an Entity Framework (EF) update command (dotnet ef database update) from my ASP.NET Core application. The application is connected to a database hosted on Azure. After executing the EF update command, I am…

Entity Framework Core
Entity Framework Core
A lightweight, extensible, open-source, and cross-platform version of the Entity Framework data access technology.
700 questions
Azure SQL Database
ASP.NET Core
ASP.NET Core
A set of technologies in the .NET Framework for building web applications and XML web services.
4,228 questions
asked 2024-05-09T18:29:21.49+00:00
Yamen Edel 0 Reputation points
answered 2024-05-10T16:22:42.6+00:00
Yamen Edel 0 Reputation points
1 answer

how to fix task canceled error from Azure Data Factory, Pipeline

Hello The error below has occurred. Let me know what I'm gonna do. Error : 'Type=System.Threading.Tasks.TaskCanceledException,Message=A task was canceled.,Source=mscorlib,' A pipeline trigger was executed in Azure Data Factory. Thank you.

Azure SQL Database
Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
9,696 questions
asked 2023-02-19T23:43:04.6366667+00:00
Arthur Choi 5 Reputation points
edited a comment 2024-05-10T11:36:57.3166667+00:00
Shrayansh Yadav 0 Reputation points
4 answers

CosmosDB Analytical store delete changes in sql sink

Hi I am trying to capture delete changes from Azure cosmosdb analytical store using change data capture in Azure datafactory, Source is Cosmosdb, sink is Azure sql database. In between I am flattening my file using dataflow. My insert, update is…

Azure SQL Database
Azure Synapse Analytics
Azure Synapse Analytics
An Azure analytics service that brings together data integration, enterprise data warehousing, and big data analytics. Previously known as Azure SQL Data Warehouse.
4,446 questions
Azure Cosmos DB
Azure Cosmos DB
An Azure NoSQL database service for app development.
1,468 questions
Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
9,696 questions
asked 2024-04-30T13:52:46.2133333+00:00
Kuldeep Bhati 0 Reputation points
edited a comment 2024-05-10T08:01:14.7766667+00:00
Harishga 4,005 Reputation points Microsoft Vendor
1 answer

Error in Linked Service connected to azure sql db using Azure Key vault

The linked service is not working after performing CICD from dev to qa branch. All the resources are copied along with linked service. However, The linked service could not setup correctly with this error. What does this error indicate and how to…

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.
1,141 questions
Azure SQL Database
Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
9,696 questions
asked 2024-05-09T15:16:14.0666667+00:00
Sudip Bala 20 Reputation points
commented 2024-05-10T06:16:03.64+00:00
Sudip Bala 20 Reputation points
3 answers One of the answers was accepted by the question author.

sqlcmd fails to connect to azure sql server because of mfa, but active directory says mfa is disabled

I have been following this guide: https://learn.microsoft.com/en-us/azure/azure-functions/functions-identity-access-azure-sql-with-managed-identity and have reached the step "Grant SQL database access to the managed identity". I have…

Azure SQL Database
Azure Functions
Azure Functions
An Azure service that provides an event-driven serverless compute platform.
4,352 questions
SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,853 questions
Microsoft Entra
asked 2024-04-27T14:28:52.5466667+00:00
Sondre Dahl 20 Reputation points
edited the question 2024-05-10T05:10:06.0066667+00:00
ZoeHui-MSFT 33,386 Reputation points
2 answers One of the answers was accepted by the question author.

Hi , I have created one Azure SQL database with Basic pricing tier. I am not able to take it offline or pause the database.

when i go to Settings -> Properties, I can see an option Status ->online for that database but I can not change it to Offline/Pause. Please help since this effect my billing.

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.
12,853 questions
asked 2024-04-29T01:26:13.5466667+00:00
Ankit Kumar Gupta 25 Reputation points
edited the question 2024-05-10T05:09:22.7466667+00:00
ZoeHui-MSFT 33,386 Reputation points
2 answers

¿Cómo recupero la información de licencia OLP Microsoft SQL (2019 )?

¿Cómo recupero la información de licencia OLP Microsoft SQL (2019 )? Secuencia del tiempo Se toma la decisión de ordenar licenciamiento de productos usados en la nuestra compañía, Microsoft, Adobe y otros A fines del año 2017 compramos una…

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.
12,853 questions
SQL Server Migration Assistant
SQL Server Migration Assistant
A Microsoft tool designed to automate database migration to SQL Server from Access, DB2, MySQL, Oracle, and SAP ASE.
496 questions
Windows Licensing
Windows Licensing
Windows: A family of Microsoft operating systems that run across personal computers, tablets, laptops, phones, internet of things devices, self-contained mixed reality headsets, large collaboration screens, and other devices.Licensing: Rules, regulations, and restrictions that define how software can be used and distributed.
38 questions
Windows Server Licensing
Windows Server Licensing
Windows Server: A family of Microsoft server operating systems that support enterprise-level management, data storage, applications, and communications.Licensing: Rules, regulations, and restrictions that define how software can be used and distributed.
25 questions
asked 2024-05-09T20:37:57.65+00:00
Andres Ramdohr 0 Reputation points
answered 2024-05-10T01:27:12.7233333+00:00
ZoeHui-MSFT 33,386 Reputation points
1 answer One of the answers was accepted by the question author.

I have been charged without my knowledge for the service that i did not use!

I have been charged without my knowledge for the service that i did not use. my number is #G047412504. it gives me error when i try to get refund. even though it displays that i am eligeable.

Azure SQL Database
Azure Functions
Azure Functions
An Azure service that provides an event-driven serverless compute platform.
4,352 questions
Azure Cost Management
Azure Cost Management
A Microsoft offering that enables tracking of cloud usage and expenditures for Azure and other cloud providers.
2,104 questions
asked 2024-05-09T17:36:27.2166667+00:00
Mehmet Ali KABA 20 Reputation points
accepted 2024-05-09T21:10:29.6566667+00:00
Mehmet Ali KABA 20 Reputation points
1 answer One of the answers was accepted by the question author.

Location 'southindia' is not accepting creation of new Windows Azure SQL Database servers for the subscription

I tried creating an Azure Synapse workspace. After clicking on the final 'review+create' option & it was getting deployed, I received an error (image below). However, I can see a storage account & a synapse storage account created. Only the…

Azure SQL Database
Azure Synapse Analytics
Azure Synapse Analytics
An Azure analytics service that brings together data integration, enterprise data warehousing, and big data analytics. Previously known as Azure SQL Data Warehouse.
4,446 questions
asked 2024-05-09T10:11:51.47+00:00
Jeenia Bhadra 20 Reputation points
commented 2024-05-09T12:20:34.8966667+00:00
Jeenia Bhadra 20 Reputation points
0 answers

User Managed identity with failover group with servers in different regions

while using user managed identity with azure sql , the connection string or token acquired using DefaultAzureCredential is dependent on the clientID of user managed identity. for the scenario when there is a sql failover switch i.e due to outage in one…

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.
12,853 questions
asked 2024-05-07T19:44:02.75+00:00
KAMALPREET KAUR 1 Reputation point Microsoft Employee
commented 2024-05-08T23:11:15.5166667+00:00
KAMALPREET KAUR 1 Reputation point Microsoft Employee
1 answer

Azure Management Instance Business Critical

Hi people, I have two questions about SQL Management Instance Business Critical. 1 - When I activate Zone Redundancy, I can't select which redundancy zone I want one of the nodes to be in? 2 - When I have zone redundancy in a failover with Business…

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.
12,853 questions
asked 2024-05-08T19:12:41.2266667+00:00
Emerson Sousa 0 Reputation points
commented 2024-05-08T22:56:43.52+00:00
Oury Ba-MSFT 16,731 Reputation points Microsoft Employee
0 answers

Query to identify queries executed in a specific Azure SQL DB

Hi All, I am trying to monitor queries running on Azure SQL Databases on a Premium tier Elastic Pool with ReadScale replication enabled. We redirect reporting for our OLTP system against the replicas (using ApplicationIntent = ReadOnly) which means Query…

Azure SQL Database
asked 2024-05-08T12:31:13.2233333+00:00
Matthews, Darren (Capita Retain) 0 Reputation points
commented 2024-05-08T22:13:38.54+00:00
GeethaThatipatri-MSFT 27,887 Reputation points Microsoft Employee
2 answers One of the answers was accepted by the question author.

Copying a Database to another logical server via the Portal

Copying a Database to another logical server does not show the available Elastic Pool in the destination when using the Portal. What is the reason for this?

Azure SQL Database
asked 2024-05-07T16:32:39.4+00:00
Jon Josep 20 Reputation points Microsoft Employee
edited an answer 2024-05-08T20:25:48.38+00:00
Oury Ba-MSFT 16,731 Reputation points Microsoft Employee
0 answers

How do I download my app codes, and database, which are in Azure Cloud?

I need to download my app codes, and database, which are in Azure Cloud? Could anyone help me, indicating where are the tools for this? Thanks!

Azure SQL Database
Azure App Service
Azure App Service
Azure App Service is a service used to create and deploy scalable, mission-critical web apps.
6,990 questions
asked 2024-05-08T04:01:26.2366667+00:00
Ramon Carrocino 0 Reputation points
commented 2024-05-08T20:14:55.36+00:00
Grmacjon-MSFT 16,446 Reputation points
3 answers

How to create and migrate the tables from one azure database to another azure database

Use-Case- I have 130 tables in the Azure sql database, I need to create and migrate the 130 tables to another azure sql database. Can I use the Azure data factory auto-create functionality to migrate those 130 tables. How the primary keys and indexes of…

Azure SQL Database
Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
9,696 questions
asked 2024-05-08T08:29:13.6433333+00:00
Rahul 251 Reputation points
answered 2024-05-08T09:10:30.8266667+00:00
ShaktiSingh-MSFT 13,836 Reputation points Microsoft Employee
1 answer

Azure SQL Database geo replication and Failover group cost

Hello Team, How to calculate Azure Azure SQL Database geo replication and Failover group cost, I cant see the option in azure pricing calculator. Regards

Azure SQL Database
Azure Cost Management
Azure Cost Management
A Microsoft offering that enables tracking of cloud usage and expenditures for Azure and other cloud providers.
2,104 questions
asked 2024-05-06T08:20:54.0666667+00:00
Ankush Gurjar 160 Reputation points
commented 2024-05-08T07:42:54.47+00:00
ShaktiSingh-MSFT 13,836 Reputation points Microsoft Employee
1 answer One of the answers was accepted by the question author.

Impact on Azure SQL Database due to End of TLS1.0/1.1 Support

I am currently using Azure SQL Database without specifying a minimal TLS version, but will I be affected by the TLS 1.0/1.1 discontinuation on 10/31/2024 and will I be unable to connect with less than TLS 1.2? Will the minimal version of TLS, which is…

Azure SQL Database
asked 2024-05-06T03:29:01.35+00:00
bamboo 21 Reputation points
accepted 2024-05-08T01:39:05.22+00:00
bamboo 21 Reputation points
0 answers

Deploying Azure SQL API Connection for Logic App using ARM

I have successfully created an Azure SQL Connection and registered it in the Logic App. However, I would like to authorize the connection manually, similar to creating a connection to one of the O365 services. When I create the Azure SQL Connection and…

Azure SQL Database
Azure Logic Apps
Azure Logic Apps
An Azure service that automates the access and use of data across clouds without writing code.
2,888 questions
Microsoft Entra ID
Microsoft Entra ID
A Microsoft Entra identity service that provides identity management and access control capabilities. Replaces Azure Active Directory.
19,774 questions
asked 2024-05-07T17:06:06.31+00:00
Morne Weyers 0 Reputation points
commented 2024-05-07T19:01:52.8033333+00:00
akinbade abiola 1,105 Reputation points
1 answer One of the answers was accepted by the question author.

Excessive waiting is happening on the following dominant wait type: CXCONSUMER

We have found from the logs of SQL managed database that DB is taking more time. Also, after investigation, we found that " Excessive waiting is happening on the following dominant wait type: CXCONSUMER " message in the logs of the managed…

Azure SQL Database
Azure App Service
Azure App Service
Azure App Service is a service used to create and deploy scalable, mission-critical web apps.
6,990 questions
Azure Startups
Azure Startups
Azure: A cloud computing platform and infrastructure for building, deploying and managing applications and services through a worldwide network of Microsoft-managed datacenters.Startups: Companies that are in their initial stages of business and typically developing a business model and seeking financing.
28 questions
asked 2023-09-25T10:26:31.7966667+00:00
Mayank Jain 260 Reputation points
edited the question 2024-05-07T15:57:49.3966667+00:00
bharathn-msft 5,086 Reputation points Microsoft Employee
1 answer

As we observe from application insight logs from app services it show database is taking long time to respond to request

We are using SQL managed instance in azure and in single manage instance we have many different database to it. As we observe from application insight logs from app services it show database is taking long time to respond to request as shown in the…

Azure SQL Database
Azure App Service
Azure App Service
Azure App Service is a service used to create and deploy scalable, mission-critical web apps.
6,990 questions
Azure Startups
Azure Startups
Azure: A cloud computing platform and infrastructure for building, deploying and managing applications and services through a worldwide network of Microsoft-managed datacenters.Startups: Companies that are in their initial stages of business and typically developing a business model and seeking financing.
28 questions
asked 2023-10-31T10:28:44.38+00:00
Mayank Jain 260 Reputation points
edited the question 2024-05-07T15:56:16.29+00:00
bharathn-msft 5,086 Reputation points Microsoft Employee