Wednesday, June 29, 2016

New authentication methods in SQL Server 2016

I recently set up and configured a SQL Server 2016 instance on a virtual machine and when I logged into the system for the first time, I encountered a welcome change to the authentication screen!






As you can see from the above image, SQL Server 2016 has now added support for "Active Directory Password Authentication" as well as "Active Directory Integrated Authentication"!

If you can read this article, you can get some more details on these 2 new types of authentication mechanisms: https://msdn.microsoft.com/en-us/library/ms189721.aspx

If you read through the article, you can see that both of these authentication mechanisms are targeted towards authenticating against Azure Active Directory!

For more information on connecting to SQL Server using Azure Active Directory, you can check out this article: https://azure.microsoft.com/en-us/documentation/articles/sql-database-aad-authentication/

No comments:

Post a Comment