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

Question

EnterpriseArchitect 6,386

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.

Anshul Kumar (MINDTREE LIMITED) 6 Reputation points

2021-10-11T14:05:01.3+00:00

Hi, if the posted answer resolves your question, please mark it as the answer by clicking the check mark. Doing so helps others find answers to their questions.

1 answer

Anshul Kumar (MINDTREE LIMITED) 6 Reputation points

2021-10-11T14:05:01.3+00:00

Hi, if the posted answer resolves your question, please mark it as the answer by clicking the check mark. Doing so helps others find answers to their questions.

Answer 1

Andreas Baumgarten 132.1K MVP Volunteer Moderator

----------

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

Regards
Andreas Baumgarten

EnterpriseArchitect 6,386 Reputation points

2021-07-22T04:33:28.62+00:00

Hi @Andreas Baumgarten So after linking with Azure AD, the user can login using Onpremise AD DS account, and then still get 2FA/MFA ?
EnterpriseArchitect 6,386 Reputation points

2021-07-22T04:33:30.247+00:00

Hi @Andreas Baumgarten So after linking with Azure AD, the user can login using Onpremise AD DS account, and then still get 2FA/MFA ?
Andreas Baumgarten 132.1K Reputation points MVP Volunteer Moderator

2021-07-22T04:47:00.533+00:00

Hi @EnterpriseArchitect ,

if the user account is synced.from on-premises AD in Azure AD -> yes

----------

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

Regards
Andreas Baumgarten
Oury Ba-MSFT 21,156 Reputation points Microsoft Employee Moderator

2021-07-30T17:12:54.587+00:00

Hi @EnterpriseArchitect Is this the same issue as the one you posted here https://learn.microsoft.com/en-us/answers/questions/483896/index.html. If yes, I posted an answer with the steps on how to achieve this.

Regards,
Oury