SQL 2005 Cluster Failover issue

  • 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,

  • Have you checked the event viewer - application error logs

  • 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