SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 

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?

 


Filed under: Apps, Azure, Azure SQL DB Tagged: AD Authentication, Azure, Azure SQL DB, iPhone, SQL database, SSMS

All About SQL

I am a Senior DBA with interest in MS technology especially SQL Server and Azure. During 2015 I was mentored by Paul Randal – Data Platform (SQL Server) MVP and during 2016 I completed my SQLskills Immersion training on Internals and Performance Tuning. When I am not working I am in the gym burning calories.

Comments

Leave a comment on the original post [blobeater.blog, opens in a new window]

Loading comments...