Distributed Transaction Error on SQL 7.0 Cluster

[Voldi]

Hi all..

(FYI, I have posted this problem in microsoft.public.sqlserver.clustering, but so far I have not receive any reply.)

Recently I installed a SQL server running on a Win 2000 clustering system. I followed the steps from Microsoft to install it (Q219264 INF: Order of Installation for SQL Server 7.0 Clustering setup.). The configuration of the clustering system is Active/Passive.

Our web server with the components that are going to access the SQL server is across Firewall, so I limit the range of TCP ports for DCOM to use, by adding these entries to my SQL sever and Web server registry :

HKEY_LOCAL_MACHINE\Software\Microsoft\Rpc\Internet
Ports (REG_MULTI_SZ) 8000-8100
PortsInternetAvailable (REG_SZ) "Y"
UseInternetPorts (REG_SZ) "Y"

I use comclust.exe to enable the MSDTC to failover, and I installed the SQL Server after that. Everything seems to be okay, all the cluster resources can failover nicely.

But when the transactional components on the web server tries to connect to the SQL Server, I found a "Distributed Transaction Error" on the Event Viewer. I checked on the firewall, there's no port blocking, and non-transactional components are all okay.

I hope that one of you know what's wrong and can help me on this problems.

Many Thanks...

Voldi.

 

[Guest_imported]

Microsoft Distributed Transaction server service should be running on both MTS server machine and SQL Server machine if MTS and SQL 7 are running on different machines.