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?
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...