Its Alive and multiple accounts event id 11.

Well the network managed to stay up and nothing untoward is appearing in the event logs regarding out Win2k3 changes so I am happy enough.

However....I did find something that was annoying me.

Event ID: 11

There are multiple accounts with name
MSSQLSvc/SQLSVR.uk.mydomain.local:1433
of type 10.

This error was appearing at random on the subdomain DC system log. Looking through I think this was ignored as it wasn't actually affecting the system and there were bigger fish to fry.

So here is the magic fix:

1. Install the support tools pack from your Windows disk. This can be found in the Support\Tools folder.
2. Run LDP from the run dialog box.
3. Click CONNECTION - CONNECT - OK to connect to the LDAP.
4. Click CONNECTION - BIND - OK, leaving fields empty again.
5. Click BROWSE - SEARCH, in the Base DN box enter your domain in LDAP format: DC=uk,DC=mydomain,DC=local
6. In the filter box enter serviceprincipalname= in my example above I entered: serviceprincipalname=MSSQLSvc/SQLSVR.uk.mydomain.local:1433 ,set scope to SUBTREE then click RUN.
7. You will get a listing of where it exists, we need to lose one.

In our case we had the SQLSERVER service running as a local system account at one time so there was an entry under the computer name and an entry under the user account which was now running the service. So to remove the name from the computer account we brought up ADSIEDIT.MSC, browse through the domain tree and found our server in question in the listing (this will depend on where your server exists and your OU setup), right-clicking - properties gave us its detail and browsing down to SERVICEPRINCIPALNAME we found the entry for MSSQLSvc/SQLSVR.uk.mydomain.local:1433 still there. Deleting and rebooting and we no longer get the errors in the log.