3.4.3 MxDB for SQL Server Installation and Administration Guide

Appendix B: Host MS DTC on a Remote Node 124

If possible, it is recommended that you implement this configuration

rather than virtualizing DTC locally on the node hosting SQL. This extra

saving on overhead can surely benefit the local SQL service or the local

system processes overall.

References

The following sources provide additional information.

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

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