Skip to main content
Version: v23.0

Setting Up Remote MSDTC

Applies to:

  • DxEnterprise for Windows

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

    SQL server dtc properties

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

    SQL server my computer properties

  7. Click OK

Additional Information

NetBIOS over TCP/IP is required for MSDTC.

To open WINS configuration:

  1. Right-click on the primary Ethernet adapter and select Properties > Internet Protocol Version 4 (TCP/IP) > Advanced > WINS

  2. Select Enable NetBIOS over TCP/IP

  3. Select OK

Advanced TCPIP Settings