Link to home
Start Free TrialLog in
Avatar of tfcmarty
tfcmartyFlag for United States of America

asked on

Which account should I delete after finding duplicate SPN of MSSQLSvc/LPZ-Tickets.LowryParkZoo.com:1433

Based on others I used the following command to export 2 entries:

ldifde -d dc=lowryparkzoo,dc=com -r "(serviceprincipalname=mssqlsvc/lpz-tickets*)" -l dn,serviceprincipalname -f CG.txt

Here are the results:

dn: CN=Administrator,CN=Users,DC=LowryParkZoo,DC=com
changetype: add
servicePrincipalName: MSSQLSvc/lpz-backup1.LowryParkZoo.com:1137
servicePrincipalName: MSSQLSvc/lpz-accounting.LowryParkZoo.com:1433
servicePrincipalName: MSSQLSvc/lpz-backup.LowryParkZoo.com:1511
servicePrincipalName: MSSQLSvc/lpz-tickets.LowryParkZoo.com:1433

dn: CN=LPZ-TICKETS,CN=Computers,DC=LowryParkZoo,DC=com
changetype: add
servicePrincipalName: MSSQLSvc/lpz-tickets.LowryParkZoo.com:1433
servicePrincipalName: DNS/lpz-tickets.LowryParkZoo.com
servicePrincipalName:
 NtFrs-88f5d2bd-b646-11d2-a6d3-00c04fc9b232/lpz-tickets.LowryParkZoo.com
servicePrincipalName: HOST/lpz-tickets.LowryParkZoo.com/LowryParkZoo.com
servicePrincipalName: HOST/lpz-tickets.LowryParkZoo.com/LOWRYPARKZOO
servicePrincipalName: HOST/LPZ-TICKETS
servicePrincipalName: HOST/lpz-tickets.LowryParkZoo.com

I looked at the  MSSQLSERVER service in LPZ-Tickets and it uses the Local System Account to Log On.

I noted that the CN=Administrator and CN=LPZ-Tickets both have the same MSSQLSvc serviceprincipalname.  

In MS article http://support.microsoft.com/kb/321044 it has as the resolution:
RESOLUTION
To resolve this problem, locate the computer accounts that have the duplicate SPNs. When you have located the computers that have the duplicate SPNs, you can either delete the computer account from the domain, disjoin and rejoin the computer to the domain, or you can use ADSIEdit to correct the SPN on the computer that has the incorrect SPN.

So I need to figure out which one to remove and how to use adsiedit to remove or fix the incorrect entry, so the SQL service stays running and the Event Error 11 in Source KDC is eliminated.

Thanks in advance.



Avatar of tfcmarty
tfcmarty
Flag of United States of America image

ASKER

I have ADSI edit working and can highlight servicePrincipalName = MSSQLSvc in both the Administrator account and LPZ-Tickets, I'm still struggling as to which one to remove.
ASKER CERTIFIED SOLUTION
Avatar of Henrik Johansson
Henrik Johansson
Flag of Sweden image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Thanks for both recommendations.  That helped me to understand what I was doing.
Thanks again.