October 15, 2004 at 1:23 pm
We have a Win2K03 system with Active Directory. The domain controller event log shows the folowing error message for only 2 of our many sql servers. Any idea what it means?
"There are multiple accounts with name MSSQLSvc/SqlServerName.ou.com:1433 of type DS_SERVICE_PRINCIPAL_NAME. "
TIA,
Bill
October 15, 2004 at 6:14 pm
It means there are duplicate entries in Active Directory for this service principal name. A directory administrator can use ldp.exe to search for the duplicates and either ldp.exe again or adsiedit.msc to delete the duplicates. Obviously this calls for some care as these two are lower-level tools for Active Directory. Here are some references:
Windows 2000 Server Prompts Domain User for Credentials (305971)
Using Ldp.exe to Find Data in the Active Directory (224543)
Deleting Objects from Active Directory Using Ldp.exe (244344)
K. Brian Kelley
@kbriankelley
November 11, 2010 at 12:11 pm
I used the LDP tool to search for all SPN's but the 3 entries in my Event Viewer that get this error message only show up with one SPN assigned to them, so there are no duplicates to delete.
What other reason could it be on why I'm getting this error message?
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply