Azure VM SQL Server Integrated Security from an Azure Web Site

2
votes

I would like to know if it's possible to use Active Directory integrated security within Azure Webapp Standard version to access Azure VM SQL Server.

We have an Azure VM with SQL Server installed and joined into an Azure Directory Domain Services. The VM/SQLServer is being restricted to be accessed only within the VNet, so this VM has no Public IP. The Webapp is connected via VNet Integration to the VNet of the AD DS and VM's.

if someone could explain me if that possible/not possible to implement such a solution and what are the options that I havein AZure to use the integrated security.

Edit: Regarding managed identity in AZure Web App, only certain Azure Resources that can have a Managed Identity assigned, which here the Web App is one of them. And to be able to access a resource using MI that resource needs to support Azure AD Authentication, this is limited to specific resources: Source: Services that support managed identities for Azure resources - Azure Resource Manager - Azure Key Vault - Azure Data Lake - Azure SQL - Azure Event Hubs and Service Bus - Azure Storage The Azure vm SQL Server is not listed as one of the resources that can be accessed through AD managed identity.

1
sql-serverazure-active-directoryazure-web-app-service

1 Answers

0
votes

if someone could explain me if that possible/not possible to implement such a solution and what are the options that I havein AZure to use the integrated security.

Yes, it's possible. You could configure your App Service app to use Azure Active Directory to access Azure VM sql server.

Work Flow:

The VNet Integration feature is built on top of point-to-site VPN technology. Apps in Azure App Service are hosted in a multi-tenant system, which precludes provisioning an app directly in a VNet. The point-to-site technology limits network access to just the virtual machine hosting the app. Apps are restricted to only send traffic out to the internet, through Hybrid Connections or through VNet Integration.

enter image description here

For more details, you could refer to this article.