Azure SQL Database
An Azure relational database service.
5,618 questions
0 answers
how to fix connect timeout while copiying from mysql to azure sql using AZURE DATA FACTORY
I have this error while deploying the task of copiying 5 tables from mysql to azure sql on datafactory Operation on target ForEach_qx9 failed: Activity failed because an inner activity failed; Inner activity name: Copy_qx9, Error:…
asked 2024-08-20T10:06: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(96, 34%, 19%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAB%3C/text%3E%3C/svg%3E)
Arturo Beltran
0
Reputation points
commented 2024-08-28T15:29:08.7+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
1,760
Reputation points Microsoft Vendor
8 answers
Retirement notice: Azure SQL Database 2014-04-01 APIs will be retired on 31 October 2025
We’re constantly making updates to Azure SQL Database APIs to ensure optimal security and performance. As part of these updates, we’ll retire Azure SQL Database API version 2014-04-01 on 31 October 2025. See our documentation for a detailed list of all…
asked 2022-11-02T22:58:09.407+00:00
GeethaThatipatri-MSFT
29,377
Reputation points Microsoft Employee
commented 2024-08-28T14:46:16.0733333+00:00
GeethaThatipatri-MSFT
29,377
Reputation points Microsoft Employee
2 answers
One of the answers was accepted by the question author.
Azure SQL Database 2014-04-01 APIs will be retired on 31 October 2025
I have received the email suggesting that we use these APIs. We have an Azure SQL database that we access using .NET 4.8 linq to entities. The answers provided to two prior questions on this subject are vague at best and seem to not relate to us in the…
asked 2022-11-02T09:00:17.067+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, 28.000000000000004%, 36%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJB%3C/text%3E%3C/svg%3E)
James Birchall
56
Reputation points
commented 2024-08-28T11:08:11.2266667+00:00
James Birchall
56
Reputation points
1 answer
Problem Retire Older Version Azure SQL APIs
Hi everyone I've gotten several emails from Azure that says Action required - Upgrade Azure SQL Database 2014-04-01 APIs to a newer version by 31 October 2025 followed by the sentence '*You’re receiving this email because you use Azure SQL Database…
asked 2024-08-26T15:53:53.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(67.2, 98%, 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)
Art DUNHAM
15
Reputation points
commented 2024-08-28T10:53:36.9866667+00:00
Art DUNHAM
15
Reputation points
2 answers
One of the answers was accepted by the question author.
Azure sql database - How to set default database
We have AD groups as logins, and a few sql logins in our databases. They all have to switch to the app database as when they use VS or SSMS, they default to the master database. alter login xxx with default_database = [YY] Msg 40517, Level 16,…
asked 2021-05-24T22:41:21.037+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, 99%, 18%)' 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)
Nguyen, Hoa
381
Reputation points
commented 2024-08-28T10:00:39.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(201.6, 39%, 29%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ELK%3C/text%3E%3C/svg%3E)
Laqi Klodiana
0
Reputation points
1 answer
One of the answers was accepted by the question author.
Azure SQL Database Created Using 2014-04-01 API - Is this an issue?
I have received the email like everyone else saying "Azure SQL Database 2014-04-01 APIs will be retired on 31 October 2025. As part of this, all version 2014-04-01 APIs will be retired on 31 October 2025. You’ll need to update your resources,…
![](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(105.60000000000001, 45%, 20%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EL%3C/text%3E%3C/svg%3E)
1 answer
Not seeing any SQL Security Audit Event on storage account even after configuring Diagnostic setting
I have setup an Diagnostic setting for an SQL Database to achieve SQL Security Audit Event log into storage account but not able to see any container related to SQL Security Audit Event. Am I missing some configuration or setting? Need help regarding…
asked 2024-08-27T11:28:15.7366667+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, 53%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAT%3C/text%3E%3C/svg%3E)
Ashish Tiwari
0
Reputation points
answered 2024-08-28T07:41:18.7433333+00:00
Nandan Hegde
32,026
Reputation points MVP
1 answer
Action required: Upgrade Azure SQL Database 2014-04-01 APIs to a newer version by 31 October 2025
I got an email from Azure: Azure SQL Database 2014-04-01 APIs will be retired on 31 October 2025 You're receiving this email because you use Azure SQL Database APIs. To improve performance and security, we're updating Azure SQL Database…
asked 2022-12-05T03:51:08.667+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, 0%, 35%)' 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)
Liem Nguyen
1
Reputation point
commented 2024-08-28T06:13:31.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(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
15,131
Reputation points
1 answer
getting error while using SQL Auth for login ssms
I have successfully connect with sql Auth but when i use external table i got an error "External table 'gold.Budget_Master' is not accessible because location does not exist or it is used by another process." but when i login with MFA it…
asked 2024-08-07T12:56:39.8266667+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(121.6, 83%, 21%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EGP%3C/text%3E%3C/svg%3E)
Gaurav Patil
0
Reputation points
commented 2024-08-28T06:07:37.2966667+00:00
AnnuKumari-MSFT
32,821
Reputation points Microsoft Employee
2 answers
How to create login credential similar to the SuperAdmin Credential of SQL server with Least Privilege roles
I want to create login credentials that have some permissions similar to super-admin (master credential) in an Azure SQL Database server. following conditions I need: The credentials have login access to all databases present on the server. When a new…
asked 2024-08-06T13:15:32.2466667+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, 65%, 16%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EDP%3C/text%3E%3C/svg%3E)
Devendra Parmar
20
Reputation points
commented 2024-08-28T05:37:49.35+00:00
MikeyQiaoMSFT-0444
2,790
Reputation points
1 answer
Azure SQL Database: Azure SQL Database 2014-04-01 APIs will be retired on 31 October 2025.
Got a message that Azure SQL Database 2014-04-01 APIs will be retired on 31 October 2025. We use dedicated SQL pools, and I am not finding the steps to do this upgrade, can someone assist. Thanks, Girish
asked 2024-08-26T14:26:51.5233333+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, 17%, 13%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EGT%3C/text%3E%3C/svg%3E)
Girish Tharwani
0
Reputation points
commented 2024-08-28T01:56:47.91+00:00
Alberto Morillo
33,696
Reputation points MVP
2 answers
One of the answers was accepted by the question author.
asked 2023-08-26T13:09:37.6+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(137.6, 68%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EIR%3C/text%3E%3C/svg%3E)
I REGRETTED AND MOVE ON
20
Reputation points
answered 2024-08-27T12:26:25.91+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(89.60000000000001, 22%, 18%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMR%3C/text%3E%3C/svg%3E)
madhu raja
0
Reputation points
1 answer
Azure Managed Instance - Query Slow vs On Prem
I am testing moving our warehousing process from on prem to an Azure Managed Instance. After dropping a large set of stored procedures, the process has a task that will loop through tables, get all columns and recreate a procedure for each table that…
![](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, 69%, 25%)' 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)
1 answer
Entity Framework and "Azure SQL Database 2014-04-01 APIs will be retired on 31 October 2025"
I received the "Azure SQL Database 2014-04-01 APIs will be retired on 31 October 2025" email. We are using Entity Framework 6.4.4 and I am wondering if there is anything on the EF side of things that I need to be concerned about?
asked 2024-08-26T17:46:47.37+00:00
Steve Queen
5
Reputation points
answered 2024-08-27T07:24:55.8+00:00
ShaktiSingh-MSFT
15,131
Reputation points
1 answer
ACI needs MS SQL access which is on an azure VM, how do I achieve this?
Hi, I have deployed a container instance which has a connection string which points to a SQL database which is hosted on an azure virtual machine. The virtual machine has its own public IP address. However, the container instance cannot "see"…
asked 2024-07-03T11:19:30.1433333+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, 7.000000000000001%, 21%)' 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)
Sean Kelly
0
Reputation points
edited a comment 2024-08-27T07:02:01.4666667+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(99.2, 65%, 19%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ECB%3C/text%3E%3C/svg%3E)
Chandra Boorla
1,415
Reputation points Microsoft Vendor
2 answers
Microsoft SQL Data Sync - Cannot enumerate changes at the RelationalSyncProvider for table
Hi, I have a Azure SQL Server Database with just one table with 1.75 million records. I'm trying to sync this table with one onpremise SqlExpress instance. This first Sync worked properly without any error. But the second time I tried the sync I started…
asked 2024-08-26T23:59:55.09+00:00
Ubirajara Mendes
0
Reputation points
answered 2024-08-27T06:03:45.14+00:00
ShaktiSingh-MSFT
15,131
Reputation points
1 answer
How to make exclusiv config changes on a managed instance
We want to make a change to the configuration of a DB which seems to be done best when there are no active users/connections to the DB. In our case we want to set READ_COMMITTED_SNAPSHOT to ON We thought of using SINGLE_USER Mode like described here:…
asked 2024-08-05T09:22:33.1333333+00:00
Thimo König
0
Reputation points
commented 2024-08-27T05:52:57.08+00:00
ShaktiSingh-MSFT
15,131
Reputation points
1 answer
Azure Entra ID Authentication fails on Azure APP Services
On Local applicaitons we are able to validate connection Server=tcp:XXXXX.database.windows.net,1433;Initial Catalog=demo;Encrypt=True;TrustServerCertificate=False;Connection Timeout=30;Authentication=Active Directory Default; Once deployed in azure same…
asked 2024-07-10T18:52:40.6633333+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, 24%, 18%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3E2%3C/text%3E%3C/svg%3E)
21887231
0
Reputation points Microsoft Vendor
commented 2024-08-27T05:46:28.98+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
150
Reputation points Microsoft Vendor
1 answer
One of the answers was accepted by the question author.
Azure SQL Server
Please Could you help me with the following question: In Azure SQL Servers With which script(s) should a login be created using MFA authentication with T-SQL? Then with which script should the users be created within the databases of said SQL engine and…
asked 2024-08-22T18:13:19.2233333+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(16, 16%, 11%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EFG%3C/text%3E%3C/svg%3E)
Fernando Gutierrez
160
Reputation points
commented 2024-08-26T20:01:45.9266667+00:00
Oury Ba-MSFT
18,696
Reputation points Microsoft Employee
2 answers
Azure SQL Database 2014-04-01 APIs will be retired
Hello, I would like to know where to go to see if the Azure SQL Database is using 2014-04-01 APIs. Please let me know if you need any more info.
asked 2022-11-01T08:05:49.113+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, 19%, 16%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESV%3C/text%3E%3C/svg%3E)
Shane Van Niekerk
81
Reputation points
commented 2024-08-26T15:41:06.28+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(25.6, 11%, 12%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJW%3C/text%3E%3C/svg%3E)
James Wall
0
Reputation points