|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?