MS SQL Event Log 11

[Jtizzle]

I am getting the following error message on a DC Contrller that is running MS SQL 2000. I have looked into it and it would appear that there are two accounts using the same SPN but I cannot find the accounts. Any suggestions would be great. Thanks.

There are multiple accounts with name MSSQLSvc/mtmtor02.microtargetmedia.local:1433 of type DS_SERVICE_PRINCIPAL_NAME.

For more information, see Help and Support Center at

http://go.microsoft.com/fwlink/events.asp.

 

[mrdenny]

Sounds like you regestered the server with Active Directory. In Enterprise Manager right click on the server and goto properties. There should be an Active Directory tab. From there you should be able to remove and readd the SQL Server from Active Directory.

I would remove it, allow AD to replicate, then readd it.

Denny
MCSA (2003) / MCDBA (SQL 2000) / MCTS (SQL 2005) / MCITP Database Administrator (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com