:::: MENU ::::

Posts Categorized / SQL Azure

  • Aug 17 / 2017
  • 0
SQL Azure, SQL Server tools, SQL Server Utilities, SSMS tips and tricks

Authentication methods in SSMS 17.2

In previous post about 17.2 we briefly mentioned about its download flavors. There is much more to explore in it. Login box of new SSMS shows additional options along with conventional Windows Authentication and SQL Server Authentication.

Authentication types in SSMS 17.2

These additional options are

  • Active Directory – Universal with MFA support (Introduced in SSMS 17.2)
  • Active Directory – Password (Introduced in SSMS 17.0)
  • Active Directory – Integrated (Introduced in SSMS 17.0)

All three options have one thing common that they relate to Azure active directory. Azure SQL Database and Azure SQL Data Warehouse support connections from SSMS using Active Directory Universal Authentication.

Active Directory РUniversal with MFA support is multi factor authentication and involves two step verification by adding call, SMS, bio metric device, smart cards with pin, or mobile app notification and can result in pop up box for validation.

Remaining two options Password and integrated are not interactive and do not generate any dialogue box. Can be used in different applications like ADO.NET, JDBC, ODBC etc.

  • Aug 01 / 2011
  • 0
Qualify for a hard copy or eBook of SQL Azure
dbDigger, SQL Azure, SQL Server Community

Qualify for a hard copy or eBook of SQL Azure

Jayaram Krishnaswamy (mysorian) is a renowned consultant, trainer and technical writer. He has wide range of technical interests and achievements. Also he is recognized among SQL Server community for his quality content contribution related to various SQL Server technologies.
I came to know about a raffle for his new book on SQL Azure. It is a good chance to get a hard copy or EBook of SQL Server Azure. Just send an email to mysorian@gmail.com with ‘SQL Azure’ in the subject line of your email.
I have send an EMail from my side to apply for it.

Consult us to explore the Databases. Contact us