help!
We are running a win2k3 cluster with sql2000, MSDTC seems to be running, and
it is added in the cluster resource.
I have done the dtctester and I get this result
Password: 1paSS4twf
tablename= #dtc25732
Creating Temp Table for Testing: #dtc25732
Warning: No Columns in Result Set From Executing: 'create table #dtc25732
(ival
int)'
Initializing DTC
Beginning DTC Transaction
Enlisting Connection in Transaction
Error:
SQLSTATE=37000,Native error=8501,msg='[Microsoft][ODBC SQL Server
Driver][SQL Se
rver]MSDTC on server 'BECL02KE\SQLCL1' is unavailable.'
Error:
SQLSTATE=24000,Native error=0,msg=[Microsoft][ODBC SQL Server Driver]Invalid
cur
sor 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.

For Windows 2003, we willneed to enable network MSDTC access. Have you already done this.

How to Configure Microsoft Distributed Transaction Coordinator on a Windows Server 2003 Cluster
http://support.microsoft.com/?id=301600

How to enable Network DTC access in Windows Server 2003
http://support.microsoft.com/?kbid=817064

HTH,

Best Regards,

Uttam Parui
Microsoft Corporation

This posting is provided "AS IS" with no warranties, and confers no rights.

Are you secure? For information about the Strategic Technology Protection Program and to order your FREE Security Tool Kit, please visit http://www.microsoft.com/security.

Microsoft highly recommends that users with Internet access update their Microsoft software to better protect against viruses and security vulnerabilities. The easiest way to do this is to visit the following websites:
http://www.microsoft.com/protect
http://www.microsoft.com/security/guidance/default.mspx

Make sure you do 817064 BEFORE you do 301600.

Cheers,

Rod

MVP - Windows Server - Clustering
http://www.nw-america.com - Clustering
http://www.msmvps.com/clustering - Blog

[quoted text, click to view]