MSDTC Doesn't seem to work

Giganews Newsgroups
Subject: MSDTC Doesn't seem to work
Posted by:  Vick Shaw (nospam@msft.com)
Date: Wed, 14 Feb 2007

Hi,
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
Error:
SQLSTATE=25S12,Native error=-2147168242,msg='[Microsoft][ODBC SQL Server
Driver]Distributed transaction error'
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
-OR-
b.  Bad WINS/DNS entries
-OR-
c.  Misconfigured network
-OR-
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.

Regards,
Vick

Replies