Azure SQL Database and AD Authentication

  • Wecks

    Say Hey Kid

    Points: 701

    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?

     

     

  • anthony.green

    SSC Guru

    Points: 112519

    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

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply