Enabling and configuring Azure SQL Server and SQL DB instance access using 2FA/MFA ?

EnterpriseArchitect 4,781 Reputation points
2021-07-22T03:27:41.647+00:00

Hi Everyone,

How can I enable the user of my Azure SQL Server and Azure SQL DB instance to use MFA/2FA when connecting with SSMS?

Because at the moment, everyone is connecting using SQL account which is not linked with Azure AD nor OnPremise AD DS account.

Thanks in advance.

SQL Server on Azure Virtual Machines
Azure SQL Database
Microsoft Entra ID
Microsoft Entra ID
A Microsoft Entra identity service that provides identity management and access control capabilities. Replaces Azure Active Directory.
19,582 questions

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Andreas Baumgarten 97,076 Reputation points MVP
    2021-07-22T03:34:51.487+00:00

    Hi @EnterpriseArchitect ,

    you have to link Azure SQL with Azure AD to get this done.
    Maybe these links are helpful:
    https://learn.microsoft.com/en-us/azure/azure-sql/database/authentication-mfa-ssms-overview
    https://learn.microsoft.com/en-us/azure/azure-sql/database/authentication-mfa-ssms-configure

    ----------

    (If the reply was helpful please don't forget to upvote and/or accept as answer, thank you)

    Regards
    Andreas Baumgarten

    1 person found this answer helpful.