Post reply

SQL 2005 Cluster Failover issue

  • March 10, 2011 at 9:16 am

    #248030

    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,

  • March 10, 2011 at 11:24 am

    #1297266

    Have you checked the event viewer - application error logs

  • March 10, 2011 at 8:34 pm

    #1297435

    Yes, that is where i picked the Error on my post from.

    Thanks,

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply