Skip to Content
0
Former Member
Jul 14, 2008 at 02:12 AM

Cannot start SQL Server on second Node of Windows Cluster

434 Views

Colleagues,

I am using SQL Server 2005 on a Windows cluster. When I failover from the database server to the central instance, all groups move successfully except for MSSQL.

SQL Server fails. All dependencies come online, however.

The 2 error messages I see in the event viewer are:

[sqsrvres] OnlineThread: Error 5b4 bringing resource online.

[sqsrvres] OnlineThread: ResUtilsStartResourceService failed (status 5b4)

I tried to start SQL Server manually on the CI instance but it failed and remained in "starting" status.

I also tried starting SQL server outside of the cluster at the command prompt with net start mssqlserver -C to see if it will start at all. It also remained in "starting" status.

I suspect a re-install of SQL server may be required but if there are any other suggestions, I would appreciate it.

Thanks in advance,

Regards,

Andy