Problem Retire Older Version Azure SQL APIs

Question

Hi everyone

I've gotten several emails from Azure that says Action required - Upgrade Azure SQL Database 2014-04-01 APIs to a newer version by 31 October 2025 followed by the sentence '*You’re receiving this email because you use Azure SQL Database APIs.'*   It also says Required Action __[upgrade](https://aka.ms/Retire20140401SqlAPI) any Azure SQL Database resources that use version 2014-04-01 APIs to a newer stable version by 31 October 2025.__  

I've spent a fair bit of time on this and can't figure out how to determine if I have APIs that use the 2014-04-10 version and if so how do I fix it ... as far as I'm aware I'm not using any APIs ... I do use stored procedures in my ASP.NET code to access the database and email does mention scripts but I don't think stored procedures fall under scripts.

I've checked these 2 resources below and still can't figure it out - do I have a problem and if so what do I do about it.  Any help appreciated.  

https://learn.microsoft.com/en-us/answers/questions/1513400/azure-sql-database-2014-04-01-apis-will-be-retired

https://learn.microsoft.com/en-us/answers/questions/1073330/retirement-notice-azure-sql-database-2014-04-01-ap?page=1#answers

Answer 1

You might be able to use Azure Resource Graph Explorer to query for resources interacting with deprecated API versions. Below is a sample Kusto query to filter HTTP incoming requests by API version:

HttpIncomingRequests
| where TIMESTAMP > ago(30d)
| where targetResourceProvider == 'MICROSOFT.SQL'
| where subscriptionId == 'update-this-to-your-subid' //make sure you update this
| where apiVersion == "2014-04-01" or apiVersion == "2014-01-01" or apiVersion == "2014-04-01-preview" 

Note: The HttpIncomingRequests table is typically used for tracking HTTP requests handled by Azure services. You can use this query when you have Azure services like API Management, Azure Functions, or other HTTP-triggered services interacting with your resources. This will allow you to monitor and identify any usage of deprecated API versions.

To use this query:

1. Search for "Resource Graph Explorer" on the Azure portal.
2. Open Resource Graph Explorer and paste the query into the query window.
3. Execute the query to see if any resources are using the deprecated API versions.

If you're only connecting to Azure SQL Database through connection strings in tools like SQL Server Management Studio (SSMS), Azure Data Factory (ADF), ODBC and similar resources, I would say generally safe to assume that you're not directly interacting with deprecated APIs. These tools typically use standard connection protocols (like TDS for SQL Server) rather than specific REST APIs that might have deprecated versions.

Please see this similar post https://learn.microsoft.com/en-us/answers/questions/1455624/how-to-identify-usage-of-azure-sql-database-2014-0. You might also consider reaching out to Microsoft directly for further confirmation.

Just noting that my reposonse was typed out then and then partially reworded by AI (ChatGPT) for better articulation. Before posting I did also read over and validated the information to ensure it was still accurate.