SSMS and MFA support for Azure SQL DB

Quite a mouth full for a title but never the less very exciting. With the new version of SQL Server Management Studio (SSMS) 17.2 You now have the option to use Azure AD authentication for Universal Authentication with Multi-factor authentication (MFA) enabled, by that I mean use a login via SSMS that is enabled for MFA where below I will show you the two step verification using a push notification to my iPhone. (Yes iPhone I love it)

Download SSMS 17.2 from this link. https://docs.microsoft.com/en-us/sql/ssms/download-sql-server-management-studio-ssms

Once installed you will see new Authentication options, the option that I want is the one highlighted below – “Active Directory – Universal with MFA support”

ssmsAD

Enter the user name enabled for MFA.

ssmsAD1

Click connect and SSMS will take you to your organisation login page asking for your password then the 2 step authentication will happen, where for this example a push notification to my iPhone.

LetsVerf

Check your mobile device and click that approve button, if you have an iPhone with 3D touch support then this message supports that!

Soon as you click approve SSMS will authenticate you.

ImIn

If you deny then expect the below.

DENY

Pretty cool right?

 

One thought on “SSMS and MFA support for Azure SQL DB

  1. Pingback: Azure SQL Database Multi-Factor Authentication – Curated SQL

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s