We ran into a pickle of an issue yesterday while configuring MSDTC for clustering in Windows Server 2003. Although DTC was installed, we were unable to configure the security options necessary to make this rexource work in the cluster as the MSDTC tab was missing.
We found bits and pieces scatterred throughout the community sites on this issue but here are the steps that solved our problem.
1. Use Registry Editor (Regedit.exe) to ensure that the following
registry keys have been deleted on both nodes, if they have not then
proceed in deleting them:
- HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Servic es\MSDTC
- HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSDTC (requires manual removal)
- HKEY_CLASSES_ROOT\CID
2. Delete the MSDTC folder either from the Quorum drive or whatever drive
it may be located on.
3. From the command prompt window and type "msdtc -install" (without
quotes), this should add the MSDTC resource back in to the Cluster Group.
4. Before bringing the MSDTC resource Online, open the properties of MSDTC
and on the Advanced change it to "Do not restart". Once completed, then
try to bring it Online.
The info was retrieved from this article:
http://forums.techarena.in/showthread.php?t=80099
I noticed Microsoft also has an article on this topic but if you don't know you actually need to do a recovery of MSDTC, you will not know to search for it. Here is the article.
http://support.microsoft.com/kb/294209