Hello

I have a SQL2000 64bits running on a Windows2003 64bits
cluster. SQL Version is 8.00.904.The cluster is
active/passive and has been running for two months.

Yesterday we made a manual failover from Node1 to Node2
for testing porpouses. First I made the Cluster Group
failover which contains the following resources: Cluster
Ip Address, Cluster Name, Quorum Disk and MSDTC. After the
Cluster Group failover I made the SQL Group failover, wich
contains the Disk resources, SQL IP, SQL NetWorkName, SQL
Server, SQL Agent and SQL Fulltext resources.
The failover went without erros on the cluster admin
interface.

But on the SQL Error Log I found the following error:
Failed to obtain TransactionDispenserInterface:
XACT_E_TMNOTAVAILABLE

I tried to do distributed transaction on Query Analyzer
but I got the error:
Server: Msg 8501, Level 16, State 3, Line 1
MSDTC on server 'SQL' is unavailable.

I check the ClusterAdmin and MSDTC was on-line. I checked
the Event Viewer and I did not have any erros from MSDTC.

I know that the error message indicates that MSDTC is not
running. BUt, I need MSDTC running because we have linked
servers and other programs using distributed transactions.

I made another failover back from Node2 to Node1. I got
the error message XACT_E_TMNOTAVAILABLE again.

I made another failover from Node1 to Node2 and got the
error again. To try to solve the issue I rebooted Node1.

Node1 came back on line and I made the failover back from
Node2 to Node1. I got no errors on SQL error log. After
the reboot on Node1 I was able to do a distributed
transaction.

Im a little bit lost on that issue. That was not the first
time I made a failover but was the first time I got an
error from MSDTC. I dont know how to trace and solve that
issue. Any help would be appreciated.

Thanks.