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