4.0.0 HP PolyServe Software for Microsoft SQL Server Administration Guide (T5392-96056, March 2010)

Summary
DTC is quite important in a distributed environment. It is the middle man ensuring that all parties that
participated in a transaction agree with the resulting outcome. The transaction is guaranteed to be
either 100% committed or rolled back.
Hosting DTC remotely on a dedicated node is easy to set up and use. HP PolyServe Software for
Microsoft SQL Server works quite well in this scenario and has fewer restrictions regarding whether
the hosting node is part of the same cluster that is using it.
References
The following sources are for MSDTC on Windows 2003. In general, the information also applies to
MSDTC on Windows 2008, with the exception of the minor GUI change described in the following
article:
http://msdn.microsoft.com/en-us/library/aa561924(BTS.20).aspx
How To Set Up a Local MS DTC to Point to a Remote MS DTC:
http://support.microsoft.com/kb/260882
How to enable network DTC access in Windows Server 2003:
http://support.microsoft.com/kb/817064
How to configure Microsoft Distributed Transaction Coordinator on a Windows Server 2003 cluster:
http://support.microsoft.com/kb/301600
Distributed Transactions:
http://msdn.microsoft.com/library/en-us/acdata/ac_8_md_06_6lo6.asp
Microsoft tool to test DTC configuration:
http://support.microsoft.com/kb/293799
Microsoft tool to test the connection between the local SQL Server and the remote DTC host:
http://www.microsoft.com/downloads/details.aspx?FamilyID=5E325025-4DCD-4658-A549-1D549AC17644&
displaylang=en
Managing Accounts and Privileges:
http://msdn.microsoft.com/library/en-us/cossdk/htm/pgdtc_admin_7gkz.asp
Failover Clustering Dependencies:
http://msdn.microsoft.com/library/en-us/adminsql/ad_clustering_63sj.asp
Prerequisite Considerations for Adding a DTC Resource to a Cluster:
http://msdn.microsoft.com/library/en-us/cossdk/htm/pgdtc_admin_5hpv.asp
HOWTO: Enable DTC Between Web Servers and SQL Servers Running Windows Server 2003:
http://support.microsoft.com/kb/555017
INFO: Configuring Microsoft Distributed Transaction Coordinator (DTC) to Work Through a Firewall:
http://support.microsoft.com/kb/250367
How To Troubleshoot MS DTC Firewall Issues:
http://support.microsoft.com/kb/306843
HP PolyServe Software for Microsoft SQL Server administration guide 153