Showing posts with label msdtc. Show all posts
Showing posts with label msdtc. Show all posts

Friday, March 30, 2012

Installing MSDTC Resource after installing SQL Server 2000 cluster

Is it possible to install and configure the MSDTC resource in a SQL Server 2000 cluster after SQL is installed and running?

When I recently went through a rebuild of my cluster, I forgot to install the resource before installing SQL Server. Now, if I install and bring online the MSDTC resource the SQL disk groups will not fail over correctly. The SQL Server resource will not come online.

Thanks in advance for any help. I would really like to avoid rebuilding again.

Andy

I am not an expert on clusters but you might want to check out the following article

http://support.microsoft.com/kb/294209/en-us

Michelle

sql