Kerberos Configuration Manager for SQL Server

Kerberos Configuration Manager for SQL Server (KerberosConfigMgr) was released on May 15th 2013, and is available for download at the Microsoft Download Center at http://www.microsoft.com/en-us/download/details.aspx?id=39046.

This diagnostic tool can help to troubleshoot Kerberos-related configuration issues with SQL Server, which is very exciting for us because Kerberos authentication plays a critical role in many BI-related authentication and delegation scenarios, such as to enable multi-tier BI solutions to access external data sources securely on behalf of the user. To enable end-to-end delegation all the way from the client through the middle-tier components to the external data sources, a Service Principal Name (SPN) must be registered within Active Directory Domain Services (AD DS) for each SharePoint service account, and then Kerberos Constrained Delegation (KCD) must be configured, which can be quite challenging in enterprise environments with complex AD topologies.