Using Azure AD user credentials to connect on-prem SQL Server instance in Azure App Service/web site

Mahalakshmi Subramani 21 Reputation points
2022-07-05T21:50:05.37+00:00

Hi,

I have web app on-prem and want to move the web app to azure but don't want to move my on-prem sql database. We have express route setup and able to connect to on-prem sql using sql authentication. But want to setup web app to connect to on-prem database using Azure AD/managed Identity. Could not find much response on that. Any guidance will 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,913 questions
0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Carlos Solís Salazar 16,611 Reputation points
    2022-07-06T11:45:58.907+00:00

    Hi @Mahalakshmi Subramani

    Thank you for asking this question on the **Microsoft Q&A Platform. **

    The best approach is to install an Azure AD Connect https://learn.microsoft.com/en-us/azure/active-directory/hybrid/whatis-azure-ad-connect

    Azure AD Connect is an on-premises Microsoft application that's designed to meet and accomplish your hybrid identity goals.

    You can follow these steps https://learn.microsoft.com/en-us/azure/active-directory/hybrid/how-to-connect-install-express

    Hope this helps,
    Carlos Solís Salazar

    ----------

    Accept Answer and Upvote, if any of the above helped, this thread can help others in the community looking for remediation for similar issues.

    NOTE: To answer you as quickly as possible, please mention me in your reply.