Thursday, October 8, 2015

ADFS support coming to SQL Server 2016!

If you have used any version of SQL Server Analysis Services or Reporting Services in the past, you may already be well aware of the fact that neither of theses services currently support integration with ADFS (Active Directory Federation Services).

However, with the release of SQL Server 2016, ADFS support will finally be coming to SQL Server!

If you track this Connect feedback item (, you will see the comments from Microsoft:

Thanks for your feedback. ADFS support, aka claim authentication, is a frequently requested feature. It'll come some time after SQL Server 2016 ships. 

So Microsoft is offering yet another reason for us to upgrade our existing installations of SQL Server 2012 and SQL Server 2014 to SQL Server 2016!

If you are like me, you will be eagerly anticipating this capability since it will provide true SSO support for integration with several Microsoft products such as SharePoint, Dynamics CRM and Project Server.  If Team Foundation Server 2015 also adds support for ADFS, that will sweeten the deal even further!