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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top