MSDTC - SQL 2005 active/passive cluster problems

Giganews Newsgroups
Subject: MSDTC - SQL 2005 active/passive cluster problems
Posted by:  Doug (nospam@comcast.net)
Date: Sun, 6 Sep 2009

I run an active/passive SQL 2005 cluster (Svc Pk 2, soon 3) on Windows Svr
2003 (Svc Pk 2).  Our most recent round of operating system patches seems to
have broken MSDTC, as it was working fine until this last round of patches.
I've had firewall guys looking for dropped packets between the app server in
question and the cluster - to include the IPs and network names of the 2
nodes and they're not finding any dropped packets.

I used two tools I've used previously (DTCTester & DTCPing), and both appear
to indicate RPC binding is successful but a reverse binding in DTC is
failing.  I would much appreciate any thoughts someone may have - I've been
looking wothout success.  Why would a reverse bind on DTC fail?  The
firewall guy indicated bidirectional is in place, however it is only
bidirectional if the app server initiates.  I'm not an expert on DTC, but
our current setup was working until the latest operating system patches.

Thanks in advance.

Replies