cancel
Showing results for 
Search instead for 
Did you mean: 

How to determine which MSSQLSvc to delete? Because of KDC Error?

Andre_Ams
Level 2

Hi there somebody, who is getting me out of trouble, I hope? 

 

The following error persits in my logs, don't know if related but since then backup will not complete (see my post 'media mount failed')

 

Get the below KDC error.

There are multiple accounts with name
MSSQLSvc/servername.mydomain.local:1514 of type DS_SERVICE_PRINCIPAL_NAME.

With ldf tool I found in the output.txt
servicePrincipalName: MSSQLSvc/SERVER.mydomain.local:1514
servicePrincipalName: {14E52635-0A95-4a5c-BDB1-E0D0C703B6C8}/SERVER
servicePrincipalName:
{14E52635-0A95-4a5c-BDB1-E0D0C703B6C8}/SERVER.mydomain.local

With ADSI Edit adsiedit.msc I found in the properties of CN=Administrator
under servicePrincipalName These accounts.

MSSQLSvc/SERVER.mydomain.local:1514
{14E52635-0A95-4a5c-BDB1-E0D0C703B6C8}/SERVER
{14E52635-0A95-4a5c-BDB1-E0D0C703B6C8}/SERVER.mydomain.local

Now I do not know which account to remove, Can someone pls advise me!!!

Thx André

1 REPLY 1

Matt_TMP
Level 2

I am having the same problem.  Although I could not get the ldf tool to work to display the user names.  

 

Also I do not know how to delete the accounts.  I just recently had to rebuild our SQL server due to severe harddisk corruption.