Does Azure Managed Identity support on-prem MS SQL Database?

Question

Update

Azure Functions need to access on-prem MS SQL Databases via Azure Managed Identity.

Does Azure Managed Identity support this?

Answer 1

Update

Managed identities allows Azure resources to authenticate or authorize themselves with other supported Azure resources.

On-Premise MS SQL Server supports two authentication modes, Windows authentication mode and mixed mode.

Azure Managed Identity does not support your case - Azure Function connection to On-Premise MS SQL Server.

https://learn.microsoft.com/en-us/sql/connect/ado-net/sql/authentication-sql-server?view=sql-server-ver15

Update June 2024: In SQL Server 2022 Microsoft introduced support for Microsoft Entra authentication

https://learn.microsoft.com/en-us/sql/relational-databases/security/authentication-access/azure-ad-authentication-sql-server-overview?view=sql-server-ver16