What do I have to do to ", upgrade any Azure SQL Database resources that use version 2014-04-01 APIs to a newer stable version"

Question

I handle the databases for a client of ours on Microsoft Azure. We received an email recently titled, "Upgrade Azure SQL Database 2014-04-01 APIs to a newer version by 31 October 2025." Unfortunately I have not the faintest clue what they're talking about. I know SQL Server fairly well, but I do not regularly work with Azure so this email may as well be in a foreign language. It just says I have to "upgrade resources" but gives no further information. There is a link to this site https://learn.microsoft.com/en-us/rest/api/sql/retirement but it's too generic to be useful.

1. What specifically needs to be upgraded?
2. How would I find the resources that need to be upgraded?
3. How do I upgrade said resources?

I do have an admin login for the client that I used in order to set this up, but I cannot use it to login, for the login page insists that it "MAY BE a bad email" and will not let me proceed.

So, I would love to comply with this but the email but have no idea where to even start or what to look for. Is there anyone who has an idea what they're talking about?

Thank you.

Answer 1

Hello David B,

Welcome to the Microsoft Q&A and thank you for posting your questions here.

Regarding the upgrade of any Azure SQL Database resources that use version 2014-04-01 APIs to a newer stable version is a known issue, and according to your questions:

What do I have to do to upgrade any Azure SQL Database resources that use version 2014-04-01 APIs to a newer stable version?

You need to update any applications, tools, scripts, or programs that use the 2014-04-01 API version to a newer stable version before October 31, 2025. Here is a similar solution: https://learn.microsoft.com/en-us/answers/questions/1115653/action-required-upgrade-azure-sql-database-2014-04

What specifically needs to be upgraded?

Any API calls made within the SQL DB blade or via Azure Automation that use the 2014-04-01 API version. Details on the API - https://community.spiceworks.com/t/azure-sql-database-2014-04-01-apis-will-be-retired-on-31-october-2025/947566

How would I find the resources that need to be upgraded?

According to your explanation, you said you handled SQL for customer on Azure, so review your application code or API calls to see which version is specified, you can do this in the Azure Portal, navigate to your subscriptions and check the registered resource providers for "Microsoft.Sql". Similar answer is here - https://learn.microsoft.com/en-us/answers/questions/2039548/action-required-upgrade-azure-sql-database-2014-04

Also, you asked.

How do I upgrade said resources?

To upgrade, you will modify the API version parameter in your API calls to a newer version as stated here -https://community.spiceworks.com/t/azure-sql-database-2014-04-01-apis-will-be-retired-on-31-october-2025/947566 and use the Azure Portal to browse to the server you want to upgrade by selecting BROWSE ALL > SQL servers, and then selecting the desired server. Follow the prompts to upgrade the server as stated here - https://github.com/Huachao/azure-content/blob/master/articles/sql-database/sql-database-v12-upgrade.md

I hope this is helpful! Do not hesitate to let me know if you have any other questions.

Please don't forget to close up the thread here by upvoting and accept it as an answer if it is helpful

Answer 2

Hi David B,

If you are currently using the Azure portal, Azure CLI, or Azure PowerShell to manage Azure SQL Database, you need not to take any action.

The customers who are using the API directly, they need to check if they are specifying the 2014-04-01 version in the URL of the API they are currently calling and need to take action.

Hope this help!

Thank You!