Azure App Service to DB on Azure VM using Managed Identity ?

MS Techie 2,671 Reputation points
2021-03-19T15:03:48.187+00:00

If my Azure Web App is connecting to the SQL 2019 database on SQL Azure VM, then can i use Managed identity authentication ? Yes or No

Any articles would be helpful

Azure App Service
Azure App Service
Azure App Service is a service used to create and deploy scalable, mission-critical web apps.
6,688 questions
Microsoft Entra ID
Microsoft Entra ID
A Microsoft Entra identity service that provides identity management and access control capabilities. Replaces Azure Active Directory.
19,091 questions
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. Andriy Bilous 10,736 Reputation points MVP
    2021-03-19T15:14:56.437+00:00

    Hello @MS Techie

    Short answer is no.
    You cannot use managed identity for connection between Azure Web App and SQL 2019 database on SQL Azure VM
    Here is a good illustration of usecases where you can use managed identity
    79703-image.png

    Here is full list of Azure services with support Azure AD authentication, these have been tested with client services that use managed identities for Azure resources.
    https://learn.microsoft.com/en-us/azure/active-directory/managed-identities-azure-resources/services-support-managed-identities#azure-services-that-support-azure-ad-authentication

    You can use any OpenID provider.
    https://learn.microsoft.com/en-us/azure/app-service/overview-authentication-authorization#identity-providers