I run a query through Query Analyzer against a database on
a SQL cluster and get the following error

Server: Msg 8501, Level 16, State 3, Line 1
MSDTC on server 'MSCS01SQL2K' is unavailable.

Both the Cluster Administrator Console and the Service
Control Manager on the cluster show that MS DTC is
online/started respectively. What could the problem be?
Does the order in which the SQL Server and MS DTC
resources are brought online make a difference?

Any assistance would be appreciated.

Clive,

Thanks for your reply.

When SQL Server starts up the following does appear in the log file

2003-07-02 08:35:41.12 server Attempting to initialize Distributed
Transaction Coordinator.
2003-07-02 08:35:51.63 server Resource Manager Creation Failed:
XACT_E_CONNECTION_DOWN

MSDTC is in a resource group called Test1 which contains the following
Resources

Disk G Physical Disk
MSDTC Generic Service
MSDTC IP Address IP Address
MSDTC Network Name Network Name
SQL IP Address IP Address
SQL Network Name Network Name
SQL Server SQL Server
SQL Server Agent SQL Server Agent
SQL Server Fulltext Microsoft Search Service Instance

Regards

Ian Robinson



*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

OK,
I guess this is SQL2000,
As a test take all the resources off-line then bring them back online
starting with MSDTC then check the SQL error log again to see if it still
reports the error,
it is a little unusual to put MSDTC in the same group as SQL, usually I
would expect to see it in the cluster group or on its own group. As a test
you could put a dependancy for MSDTC within the SQL resoruce.

Regards,
Clive Challinor [MSFT]
This posting is provided "AS IS" with no warranties, and confers no rights.

Clive,

Thanks for your input. I figured it out yesterday. I think something
went wrong in the upgrade from SQL 7.0 to SQL 2000 and MS DTC wasn't
installed properly. If you look at the list of resources in my last
mail the MS DTC was a generic service and not a Distributed Transaction
Coordinator resource type. I followed Knowledge Base article 294209 and
rebuilt MS DTC and it all seems to be OK now. Once again, thanks for
your input.

Regards

Ian Robinson



*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!