KDC, EVENT ID: 11 - There are multiple accounts with name MSSQLSvc/DELL700.<domain>.com:1433

I'm receiving the following message on my two domain controllers, in Event Viewer, 'System'
I've done some digging but I'm not sure how to correct this so the error won't appear any longer.  I have several things going on with this domain and I think this is just the beginning.  I appreciate any assistance you are able to provide.

Event Type:        Error
Event Source:     KDC
Event Category:  None
Event ID:            11
Date:                 4/16/2010
Time:                 3:53:43 PM
User:                 N/A
Computer:          DUALASD
Description:
There are multiple accounts with name MSSQLSvc/DELL700.<domain>.com:1433 of type DS_SERVICE_PRINCIPAL_NAME.

For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.
johnrhinesNetwork AdministratorAsked:
Who is Participating?
 
Henrik JohanssonSystems engineerCommented:
You've propably installed MSSQL to first run with system rights causing the computer account to get the SPN set, and later changed to a service account.

The KB posted above describes howto find the duplicates.
You can also use dsquery command (part of adminpak.msi)

C:\>dsquery * -filter "(serviceprincipalname=MSSQLSvc/DELL700.<domain>.com:1433)" -attr samaccountname

When you've found the accounts causing the duplicate, use setspn command line tool to delete the SPN from the account that shall not be used

C:\>setspn -D MSSQLSvc/DELL700.<domain>.com:1433 <accountname>
0
 
VenabiliCommented:
One of the methods here http://support.microsoft.com/kb/321044 should get you started at least.
0
 
johnrhinesNetwork AdministratorAuthor Commented:
Thank you very much for your help.  I'm no longer receiving the error in Event Viewer and it appears to have resolved my problem.  Thanks again!
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.