Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 High Availability (2005)
 SQL Server Not starting

Author  Topic 

seethem
Starting Member

46 Posts

Posted - 2008-03-11 : 12:00:02
Hello Gurus,

I have a 2-node Active/Active cluster.
I have 7 SQLSERVER instances (3 on one and 4 on the other)

I am attempting to start a SQL Server service on the second node and I keep getting the error messages...

Event ID: 19019
[sqsrvres] StartResourceService: StartService (MSSQL$LZ) failed. Error: 422

Event ID: 19019
[sqsrvres] OnlineThread: ResUtilsStartResourceService failed (status 422)

Event ID: 19019
[sqsrvres] OnlineThread: Error 422 bringing resource online.

What should I do?

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2008-03-11 : 23:04:54
Check windows event logs and cluster log file for details.
Go to Top of Page

seethem
Starting Member

46 Posts

Posted - 2008-03-12 : 01:42:13
1) These are the messages from the Windows Event Logs.
2) Where do I find the cluster log file?
Go to Top of Page

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2008-03-12 : 23:13:26
In windows directory on each node.
Go to Top of Page
   

- Advertisement -