Monday, October 14, 2019

Kerberos Configuration Manager issue when retrieve SPN

Problem:- 
If you face below error when trying to connect Locally retrieve SPN using Kerberos Configuration Manager Microsoft tool.



Error:-
The Was and Issue with accessing UserAccount information from the system, Please check logs 
at %AppData%\Microsoft\KerberosConfigMgr for more information
Solution:-
Remove any user who has GUID in the Local Administrator Group. And start to connect again


or run below using the user has domain admin privilege. 

 Script:-
SetSPN -s "MSSQLSvc/Hostnam.YourDomain.com" "DomainSQLServiceAccount$"
SetSPN -s "MSSQLSvc/Hostnam.YourDomain.com:1433" " DomainSQLServiceAccount$"

ex:-
SetSPN -s "MSSQLSvc/D1SQPWV1.ABC.com" "ABC\ SVC_B"
SetSPN -s "MSSQLSvc/D1SQPWV1.ABC.com:1433" "ABC\ SVC_B "

Ref:-
By at

3 comments:

  1. rickyMarch 13, 2020 at 9:50 PM

    what if there are GUID entries? My logs just show 3/13/2020 1:39:34 PM Info: Connect to WMI, \root\cimv2 nothing else. Any help would be greatly appreciated and thank you for this one. It helped on a couple servers but the last one :( not so much.

    ReplyDelete
    Replies
    1. Mk.elsawyMarch 17, 2020 at 11:06 PM

      Thanks for visiting my blog.i'm glad that helped with couple servers i suggest to check the server registered in DNS.

      Delete
  2. AnonymousAugust 28, 2020 at 11:27 PM

    This issue can also occur if there is group membership in the local administrators group from another domain\forest.

    ReplyDelete

Subscribe to: Post Comments (Atom)