Do I need to update my SQL Server API's to a newer version?

Question

Hello All,

I received an email from MS Azure stipulating that I need to update my Azure SQL Server API's to a newer version. Here is what was stated in the email:

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 APIs. As part of this, all version 2014-04-01 APIs will be retired on 31 October 2025. You'll need to update your resources, including templates, tools, scripts, and programs, to use a newer API version by then. Any API calls still using the older versions after that date will stop working until you've updated them. Required action To avoid potential service disruptions, upgrade any Azure SQL Database resources that use version 2014-04-01 APIs to a newer stable version by 31 October 2025.

However, I don't seem to have any Azure SQL Server resources when checking my resources.

The only SQL usage I can find is SQL Server Express edition installed on a VM I own. Here are the details of the instance:

Microsoft SQL Server 2019 (RTM) - 15.0.2000.5 (X64) Sep 24 2019 13:48:23 Copyright (C) 2019 Microsoft Corporation Express Edition (64-bit) on Windows Server 2022 Datacenter Azure Edition 10.0 <X64> (Build 20348: ) (Hypervisor)

I think there are 3 possible outcomes to this enquiry:

1. I was sent this email in error
2. I have a resource somewhere that uses Azure SQL Server which can't be located within the Azure Portal when searching for Type == Azure SQL Server.
3. The problem is this SQL Server Express edition.

I need help determining what the problem is. I should be okay with updating to the newer APIs once the problem instance is found.

Many thanks for considering my request.

Answer 1

Hi sachin kanadia •

As you mentioned, you have SQL Server Express edition installed on a VM

I believe Customers who have registered for Microsoft.SQL will receive these notifications, even though the customer did not create the Azure SQL DB they receive it due to the Microsft.SQL is registered for the subscription.

It is a general notification to existing SQL Database users to transition the new APIs by October 2025.

Please refer to the document below for additional information regarding this notification Azure SQL Database REST API 2014-04-01 Retirement Notice

Thank you!

Answer 2

Well, there is a problem with your Express instance - but nothing that has any relation to the mail you got. The issue with you SQL Server instance is that you have the original version of SQL 2019, and you should download and install the most recent Cumulative Update to get access to many enhancements and bug fixes.

The mail you got is talking about a REST API that I am not familiar with. But obviously this something you would be using from .NET code or similar. Since it is an API, this may not display in the portal. But if you have some application using this API and logging on to Azure this way, Microsoft may know that you could run into problem when they retire this version of the API. Then again, you might have called this API once in the last three years, and that was enough to qualify to get the mail.

This link was your post, and in the mail you got. I don't know if you looked at it, but if you do, maybe the penny drops: https://learn.microsoft.com/en-us/rest/api/sql/retirement.