Microsoft has released a Kerberos configuration manager tool for SQL Server.  I have not tested it yet but could be very usefull.

The tool can perform the following functions:

  • Gather information on OS and Microsoft SQL Server instances installed on a server.
  • Report on all SPN and delegation configurations on the server.
  • Identify potential problems in SPNs and delegations.
  • Fix potential SPN problems.

Link to download the tool:  http://www.microsoft.com/en-us/download/details.aspx?id=39046

More information: http://blogs.msdn.com/b/analysisservices/archive/2013/05/23/released-kerberos-configuration-manager-for-sql-server.aspx

Advertisements