SQL Server service stopping mode on One Cluster Node

Giganews Newsgroups
Subject: SQL Server service stopping mode on One Cluster Node
Posted by:  Dinesh Bhandare
Date: Tue, 27 Oct 2009

OS= Windows 2003 64Bit Ent. R2 SP2 (latest updates)
SQL Server= MS SQL 64Bit Ent. with SP2
Below events gets generated on Cluster Node :-

1]The Cluster Service failed to bring the Resource Group "ABCD" completely
online or offline.
2]Cluster resource 'SQL Server' in Resource Group 'IABCD' failed. (Event id
-1069)
3]The SQL Server Agent (MSSQLSERVER) service terminated unexpectedly.  It
has done this 1 time(s). --Event ID -- 7039

Event ID - 19019
[sqsrvres] CheckServiceAlive: Service is dead
[sqsrvres] OnlineThread: Error 1 bringing resource online.
[sqsrvres] OnlineThread: service stopped while waiting for QP.
[sqsrvres] CheckServiceAlive: Service is dead
[sqsrvres] OnlineThread: Error connecting to SQL Server.
[sqsrvres] ConnectToSQL: service stopped while trying to connect to server.
[sqsrvres] CheckServiceAlive: Service is dead

When we try to bring onlibe the failed resources or move group then server
goes to hung state.

Please help in this .

Thanks in Advance.

Regards
Dinesh Bhandare

Replies