Kerberos Configuration Manager for SQL Server is available

• 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 blog:

SQL Server Release Services: Kerberos Config Tool

To Start the Tool:

1. After the installation is complete successfully, double-click KerberosConfigMgr.exe to start the application.
2. To troubleshoot the connectivity issue with SQL Server, connect to the destination computer by using a domain user account that has user permissions to that computer.
3. To troubleshoot the connectivity issue with SSRS, connect to the destination computer by using a domain user account that has administrative permissions to that computer.

To Generate the SPN List from the Command Line:

1. Go to the command line. (Note: To troubleshoot the connectivity issue with SSRS, start the command line window as administrator.)
2. Switch to the folder where KerberosConfigMgr.exe is.
3. Type KerberosConfigMgr.exe -q -l. 
4. For more command-line option, type KerberosConfigMgr.exe -h. 

To Save a Server's Kerberos Configuration Information:

1. Connect to the target windows server.
2. Click the Save button on the toolbar.
3. Specify the location where you want the file to be saved. It can be on a local drive or a network share.
4. The file will be saved as the .XML format.

To View a Server's Kerberos Configuration Information from the Saved File:

1. Click the Load button on the toolbar.
2. Open the XML file generated by Kerberos Configuration Manager.

To Generate a Script to Fix the SPN from the Command Line:

1. Click the Generate button for the SPN entry.
2. The generated script can be used by a user who has permissions to fix the SPN on the server.

To See the Log Files for This Tool:

By default, one log file is generated every time that the application is run in the user's application data folder: %APPDATA%\Microsoft\KerberosConfigMgr.

To Get Help:

Option 1: Hover the pointer over the command for tooltip.

Option 2: Run KerberosConfigMgr.exe –h from the command line.

Option 3: Click the Help button in the toolbar.