• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 260
  • Last Modified:

SQL 2005 Cluster both nodes believing it is the active node

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?
0
Michaelc
Asked:
Michaelc
  • 2
  • 2
1 Solution
 
65tdCommented:
Is there and heart beat network configured as private or inter-cluster communications.  with the public network configured as mixed?
0
 
MichaelcAuthor Commented:
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.
0
 
MichaelcAuthor Commented:
I realized the stupidity of my response and set the heart beat network as private.

Think that could be what was causing the problem?
0
 
65tdCommented:
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.
0

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now