Has anyone resolved [sqsrvres] StartResourceService: StartService?

Hello all,
I am working with a 2 node SQL Server 2000 cluster on Windows Server 2003.
Each node is a primary node for one of two SQL instances (Active/Active).
Everything worked fine until I applied the latest SQL Server service pack
(MS03-031). When I try to move a group (disks and SQL resources) from a
primary node to the secondary node the disks transfer fine but the SQL Server
service fails to start and the group goes back to its original owner after 3
tries. The following errors are in the event log. Any ideas? -Phil
[sqsrvres] StartResourceService: StartService (MSSQL$Inst1) failed. Error:
41d
[sqsrvres] OnlineThread: ResUtilsStartResourceService failed (status 41d)
[sqsrvres] OnlineThread: Error 41d bringing resource online.Error 41d corresponds to message:
The service did not respond to the start or control request in a timely
fashion.
So the problem seems the sql service itself is unable to start on the other
node. To troubleshoot further you will need to
1- check app + sys logs for any other clues, what errors do you see when
attempting to start the MSSQL$Inst1
do you see that the MSSQL$Inst1 started but then shut down? Are there any
errors stating some dll could not be loaded? Or do you only see the errors
you reported?
2. check the sql error logs(c:\program files\microsoft sql
server\mssql$INST1\LOG\errorlog), if SQL Server started a new errorlog file
should have created during this time. Was one created, if so check for any
errors
3. Check for: "The application failed to initialize properly" error when
starting SQL - ID: 326571.KB.EN-US
4. can you start sql on from a command prompt on the second node? To do
this you will need to fail over to node2, bring online the network name and
sql disks, now run (sql resource would still be offline/failed state)
c:\program files\microsoft sql server\mssql$INST\binn\sqlservr -iINST -c
Fany Vargas
Microsoft Corporation
This posting is provided "AS IS" with no warranties, and confers no rights.
Are you secure? For information about the Strategic Technology Protection
Program and to order your FREE Security Tool Kit, please visit
http://www.microsoft.com/security.
Microsoft highly recommends that users with Internet access update their
Microsoft software to better protect against viruses and security
vulnerabilities. The easiest way to do this is to visit the following
websites:
http://www.microsoft.com/protect
http://www.microsoft.com/security/guidance/default.mspx