Azure SQL Database and AD Authentication

• Wecks

  Right there with Babe

  Points: 776

  More actions

  October 15, 2020 at 7:33 am

  Go to Answer

  #3797509

  Quick Question.

  I have a Database that sits on-prem,  The database feeds a number of excel reports that are authenticated using the on Prem AD.

  I which to put this DB in Azure SQL Database keeping the AD authentication.  I am guessing ADFS is required from the on-prem to Azure AD but my knowledge is very limited.

  Is anyone able to give me any details of how I would make this work?

   

   

• Ant-Green

  SSC Guru

  Points: 113445

  More actions

  October 15, 2020 at 7:40 am

  Answer

  #3797510

  You will need to have a process to sync your on-prem ADFS to AAD with something like "Azure AD Connect Sync", then you would create the AAD account using the FROM EXTERNAL PROVIDER syntax

  CREATE USER [wecks@mycompany.com] FROM EXTERNAL PROVIDER