Windows 2000 and SQL errors in Event Viewer

[richyd]

Has anyone come across these errors before?

We have a problem with one of our 2000 SQL clusters. Two of the servers has the same entries.
Both servers can access the 3 clustered disks and cluster and sql services are failing to start.


The description for Event ID ( 7031 ) in Source ( Service Control Manager ) cannot be found. The local computer may not have the necessary registry information or message DLL files to display messages from a remote computer.

The description for Event ID ( 1009 ) in Source ( ClusSvc ) cannot be found. The local computer may not have the necessary registry information or message DLL files to display messages from a remote computer. The following information is part of the event: .

The description for Event ID ( 9 ) in Source ( ql2300 ) cannot be found. The local computer may not have the necessary registry information or message DLL files to display messages from a remote computer. The following information is part of the event: \Device\Scsi\ql23001.

The description for Event ID ( 1285 ) in Source ( NIC Agents ) cannot be found. The local computer may not have the necessary registry information or message DLL files to display messages from a remote computer. The following information is part of the event: 0, 1.

A lot of the errors in the event viewer are very similar. Both servers are running Windows 2000 SP3 and SQL2000 SP2

Any help will be appricated!

Rich

 

[Sleigher]

Well, I can tell you where this normally happens, although the implications for your situation may vary...

Events are fired by number and each application installed on a server has a bunch of references for that number that get put into the event viewer whenever that number fires.

If you save an event file and take it to another computer that doesn't have the application installed and open it in event viewer, all you application specific errors will look like that.

Now, when you access event viewer remotely it might be trying to translate those events from local references which don't exist....Make sense?
If I bring in my laptop to your work and try and read your sql events with my event viewer when I don't have sql (and all it's event descriptor dll's) installed, this is what I would see...

Fix? Well you need to translate the events correctly before you find out what they are, so either run event viewer from the console or install Enterprise manager on the machine you're running the event viewer from.

If you're running from the console already and it's telling you this then I'm afraid I'm outta ideas

Sleigher

 

[richyd]

Thanks for that, funny thing that event was from the server. I'm going to reconfigure the cluster as this has failed.

Thanks for your help

Rich