SQL 2000 not failover to second node

Giganews Newsgroups
Subject: SQL 2000 not failover to second node
Posted by:  Miguel Araujo (MiguelArau…@discussions.microsoft.com)
Date: Sat, 15 Dec 2007

I have a two node active/passive windows 2003 SP2 cluster.
I have three cluster groups created. One with MSDTC, the other with SQL
Server 2000 (I only have one instance) and the third with some other
resources like file shares.
When I move SQL Group to my second node it won't start unless I move first
the group that have MSDTC to the second node. If the group with MSDTC is on
second node, when I move SQL Group everything go well.

Is someone with the same problem?

Replies