MSDTC Question - Need Help

Hello All:
Not familiar with SQL but our DB Admin is stuck so I need some help. Our
Webserver is sitting in DMZ and needs communication to SQL on LAN.
Specifically, DTC. What was explained to me is that through a web page,
several tables are updated and DTC supposedly will roll back the process if
something should fail prior to the process completing.
The page hangs. Without the code in the page requiring the transaction, it
goes. I also pulled the server out of the DMZ and back onto the LAN and it
worked. So, this logically points to the Firewall. Looking through the FW
logs, I see RPC packet being dropped. So, I follow Microsoft's fix for
specifying a fixed range of ports for RPC instead if letting it assigning
ports dynamically. I opened those ports from DMZ to LAN and still nothing.
The packets are no longer being dropped but the page will still not display.
I'm stumped.
I woul greatly appreciate any suggestions or help on this one.Hello,
Based on my experience, this problem is mostly like a network configuration
issue. You can use dtcping.exe tool mentioned in the KB306843 to perform
further research on this problem. In the meantime, please check the
suggestions in the following articles to see if they meet your requirements.
250367 INFO: Configuring Microsoft Distributed Transaction Coordinator
(DTC) to
http://support.microsoft.com/?id=250367
306843 HOWTO: Troubleshoot MS DTC Firewall Issues
http://support.microsoft.com/?id=306843
Also, due to the feature of this issue, it usually is very hard to
troubleshoot in newsgroup. It would be best to contact Microsoft Product
Support Services via telephone so that a dedicated Support Professional can
assist with your request. To obtain the phone numbers for specific
technology request please take a look at the web site listed below.
http://support.microsoft.com/default.aspx?scid=fh;EN-US;PHONENUMBERS
Regards,
Michael Shao
Microsoft Online Partner Support
Get Secure! - www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.