Menu
We are using MSDTC for SQL transactions. I am having issue with setting up firewall for MSDTC to work. The application and SQL are running on separate machine. Currently MSDTC is working if i turn off firewall on application server. I think there should be someway to add exception to the firewall setting for some ports. So that firewall can still be ON and DTC will not have any issues. I am not sure of the ports to add in firewall setting (I did try adding port 135 with no success)
225
All ports must be in the range of 1024 to 65535. If any port is outside this range or if any string is invalid, RPC will treat the entire configuration as invalid. Microsoft recommends that you open up ports from 5000 and up, and that you open a minimum of 15 to 20 ports.
If Windows Firewall is running, add an exception for the MSDTC service. The Windows Firewall service may block MSDTC communications between computers. To ensure that MSDTC communications are not blocked between computers, add msdtc.exe to the Windows Firewall exception list if the Windows Firewall service is running.
Microsoft's Distributed Transaction Coordinator (MSDTC) allows a variety of resource managers to transact across a network. In case if the Network DTC is disallowed on a certain system using a particular network configuration, it may abort the transaction.
Have your Firewall allow port 135 and the dcom port range. By default, the dcom port range is 1024-65535. Thats a big range to open up. You can limit this range in the registry or using dcomcnfg. This post describes this:
http://blogs.msdn.com/distributedservices/archive/2008/11/12/troubleshooting-msdtc-issues-with-the-dtcping-tool.aspx
190
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
