Home
%3CLINGO-SUB%20id%3D%22lingo-sub-1115388%22%20slang%3D%22en-US%22%3EReleased%3A%20update%20for%20Kerberos%20Configuration%20Manager%20for%20SQL%20Server%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1115388%22%20slang%3D%22en-US%22%3E%3CP%20class%3D%22%22%3EThe%20%3CSTRONG%3EKerberos%20Configuration%20Manager%20for%20SQL%20Server%3C%2FSTRONG%3E%20is%20a%20diagnostic%20tool%20that%20helps%20troubleshoot%20Kerberos%20related%20connectivity%20issues%20with%20SQL%20Server%2C%20SQL%20Server%20Reporting%20Services%20(SSRS)%2C%20and%20SQL%20Server%20Analysis%20Services%20(SSAS).%20It%20can%20perform%20the%20following%20functions%3A%3C%2FP%3E%0A%3CUL%20class%3D%22sbody-free_list%22%3E%0A%3CLI%3ECollect%20information%20about%20operating%20system%20(OS)%2C%20Microsoft%20SQL%20Server%20instances%2C%20and%20Always%20On%20Availability%20Group%20Listeners%20installed%20on%20a%20server.%3C%2FLI%3E%0A%3CLI%3EReport%20all%20Service%20Principal%20Name%20(SPN)%20and%20delegation%20configurations%20on%20the%20server.%3C%2FLI%3E%0A%3CLI%3EIdentify%20potential%20problems%20in%20SPNs%20and%20delegations.%3C%2FLI%3E%0A%3CLI%3EFix%20potential%20SPN%20problems.%3C%2FLI%3E%0A%3C%2FUL%3E%0A%3CP%3E%3CSPAN%3EThe%20new%20release%20(v4.2)%20adds%20support%20for%20SQL%20Server%202019.%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EYou%20can%20download%20the%20tool%20%3CA%20href%3D%22https%3A%2F%2Fwww.microsoft.com%2Fen-us%2Fdownload%2Fdetails.aspx%3Fid%3D39046%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehere%3C%2FA%3E%2C%20as%20well%20as%20read%20its%20install%20and%20usage%20instructions.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-TEASER%20id%3D%22lingo-teaser-1115388%22%20slang%3D%22en-US%22%3E%3CP%20class%3D%22%22%3EThe%26nbsp%3B%3CSPAN%3E%3CSTRONG%3EMicrosoft%20Kerberos%20Configuration%20Manager%20for%20SQL%20Server%3C%2FSTRONG%3E%20is%20a%20diagnostic%20tool%20that%20helps%20troubleshoot%20Kerberos%20related%20connectivity%20issues%20with%20SQL%20Server.%20The%20new%20release%20supports%20SQL%20Server%202019.%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-TEASER%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1115388%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ESQLReleases%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1117679%22%20slang%3D%22en-US%22%3ERe%3A%20Released%3A%20update%20for%20Kerberos%20Configuration%20Manager%20for%20SQL%20Server%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1117679%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20Pedro%2C%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EFirst%20of%20all%20thank%20you%20for%20the%20latest%20version!%20I've%20been%20using%20this%20tool%20for%20quite%20some%20time%20now%20and%20it%20works%20great.%3C%2FP%3E%3CP%3EOne%20remark%20though%3B%20If%20you're%20using%20GMSA%20accounts%20for%20your%20SQL%20Server%20this%20till%20will%20set%20them%2C%20and%20if%20you%20run%20the%20tool%20again%20it%20will%20give%20the%20status%20%22Misplaced%22.%20When%20you%20fix%20it%20and%20check%20again%20same%20story...%3C%2FP%3E%3CP%3EWhen%20i%20check%20it%20via%20setspn%20-l%20accountname%20it%20shows%20the%20SPN%20that%20was%20set%20via%20the%20tool...%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIt%20would%20be%20great%20if%20this%20could%20be%20addressed%20and%20fixed%20as%20well.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAny%20thoughts%20about%20this%3F%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you.%3C%2FP%3E%3CP%3ETeun%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1126819%22%20slang%3D%22en-US%22%3ERe%3A%20Released%3A%20update%20for%20Kerberos%20Configuration%20Manager%20for%20SQL%20Server%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1126819%22%20slang%3D%22en-US%22%3E%3CP%3EThanks%20for%20the%20update%2C%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F194232%22%20target%3D%22_blank%22%3E%40Pedro%20Lopes%3C%2FA%3E%26nbsp%3B!%3C%2FP%3E%3CP%3ESupport%20SQL%20Server%202019%20is%20what%20was%20really%20missing%20in%20the%20previous%20version.%20Great%20job!%3C%2FP%3E%3C%2FLINGO-BODY%3E
Microsoft

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 about operating system (OS), Microsoft SQL Server instances, and Always On Availability Group Listeners installed on a server.
  • Report all Service Principal Name (SPN) and delegation configurations on the server.
  • Identify potential problems in SPNs and delegations.
  • Fix potential SPN problems.

The new release (v4.2) adds support for SQL Server 2019.

 

You can download the tool here, as well as read its install and usage instructions. 

2 Comments
New Contributor

Hi Pedro, 

 

First of all thank you for the latest version! I've been using this tool for quite some time now and it works great.

One remark though; If you're using GMSA accounts for your SQL Server this till will set them, and if you run the tool again it will give the status "Misplaced". When you fix it and check again same story...

When i check it via setspn -l accountname it shows the SPN that was set via the tool...

 

It would be great if this could be addressed and fixed as well.

 

Any thoughts about this? 

 

Thank you.

Teun

Senior Member

Thanks for the update, @Pedro Lopes !

Support SQL Server 2019 is what was really missing in the previous version. Great job!