Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

SQL 2005 Cluster Failover issue Expand / Collapse
Author
Message
Posted Thursday, March 10, 2011 9:16 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Thursday, April 03, 2014 8:06 AM
Points: 39, Visits: 513
Hi All,
I have a failover issue with my 2 node SQL 2005 SP4 cluster(W2k3). (Actaully Failover between nodes were good) But from yesterday after install of Microsoft Baseline Configuration Analyzer by another Collegeue of mine(can be a possible issue) and after a failover started noticing this issue. I see the Failover of the Primary Node is Not failing for the SQL Instance ,Agent and Full text to secondary node.
But there doesn't seem to be issue with Instance 2(failover between nodes are smooth). So the issue is only with Instance 1 when failover occurs.
******************************************
Error:
[sqsrvres] OnlineThread: ResUtilSetResourceServiceEnvironment failed (status 6)


For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.
************************************

Any help appericiated.
Thanks,
Post #1076336
Posted Thursday, March 10, 2011 11:24 AM
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Wednesday, April 09, 2014 9:05 AM
Points: 1,623, Visits: 1,801
Have you checked the event viewer - application error logs
Post #1076457
Posted Thursday, March 10, 2011 8:34 PM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Thursday, April 03, 2014 8:06 AM
Points: 39, Visits: 513
Yes, that is where i picked the Error on my post from.

Thanks,
Post #1076654
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse