Azure app service windows ad authentication to on-premises SQL server ?

MS Techie 2,671 Reputation points
2020-12-14T09:50:23.77+00:00

My on-premises network is connected to Azure network via Express Route , in a hub-and-spoke model.

I have an asp.net application with SQL database on-premises , which i want to move to cloud

From Azure App Service , via Regional Vnet integration enabled, can i communicate with on-premises SQL Server using Windows authentication (AD Authentication) or should i use only SQL authentication ?

Please help.

Azure App Service
Azure App Service
Azure App Service is a service used to create and deploy scalable, mission-critical web apps.
6,689 questions
0 comments No comments
{count} vote

Accepted answer
  1. ajkuma 21,501 Reputation points Microsoft Employee
    2020-12-14T11:45:48.703+00:00

    @MS Techie , Thanks for posting this question.

    Windows/Active Directory authentication is not supported on App Service, because you cannot domain join an App Service worker.

    However, you could use SQL authentication.
    Managed identities in App Service make your app more secure by *eliminating secrets from your app**( connection strings)*.
    In this tutorial, you will add managed identity to the sample web app you built: Tutorial: Secure Azure SQL Database connection from App Service using a managed identity

    • Enable managed identities and grant SQL Database access to the managed identity
    • Configure Entity Framework to use Azure AD authentication with SQL Database
    • Connect to SQL Database from Visual Studio using Azure AD authentication

    Additionally, kindly see this blog for more details.

    Hope this helps!


0 additional answers

Sort by: Most helpful