Azure Function access to SQL Server -IAAS through managed identity

Question

I have an Azure function and a user assigned managed identity. I would like to connect a SQL Server hosted on Azure VM.

But the problem is CREATE USER/CREATE LOGIN [mymangedIdentity] FROM EXTERNAL PROVIDER clause is not supported for Azure AD authentication on SQL Server hosted on Azure VMs. It only works in Azure SQL and Azure MI.

Answer 1

Entra ID (AAD) Auth for SQL Server is a SQL Server 2022 feature.

SQL Server 2022 (16.x) introduces support for authentication with Microsoft Entra ID (formerly Azure Active Directory), on both Windows and Linux on-premises, and SQL Server on Windows Azure VMs.

Microsoft Entra authentication for SQL Server