Azure SQL Azure AD authentication


  • Hello,

    Should Azure Active Directory accounts that were created using AD Connect synchronisation from on-premises (via Office 365, in this case) be able to administer Azure SQL if they are assigned an administrator role in Azure SQL?

    The image below

    seems to imply that only the following are supported:

    Azure AD native accounts


    ->Also, the accounts in question will be using MFA

    We have tested this and SSO worked using the built in SQL query tool (preview) in the Azure portal but logging in via SSMS failed

    Thanks in advance

    marți, 15 mai 2018 16:49

Toate mesajele