Installing MS DTC on a Windows Server 2003 Cluster
If you're installing Microsoft SQL Server 2000 on a Windows 2003 cluster, you also need to install Microsoft Distributed Transaction Coordinator (MS DTC). Here's how.
June 27, 2005
To install Microsoft Distributed Transaction Coordinator (MS DTC), you use the Cluster Administrator tool and add a new resource to the cluster group. The resource type is Distributed Transaction Coordinator; the dependencies are the cluster IP address, the cluster name, and the quorum disk. Make sure you add all nodes of the cluster as possible owners. Microsoft's clustering documentation recommends that you create a separate group for the MS DTC resource, then add the Physical Disk and Network Name resource to the new group. To do so, I follow the steps detailed in the Microsoft article "How to configure Microsoft Distributed Transaction Coordinator on a Windows Server 2003 cluster" at http://www.support.microsoft.com/?kbid=301600.
About the Author
You May Also Like