SSMS Azure Active directory -Integrate

sakuraime 2,316 Reputation points
2021-05-26T14:26:40.043+00:00

Are there any demo/ video / tutorial for a end-to-end setup , so that the ssms can use 'Azure Active Directory - Integrated' method to login Azure sql database

Azure SQL Database
0 comments

3 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. SUNOJ KUMAR YELURU 13,936 Reputation points MVP
    2021-05-26T14:49:39.02+00:00

    Hi @sakuraime

    Refer to the below url it is explained.
    https://github.com/MicrosoftDocs/azure-docs/blob/master/articles/azure-sql/database/authentication-mfa-ssms-configure.md

    If the Answer is helpful, please click Accept Answer and up-vote, this can be beneficial to other community members.

    0 comments
  2. Oury Ba-MSFT 16,081 Reputation points Microsoft Employee
    2021-05-26T18:47:20.157+00:00

    Hello @sakuraime , The document shared above by learn2skils explained that. In addition to that If you want to use AAD Integrated, you have to be domain join. Otherwise it won't work. Please let us know if you have further questions. Thanks
    Oury

  3. Nandan Hegde 29,886 Reputation points MVP
    2021-05-27T05:45:59.107+00:00

    Hey,
    In order to use AD integrated auth, ADFS must be enabled in Azure AD.
    So please verify whether ADFS is enabled or not :

    1) login to this URL https://portal.azure.com/#blade/Microsoft_AAD_IAM/DirectoriesADConnectBlade
    and check whether federation is enabled or not

    https://stackoverflow.com/questions/65662072/connection-to-azure-sql-via-active-directory-integrated