You can open the domain.txt and then search MSSQLSvc to find the multiple
accounts with name MSSQLSvc/servername.domainname.local.
For example you have found the following:
dn: CN=Administrator,CN=Users,DC= domainname,DC=local
servicePrincipalName:MSSQLSvc/servername.domainname.local
dn: CN=SBSERVER,OU=Domain
Controllers,DC= domainname,DC=local
servicePrincipalName: MSSQLSvc/servername.domainname.local
servicePrincipalName: MSSQLSvc/servername.domainname.local is duplicated in
the two above CN. Because the duplicate, it will report the error "There
are multiple accounts with name MSSQLSvc/servername.domainname.local of
type DS_SERVICE_PRINCIPAL_NAME". You may need to delete the
MSSQLSvc/servername.domainname.local in dn: CN=Administrator,CN=Users,DC=
domainname,DC=local or dn: CN=SBSERVER,OU=Domain Controllers,DC=
domainname,DC=local.
After you find the accounts, one account should be the current SQL service
account and the others should be the former accounts. To determine which
one was the one in current use, run adsiedit.msc and locate the account,
right click the attribute, click Properties then locate the
servicePrincipalName attribute and delete one of the MSSQLSvc SPN, then
restarted the SQL service(s). The SQL service will re-add the SPN on the
currently in use service account. If it was not re-added, then the
duplicate has been removed. The following is detailed steps:
1. Expand DC=local DC= domainname, CN=Users, CN=Administrator.
2. Right click the CN=Administrator and select properties and then locate
the attribute ServicePrincipalName in Attribute Editor
3. Double click ServicePrincipalName and then locate to
MSSQLSvc/servername.domainname.local to remove it.
4. After restarting the SQL service(s), if
servicePrincipalName:MSSQLSvc/servername.domainname.local is not added on
dn: CN=Administrator,CN=Users,DC= domainname,DC=local, the operation will
succeed. Or else, you need to delete MSSQLSvc/servername.domainname.local
on another dn.