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?
LVL 1
MichaelcAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

65tdRetiredCommented:
Is there and heart beat network configured as private or inter-cluster communications.  with the public network configured as mixed?
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
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
65tdRetiredCommented:
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
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server 2005

From novice to tech pro — start learning today.