I have 2 SQL 2005 Servers which are both Windows Server 2003 and both running MSDTC yet I am having issues getting the MSDTC to work.
When testing the MSDTC connection using dtctester I get the following error.
User Name: sa
Creating Temp Table for Testing: #dtc9869
Warning: No Columns in Result Set From Executing: 'create table #dtc9869 (ival int)'
Beginning DTC Transaction
Enlisting Connection in Transaction
SQLSTATE=37000,Native error=8509,msg='[Microsoft][ODBC SQL Server Driver][SQL Server]Import of Microsoft Distributed Transaction Coordinator (MS DTC) transaction failed: 0x8004d01f(error not found).'
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.
Has anyone had this problem before?