SQL 2005 Cluster both nodes believing it is the active node

Posted on 2008-11-13
Last Modified: 2012-05-05
On a couple of occasions my two node Active-Passive SQL 2005 Cluster has been completely down because both nodes believe itself to be the active node in the cluster, thus generating an IP conflict on the network.
The only way for me to get the cluster started again is to just restart cluster service on both nodes, one at a time.

It appears that on each occasion, the passive node looses network connection to the active node for a short period and starts th failover process.

Any ideas what is going on and how to prevent this from happening?
Question by:Michaelc
    LVL 22

    Accepted Solution

    Is there and heart beat network configured as private or inter-cluster communications.  with the public network configured as mixed?
    LVL 1

    Author Comment

    Yes there is a heart beat network (basically a cross-over cable between the two nodes) that is setup up as mixed.

    The public network is also setup as mixed.
    LVL 1

    Author Comment

    I realized the stupidity of my response and set the heart beat network as private.

    Think that could be what was causing the problem?
    LVL 22

    Expert Comment

    Quite possible.
    Could review system event log ans cluster log to sure.

    If the public nic is pulled on the active node should see the classic cluster fail over to inactive node.

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    What Is Threat Intelligence?

    Threat intelligence is often discussed, but rarely understood. Starting with a precise definition, along with clear business goals, is essential.

    In this article I will describe the Backup & Restore method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
    In this article we will get to know that how can we recover deleted data if it happens accidently. We really can recover deleted rows if we know the time when data is deleted by using the transaction log.
    Via a live example, show how to backup a database, simulate a failure backup the tail of the database transaction log and perform the restore.
    Using examples as well as descriptions, and references to Books Online, show the documentation available for datatypes, explain the available data types and show how data can be passed into and out of variables.

    759 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    11 Experts available now in Live!

    Get 1:1 Help Now