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

GeethaThatipatri-MSFT 29,597 Reputation points Microsoft Employee Moderator
2022-11-02T22:58:09.407+00:00

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

To avoid potential service disruptions, upgrade any Azure SQL Database resources that use version 2014-04-01 APIs to a newer stable version by 30 June 2026.

If you have a support plan and you need technical help, please create a support request:

  1. For Issue type, select Technical.
  2. For Subscription, select your subscription.
  3. For Service, select My services.
  4. For Service type, select SQL Database.
  5. For Resource, select your resource.
  6. For Summary, type a description of your issue.
  7. For Problem type, select Portal and Client Tools.
  8. For Problem subtype, select Problem Retire Older Version Azure SQL APIs
Azure SQL Database

8 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Christian T 60 Reputation points
    2025-07-03T08:22:14.4+00:00

    How to find the API-Version
    So I just went to the Portal, clicked on SQL databases, then opened all Database in new Tabs. In each Tab showing a DB in the Overview Tab, there should be a Link 'JSON View' on the right side:
    User's image

    You can click it and scroll to the bottom of the JSON, there it states an API-Version. 

        "type": "Microsoft.Sql/servers/databases",
    "apiVersion": "XXXX-XX-XX-preview"

    Was this answer helpful?

    10+ people found this answer helpful.
  2. Rebecca Allen 446 Reputation points
    2022-11-15T19:44:30.85+00:00

    In my request to Microsoft support they said they were sending out these warnings to anyone using Microsoft.SQL in their subscription which is anyone using Azure SQL databases basically. They said that if we are using Azure SQL Database, the APIs will automatically be updated. Also. if we did not write any code or use any third party software that make calls to this REST API for SQL for managing the server, then we do not have anything to upgrade.

    Quote from Microsoft support:
    The retirement of the 2014 API will not affect any Azure PaaS or SaaS products that are kept up to date, as the API will be updated automatically. For any 3rd party or unmonitored items that may use the old 2014 API, they will need to be updated by this time to avoid incompatible calls being made to the target databases.

    More information:
    Azure SQL Database 2014-04-01 APIs will be retired on 31 October 2025 - Microsoft Q&A

    https://nam06.safelinks.protection.outlook.com/?url=https%3A%2F%2Flearn.microsoft.com%2Fen-us%2Fanswers%2Fquestions%2F1072210%2Fazure-sql-database-2014-04-01-apis-will-be-retired-2.html%3Fsort%3Doldest&data=05%7C01%7Ckevinhanson%40microsoft.com%7C0dab81a525a54584f7ae08dac36e8ac5%7C72f988bf86f141af91ab2d7cd011db47%7C1%7C0%7C638037176914377567%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&sdata=5I%2B1zDmd4JaXf3oa6HVriC1DObYFjrKIgqAILaAfLj4%3D&reserved=0

    Was this answer helpful?

    10+ people found this answer helpful.
  3. fhtino 166 Reputation points
    2022-12-03T06:20:40.22+00:00

    Please, could you clarify how can I detect if 2014-04-01 APIs are used on my Azure SQL instances?

    I cannot find any log showing the current use of Azure REST APIs, i.e. calls to https://management.azure.com/... affecting my resources, in this case, Sql databases. Does a log exist? If yes, where is it?

    In the portal, if I open an Azure Sql Server or Azure Sql Database instance, I can see Activity Log. I suppose these are related to call arriving on REST API. But no "version" field is available.

    Thank you

    Was this answer helpful?

    3 people found this answer helpful.
    0 comments
  4. 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.

    Was this answer helpful?

    2 people found this answer helpful.
    0 comments
  5. GeethaThatipatri-MSFT 29,597 Reputation points Microsoft Employee Moderator
    2022-12-26T10:12:38.25+00:00

    @bamboo System.Data.SqlClient" is the data plane client (like ODBC, JDBC, etc.) for SQL Server. However, what we plan to retire is a specific version (2014-04-01) of Azure SQL Database Management Service (control plane) API. They are two different things. so this is not affected by this retirement

    -Geetha

    Was this answer helpful?

    2 people found this answer helpful.
    0 comments

Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.