sql-serverazureazure-managed-identity

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

Update

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

Does Azure Managed Identity support this?

Solution

  • 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