Kerberos Configuration Manager for SQL Server is available

This article describes the Microsoft Kerberos Configuration Manager diagnostic tool for SQL Server. This tool is available for download from the Microsoft Download Center: 

Download Download the package now.

About Kerberos Configuration Manager

The Kerberos Configuration Manager for SQL Server is a diagnostic tool that helps troubleshoot Kerberos related connectivity issues with SQL Server, SQL Server Reporting Services (SSRS), and SQL Server Analysis Services (SSAS). It can perform the following functions:
  • Collect information on operating systems and Microsoft SQL Server instances that are installed on a server.
  • Report on all Service Principal Name (SPN) and delegation configurations on the server.
  • Identify potential problems in SPNs and delegations.
  • Fix potential SPN problems.

More Information

This tools helps troubleshoot the following exceptions:
  • 401
    Note: This error message is for http errors, SSRS errors, and some other similar errors.
  • Login failed for user 'NTAUTHORITY\ANONYMOUS'
  • Login failed for user '(null)'
  • Login failed for user ''
  • Cannot generate SSPI Context
For more information about Kerberos Configuration Manager, go to the following related blogs:


Article ID: 2985455 - Last Review: 28 Aug 2014 - Revision: 1