I am getting the error
There are multiple accounts with name MSSQLSvc/mcwp-s01.local:1433 of type DS_SERVICE_PRINCIPAL_NAME on a Widows 2003 server running SQL.
I have found the 2 accounts..please see results from using method 1 ldp support tool from article kb 321044.
ldap_search_s(ld, "DC=mcwp,DC=local", 2, "(serviceprincipalname=MSSQLSvc/mcwp-s01.mcwp.local:1433)", attrList, 0, &msg)
Result <0>: (null)
Getting 2 entries:
>> Dn: CN=MCWP-S01,OU=Domain Controllers,DC=mcwp,DC=local
5> objectClass: top; person; organizationalPerson; user; computer;
1> cn: MCWP-S01;
1> distinguishedName: CN=MCWP-S01,OU=Domain Controllers,DC=mcwp,DC=local;
1> name: MCWP-S01;
1> canonicalName: mcwp.local/Domain Controllers/MCWP-S01;
>> Dn: CN=SQLMAN,OU=Service Accounts,OU=MCWP,DC=mcwp,DC=local
4> objectClass: top; person; organizationalPerson; user;
1> cn: SQLMAN;
1> distinguishedName: CN=SQLMAN,OU=Service Accounts,OU=MCWP,DC=mcwp,DC=local;
1> name: SQLMAN;
1> canonicalName: mcwp.local/MCWP/Service Accounts/SQLMAN;
I am confused on what step to take next because in the article kb321044 it says to either delete the computer account from domain or disjoin and rejoin to the domain. The problem is one of these is a service account and is not a computer account. Any ideas on what i should do to fix this error?