Setting Up Remote MSDTC

Applies to…

  • DxEnterprise for Windows
  • Microsoft SQL Server

Summary

Because MSDTC can only run under a single server name per server, if you have multiple virtualized instances that require the use of MSDTC you will need to setup a remote coordinator.

Information

Here are the steps to configure your DxEnterprise cluster nodes to use a remote DTC coordinator.

On a server outside of the DxEnterprise cluster (the remote coordinator):

  1. Launch Windows Component Services (Run > dcomcnfg)
  2. Expand “Component Services”, “Computers”, “My Computer”, “Distributed Transaction Coordinator”
  3. Right-click on “Local DTC” and select “Properties”
  4. Select the “Security” tab
  5. Under “Security Settings” check the “Network DTC Access”, “Allow Remote Clients”, “Allow Inbound”, “Allow Outbound” and “Enable XA Transactions” check boxes
  6. Click “OK”

 

On each of your DxEnterprise cluster nodes:

  1. Launch Windows Component Services (Run > dcomcnfg)
  2. Expand “Component Services”, “Computers”
  3. Right-click on “My Computer” and select “Properties”
  4. Select the “MSDTC” tab
  5. Under “Default Coordinator” uncheck the “Use local coordinator” check box
  6. Under “Remote coordinator host name” enter the host name of the remote coordinator
  7. Click “OK”