MSDTC and SQL2000 clustered

Hi,

I'm in doubt about an installation of SQL Server 2000 (single istance hot standby) on a Win2000 Advanced Server 2 nodes cluster (2 processors per node).

I suppose MSDTC was not activated during SQL2000 setup.

Is it absolutely necessary?
Can I have problems?

In what case is it necessary?

Many thanks?Originally posted by nisant
Hi,

I'm in doubt about an installation of SQL Server 2000 (single istance hot standby) on a Win2000 Advanced Server 2 nodes cluster (2 processors per node).

I suppose MSDTC was not activated during SQL2000 setup.

Is it absolutely necessary?
Can I have problems?

In what case is it necessary?

Many thanks?

I had a problem in an active\active failover installation. MSDTC was not configured and was causing problems with the fail over function. Once I configured it as a shared resource, everything seemed fine. Hope this helps...|||True, make sure MSDTC has been started and working whenever any distributed transactions are in process.

For information refer to DB journal (http://www.databasejournal.com/features/mssql/article.php/1690901) article.