How To: Configure Microsoft Distributed Transaction Coordinator MSDTC

Relates to Version 3.29.0+

Following is a guide to assist in configuring MSDTC between the Application server and the Database server.

 

Overview:

The Microsoft Distributed Transaction Coordinator (MSDTC) service is responsible for coordinating transactions that span multiple resource managers, such as databases, message queues, and file systems. MSDTC performs the transaction coordination role for components, usually with COM and .NET architectures.

MSDTC needs to be configured on the Application server and the Database server to facilitate PITRAM functionality. 

Configuring MSDTC:

1. From Start, search for dcomcnfg and press Enter on your keyboard
   (You can also search for 'Component Services' to open the same window.)
2. Expand the nodes in the Console pane to locate the DTC (e.g. Local DTC)
   Component Services>Computers>MyComputer>Distributed Transaction Coordinator>Local DTC
3. Right-click the DTC then click Properties
4. Click the Security tab
5. Under Security Settings, select the Network DTC Access
6. Under Client and Administration,
   select Allow Remote Clients and Allow Remote Administration checkboxes
7. Under Transaction Manager Communication,
   select the Allow Inbound and Allow Outbound checkboxes
8. Under Transaction Manager Communication, click the No Authentication Required radio button
9. Select the Enable XA Transactions checkbox
10. Click Apply
11. Click OK

Please Note: The firewall rules must allow MSDTC communications through on each server. Ensure the Windows Defender Firewall Rules have Distributed Transaction Coordinator (DTC) rules inbound and outbound enabled on both Application and Database servers. If your company uses a third party firewall; That system will also need to allow the DTC traffic between the two servers.

Troubleshooting: DTCPing and DTCTester are great tools to review and evaluate your configured systems. They provide connection, interface and network related feedback to ensure your Application and Database server configurations are appropriately coordinated.

Want to learn more?

Click here to login to our Learning Management System

Click here to request access