MSDTC Doesn't seem to work

Giganews Newsgroups
Subject: MSDTC Doesn't seem to work
Posted by:  Vick Shaw (
Date: Wed, 14 Feb 2007

I have a 2 node SQL 2000 Cluster
When I run the dtctester.exe I run into the following error :
DSN:  dtctest
User Name: ******
Password: ******
tablename= #dtc24358
Creating Temp Table for Testing: #dtc24358
Warning: No Columns in Result Set From Executing: 'create table #dtc24358
(ival int)'
Initializing DTC
Beginning DTC Transaction
Enlisting Connection in Transaction
SQLSTATE=25S12,Native error=-2147168242,msg='[Microsoft][ODBC SQL Server
Driver]Distributed transaction error'
SQLSTATE=24000,Native error=0,msg=[Microsoft][ODBC SQL Server Driver]Invalid
cursor state
Typical Errors in DTC Output When
a.  Firewall Has Ports Closed
b.  Bad WINS/DNS entries
c.  Misconfigured network
d.  Misconfigured SQL Server machine that has multiple netcards.
Aborting DTC Transaction
Releasing DTC Interface Pointers
Successfully Released pTransaction Pointer.
Any help is greatly appreciated. Thanks a Lot.