Link to home
Start Free TrialLog in
Avatar of BladesAway
BladesAway

asked on

MSDTC Prevents Cluster Failover/MSDTC will not failover on 2003 Cluster

I have set up a Windows 2003 Active/Passive cluster.  I have two Groups, the default cluster group and then a group that will eventually take on SQL2005.    The default group has all the usual, the Q drive, which is actual a single diskset with two partitions (Q and R), the Clustername, and the clusterIP.   I have read that MSDTC needs to be added for SQL 2005.   I have created the MSDTC resource according to MS KB301600 and KB 817064.   I have put it into the default group.  The problem happens when I do a move group.  All the resources in the group move to the other node but MSDTC does not move and causes the group to fallback to the original node.  If I delete the MSDTC resources and do a failover of the default group or second group all is well.  I'm not sure what is going on.  Both NODEs in the cluster are Domain Controllers and DNS servers as recommended in the MS Cluster Quick Start guide.  
Any ideas?
ASKER CERTIFIED SOLUTION
Avatar of 65td
65td
Flag of Canada image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial