Showing posts with label win2000. Show all posts
Showing posts with label win2000. Show all posts

Monday, February 20, 2012

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.