MSDTC firewall config on a SQL server

If you’ve worked with BizTalk, you’ll know that configuring the Windows firewall can prove to be challenging when it comes to MSDTC.
 
The below Inbound Rules are known to work on the SQL server and are configured using wf.msc:
 
1) New Rule -> Custom -> All programs -> Protocol type (TCP), Local port (RPC Dynamic Ports), Remote port (All Ports)
-> Next -> Next -> Next -> Domain -> RPC_Dynamic_Ports -> Finish
 
2) New Rule -> Custom -> All programs -> Protocol type (TCP), Local port (RPC Endpoint Mapper), Remote port (All Ports)
-> Next -> Next -> Next -> Domain -> RPC_Endpoint_Mapper -> Finish
 
Also, check the following service states:

  • COM+ System Application (Manual)
  • System Event Notification Service (Auto)
  • Distributed Transaction Coordinartor (Auto)

    • Leave a Reply