Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium


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

Posted on 2007-08-08
Medium Priority
Last Modified: 2010-07-27
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?
Question by:BladesAway
1 Comment
LVL 22

Accepted Solution

65td earned 1500 total points
ID: 19662727
"Q drive, which is actual a single diskset with two partitions (Q and R)", Q and R need separate disks not partitions on one disk.

Featured Post

[Webinar] Database Backup and Recovery

Does your company store data on premises, off site, in the cloud, or a combination of these? If you answered “yes”, you need a data backup recovery plan that fits each and every platform. Watch now as as Percona teaches us how to build agile data backup recovery plan.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Recently, I had the need to build a standalone system to run a point-of-sale system. I’m running this on a low-voltage Atom processor, so I wanted a light-weight operating system, but still needed Windows. I chose to use Microsoft Windows Server 200…
Setting up a Microsoft WSUS update system is free relatively speaking if you have hard disk space and processor capacity.   However, WSUS can be a blessing and a curse. For example, there is nothing worse than approving updates and they just have…
This video shows how to quickly and easily deploy an email signature for all users in Office 365 and prevent it from being added to replies and forwards. (the resulting signature is applied on the server level in Exchange Online) The email signat…
Integration Management Part 2

564 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question