multiple accounts with name MSSQLSvcr

  • Thread starter Thread starter Clint
  • Start date Start date
C

Clint

We recently had to restore our SQL server. Now on all of
our domain controllers, we are receiving an event id 11
in the system log..."There are multiple accounts with
name MSSQLSvcr/server name:1433 of type 10". Any idea how
to correct this?
 
It means you have multiple computer accounts with the same SPN. Find the duplicate and kill it.

You can do this with an ldap query something like

adfind -gc -b -f servicePrincipalName=MSSQLSvcr/server name:1433 -dn

You can get adfind at www.joeware.net on the free win32 tools page.

joe
 
Back
Top