3.4.3 MxDB for SQL Server Installation and Administration Guide

Appendix B: Host MS DTC on a Remote Node 113

Set Up Local Nodes to Use Remote DTC

When another node is used to host DTC, every local node participating in

a virtual SQL must be configured manually. In the following procedure,

we will configure two distinct Virtual SQLs (vSQLTest1 and vSQLTest2).

vSQLTest1 consists of two local nodes, QAR14S17 and QAR14S18 (node 1

and node 2 respectively). vSQLTest2 also consists of two local nodes,

QAR14S31 and QAR14S32 (node 4 and node 5 respectively). Although

these nodes are in the same matrix, they do not have to be. Also, these

nodes are residing in a different network subnet than the remote DTC

hosting node (QAR4S5).

1. Open Component Services: Start > Programs > Administrative Tools.

2. Expand the Component Services folder and browse to the My

Computer folder.

3. Right click on the My Computer folder to bring up its properties

dialog.

4. Select the MSDTC tab.