Configuring the Microsoft Distributed Transaction Coordinator


While not required, it is recommended that you install the Microsoft Distributed Transaction Coordinator (MS DTC) on each of the cluster nodes before installing SQL Server 2005 clustering. This is because SQL Server 2005 requires this service o perform some functions, including running distributed queries, two-phase commit transaction, and some aspects of replication. MS DTC must be installed after installing Windows 2003 clustering but before installing SQL Server 2005 clustering.

While you can set up MS DTC for clustering from the command line, it is much easier to use Cluster Administrator, as described here. This is because this procedure automatically configures MS DTC on all of the cluster nodes at the same time. Take your time to ensure that you do it right the first time.

  1. Start Cluster Administrator.

  2. Right-click the Cluster Group resource group, select NewResource. This starts the new Resource Wizard.

  3. In the first screen of the Resource Wizard, enter the name of the resource you are creating, which would be "MSDTC Resource." If you like, you can also enter an optional description of this resource. Under Resource Type, select Distributed Transaction Coordinator. Under Group, Cluster Group should already be displayed. Click Next.

  4. In the Possible Owners screen, you will see that all of the nodes of the cluster are listed under Possible Owners. This is correct and should not be changed. Click Next.

  5. In the Dependencies screen, press and hold the CTRL key on the quorum disk resource and the Cluster Name, then click Add. Then click finish.

At this time, the MSDTC Resource is created. Now that the resource has been created, you must bring it online. From Cluster Administrator, right-click on the MSDTC Resource (it will have a red dot next to it) and select Bring Online. The red dot next to the resource name goes away, and the MSDTC Resource is now online and ready for use. If the new resource won't come online, delete it and try again.



Professional SQL Server 2005 Administration
Professional SQL Server 2005 Administration (Wrox Professional Guides)
ISBN: 0470055200
EAN: 2147483647
Year: 2004
Pages: 193

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net