Retirement notice: Azure SQL Database 2014-04-01 APIs will be retired on 30 June 2026

GeethaThatipatri-MSFT 29,582 Microsoft Employee Moderator

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 30 June 2026. See our documentation for a detailed list of all impacted APIs, as well as new stable APIs.

Until 30 June 2026, you can continue to use Microsoft.SQL 2014-04-01 APIs, templates, SDKs, and programs without impact.  You can transition to a newer stable version of Microsoft.SQL APIs any time before 30 June 2026

Rebecca Allen 436 Reputation points

2022-11-04T20:02:24.07+00:00

How can we tell what needs to be upgraded? Azure SQL Database? Data Factory? Dashboard? C# .NET website or desktop application?
Rebecca Allen 436 Reputation points

2022-11-04T20:03:19.203+00:00

We are not using any REST APIs to manage the database but we still got this message sent to us?
GeethaThatipatri-MSFT 29,582 Reputation points Microsoft Employee Moderator

2022-11-04T20:14:42.497+00:00

Hi, @Rebecca Allen Microsoft sent an alert email to all the customers who registered for Microsoft.SQL. you can open Azure portal -> Subscriptions -> Resource Providers, and search for "Microsoft.Sql", if this is registered, you will receive the notification. If there is no SQL resource created in the subscription, you can ignore the notification email or unregister the resource provider to avoid confusion.
Rebecca Allen 436 Reputation points

2022-11-04T20:32:25.987+00:00

That provider allows us to have an Azure SQL Database correct? So if we have an Azure SQL Database.. do we need to upgrade something?
Will de Haan 61 Reputation points

2022-11-09T07:57:54.727+00:00

I'm sorry but I just don't see how I can find out which version of this API is used in my Azure resources. Can you explain this?

Thanks,
Will de Haan
Finn Arildsen 81 Reputation points

2022-12-03T11:30:39.147+00:00

I keep getting e-mails reminders about this - "You're receiving this email because you use Azure SQL Database APIs". I am not aware that I'm using any Azure SQL Database APIs. I use table storage, that's it. How do I figure out where and how I'm using those SQL Database APIs?
bamboo 21 Reputation points

2022-12-24T09:50:10.693+00:00

NET framework 4.7 using "System.Data.SqlClient" to connect to Azure SQL Database, am I correct in my understanding that it is not affected by this retirement?
James Wall 30 Reputation points

2024-01-04T14:42:53.8866667+00:00

Exactly. I've got a number of visual studio console applications and websites that use azure sql databases. How do I tell if they are using 2014-04-01 APIs? It seems like microsoft just throws out an announcement without bothering to provide details and lets everyone just have to try to guess.
Parin Patel 10 Reputation points

2024-03-22T11:16:36.5166667+00:00

Goto your azure portal > Select Azure SQL database > Export template (in bottom of menu section)

Copy content and search "apiVersion": "2014-04-01".
galletto 251 Reputation points

2024-08-26T13:55:46.2733333+00:00

@parin patel So I see aipVersion "2014-04-01" in a database template. Then what do I do? The communication in this matter is still unclear.
Pantelis Magos 5 Reputation points

2024-08-27T06:25:08.5966667+00:00

If all I have is an Azure SQL Database and two .NET applications (one web app and one desktop windows framework 4) that send standard SQL queries, do I need to do any upgrades? And how?
galletto 251 Reputation points

2024-08-27T07:29:53.06+00:00

@GeethaThatipatri-MSFT We still get these e-mails and no clue as to what we need to do or where to check. Please set up a communication that doesn't keep us in the dark. It's very annoying
Lee 45 Reputation points

2024-08-27T09:18:41.5766667+00:00

Exactly. What happens if the database you are using was initially created using the apiVersion 2014-04-01? Do you need to do anything to the database? Or is the database itself fine, you just can't use that API again to create another database?
Gerard van de Ven 60 Reputation points

2024-08-28T01:49:37.72+00:00

@GeethaThatipatri-MSFT : This is very confusing. The email specifically says "You’re receiving this email because you use Azure SQL Database APIs.", while I am 99% sure that I am not. You cannot just send out this email to how many 1,000's (or millions) of users. At least you would have to say "you may be using" and then specify for them how they can find out what they are using (if anything) and with some indication of how to fix it. I cannot begin to imagine how many work hours (and with that money) are lost by this particular email alone.
GeethaThatipatri-MSFT 29,582 Reputation points Microsoft Employee Moderator

2024-08-28T14:46:16.0733333+00:00

@Gerard van de Ven Thanks for your feedback, I will let the product team know about it.

Regards

Geetha
KLAIBER, Anthony 20 Reputation points

2024-10-17T09:43:16.6+00:00

Couldn't agree more! How not to communicate with your millions of users. I have wasted so much time trying to work out whether this affects me and then finally find in this thread: "what we plan to retire is a specific version (2014-04-01) of Azure SQL Database Management Service (control plane) API" but still nothing telling me how to know whether it affects me or not.
Scott D Glass 0 Reputation points

2025-01-27T14:06:29.04+00:00

We use bicep to provision database resources and I noticed that some of the dependent resources (e.g. auditingPolicies) are still on this API version. Will they be affected or is it only the 'database' resource type?
AdamTyler-3590 305 Reputation points

2025-01-27T16:21:55.43+00:00

We use Azure SQL with both Azure Data Factory and two Remote Desktop Connection Broker HA instances running on-premises. Does this announcement impact us? How can we confirm? The communication from Microsoft is awful here. I'll likely end up opening a support case and a few weeks down the road get a foggy "you should be okay" type of answer.

Regards,
Adam Tyler
Smithhart, Marty 5 Reputation points

2025-01-27T19:03:00.85+00:00

As someone said above, how do we know if we are using this API version? Where do we begin to explore / research this issue?
Dalton Reeves 146 Reputation points

2025-05-01T14:17:40.9666667+00:00

This communication was absolute trash -- and nobody at MSFT can seem to answer a simple GD question about how we're supposed to tell if our workloads in Azure for SQL are running these soon to be retired API's. I don't get how to this day MSFT still can't make clear communication for their customers, the very customers they would be absolute bankrupt without. Trash trash trash.
Dongwook Kim 0 Reputation points

2025-07-03T12:49:41.2366667+00:00

Hi @GeethaThatipatri-MSFT

I’m using Power Automate to connect to a SQL database for reading and writing data when a record is created or updated. Will this setup be impacted by the upcoming API retirement?

Thanks,

DW
LA METISSE 0 Reputation points

2025-07-04T01:48:31.65+00:00

I found same year but different months

Public_2014-09-01
Priscila Soares 0 Reputation points

2025-10-08T19:46:31.81+00:00

I received an email reporting that "Azure SQL Database 2014-04-01 APIs will be retired on 31 October 2025" today, but in this email there is a link that redirect me to: https://free.blessedness.top/en-gb/answers/questions/1073330/retirement-notice-azure-sql-database-2014-04-01-ap

This link talk that the retirement date is 30 June 2026. Can I consider 30 June 2026 as final date?

8 answers

Jacob Page 5 Reputation points

2025-07-03T15:40:02.0533333+00:00

Am I correct that if you're just connecting to an Azure SQL Server database through a library, like to do queries, that you're not impacted, that this is only referring to the REST APIs for managing SQL Server resources on Azure programmatically? "API" is way too generic of a term. Please be more specific so you don't cause panics!
Please sign in to rate this answer.

1 person found this answer helpful.

0 comments No comments
Sign in to comment

Use comments to ask for clarification, additional information, or improvements to the question.
LucasM 5 Reputation points

2025-07-04T16:32:45.3966667+00:00
For what it's worth here's (one of) Copilot's answers to the question of how to determine which API version(s) you're using:

If Copilot can be trusted we seem to be only using API version 2024-05-01-preview

Hope it helps.

Option 1: Use Azure Resource Graph Explorer (Recommended)

This method helps you identify the API versions associated with your SQL databases:

Go to the Azure Portal.

Search for and open Resource Graph Explorer.

Run the following Kusto query:

kusto

Resources | project name, type, apiVersion, subscriptionId, resourceGroup | where type =~ 'microsoft.sql/servers/databases' | where isnotnull(apiVersion) | order by type asc

Look at the apiVersion column. If you see 2014-04-01, 2014-01-01, or 2014-04-01-preview, those databases are using the deprecated API.
Please sign in to rate this answer.

1 person found this answer helpful.

0 comments No comments
Sign in to comment

Use comments to ask for clarification, additional information, or improvements to the question.
GeethaThatipatri-MSFT 29,582 Reputation points Microsoft Employee Moderator

2022-11-02T22:59:24.563+00:00

[Edited to update link from internal documentation to external]

To minimize service disruption, please upgrade to a newer stable version or discontinue using Azure SQL Database 2014-04-01 APIs.

If you have any additional queries regarding this retirement, please use the comments on this thread to ask your specific queries and we will try our best to answer those queries. Thank You!
Please sign in to rate this answer.
David K 16 Reputation points

2022-11-09T14:34:52.357+00:00

Just like this API upgrade article when can we expect a 'Required Actions' section with the steps needed to upgrade/remediate?

Baresi 21 Reputation points

2022-11-15T04:50:53.123+00:00

I have some VMs in Azure with MS SQL Server. Do we need to do anything?

Wonder all the resources listed under Azure SQL service including SQL virutal mahcine resource type are affected by the change.

Alvaro Arévalo Arévalo 1 Reputation point

2022-12-02T22:11:52.973+00:00

I have an Azure SQL database connected with Microsoft Dynamics Nav 2018 and configured ClickOnce service, I want to know if this change will have any effect on the service. Thanks for your help.

GeethaThatipatri-MSFT 29,582 Reputation points Microsoft Employee Moderator

2022-12-02T22:28:58.347+00:00

@Alvaro Arévalo Arévalo In your connection are you using Azure SQL Database 2014-04-01 APIs? can you can confirm.

Regards
Geetha

Gregory Rose 16 Reputation points

2023-02-12T08:57:16.3066667+00:00

What do I need to check (and where) to see if I'm using "Azure SQL Database 2014-04-01 APIs" ?

I have a CosmoDB database and I interact with it through the UI as well as via a .Net web Web application that I have hosted in Azure.

Dirk Roeleveld 15 Reputation points

2025-07-03T07:38:16.2933333+00:00

I love how the link to 'upgrade' is to a page that doesn't actually tell us how to upgrade it. Still wondering what I must do...
Sign in to comment

Use comments to ask for clarification, additional information, or improvements to the question.

Share via

Retirement notice: Azure SQL Database 2014-04-01 APIs will be retired on 30 June 2026

8 answers

Your answer