how do I find resources that may use Azure SQL Database resources that use version 2014-04-01 APIs

Question

Get an email from Microsoft telling me that all version 2014-04-01 APIs will be retired on 31 October 2025. Further, the email says You’re receiving this email because you use Azure SQL Database APIs. How do I find in my Azure subscription, I am using the APIs in question?

Answer 1

Hi @Guy Russell

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.

Until 31 October 2025, 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 31 October 2025 There is a separate thread created for this question where in queries are addressed together.

Here is the reference link Azure SQL Database REST API 2014-04-01 Retirement Notice https://learn.microsoft.com/en-us/answers/questions/1073330/retirement-notice-azure-sql-database-2014-04-01-ap

Let us know if you have any further questions.

Thank You!

Answer 2

Similar thread :

https://learn.microsoft.com/en-us/answers/questions/2152112/upgrade-azure-sql-database-2014-04-01-apis-to-a-ne

Customers who have registered for Microsoft.SQL will receive these notifications, Even though if the customer did not create the Azure SQL DB they receive it due to the Microsft.SQL is registered for the subscription. it's a general notification to existing SQL Database users to transition the new APIs by October 2025.

Answer 3

Hi @Guy Russell,

Welcome to the Microsoft Q&A Platform! Thank you for asking your question here.

In addition to the response provided by RahulRandive and Nandan Hegde, I would like to add the following information.

To identify if you are using the Azure SQL Database 2014-04-01 APIs in your Azure subscription, you can follow these steps:

Check API Usage in Azure Portal:

• Go to the Azure Portal and navigate to your subscription.
• Under "Resource Providers," 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

Run a Query in Azure Monitor:

You can use Azure Monitor to run a query to check for API usage. Here is an example query:

HttpIncomingRequests
| where TIMESTAMP > ago(1d)
| where targetResourceProvider == 'MICROSOFT.SQL'
| where subscriptionId == 'xxxxxxxxxxxx'
| where apiVersion == "2014-04-01" or apiVersion == "2014-01-01" or apiVersion == "2014-04-01-preview"

Check API Usage in Azure Portal:

You can query API versions being used by your resources with Azure Resource Graph Explorer:

Open the Azure Portal-->Search for and open Resource Graph Explorer-->Run the following query:

Resources
| where apiVersion == "2014-04-01"

This will return all resources using the 2014-04-01 API version.If no results are returned, you're not using it.

Here are the links of some parallel threads that might help you :

https://learn.microsoft.com/en-us/answers/questions/1455624/how-to-identify-usage-of-azure-sql-database-2014-0

https://stackoverflow.com/questions/74292401/how-to-react-to-message-from-microsoft-regarding-updating-apis

I hope, This response will address your query and helped you to overcome on your challenges.

If this answers your query, do click Accept Answer and Yes for was this answer helpful. And, if you have any further query do let us know.