3

I am trying to access local resources (database) from Azure. I want to use permissions set on Azure AD user (the AD groups) to avoid the user from gaining too much access to database data.

So, I have a Azure AD User and a web app connected to local database (on premise) through a azure hybrid connection. When I access the database Azure uses a inbuilt IIS Account instead of the signed in user (the Azure user in synchronized with local domain AD User). Is this possible, and how to accomplish this ?

Martijn Pieters
  • 1,048,767
  • 296
  • 4,058
  • 3,343
Danny D. Nielsen
  • 31
  • 1
  • 3

1 Answers1

1

Passing Azure AD user credentials to on-prem SQL Server instance is not supported yet. Connecting to SQL Server running on an Azure VM is not supported using an Azure.

Active Directory account. Use a domain Active Directory account instead. However, It is you can pass Azure SQL database then it is possible to configure Azure SQL database with Azure AD authentication.

Note here gives more info: https://learn.microsoft.com/en-us/azure/sql-database/sql-database-aad-authentication-configure

Suraj Kumar
  • 5,547
  • 8
  • 20
  • 42
Ashith Raj
  • 11
  • 1