Pages

Tuesday, July 5, 2005

MSDTC Failing in a Cluster

I worked hard this morning in Google looking for the answer to this. I found one that got me close but I had to change things up enough that I am reposting it here....

This is on Windows 2003 Enterprise for SQL Cluster. I tried to install MSDTC and it kept giving me an error...

Event ID: 4389 Source: MSTDC Client

MS DTC setup failed to populate the shared cluster registry. The DTC resource will not be able to come online.Error Specifics: d:\srvrtm\com\complus\dtc\shared\mtxclu\mtxclusetuphelper.cpp:120, Pid: 1296, CmdLine: "C:\WINDOWS\cluster\resrcmon.exe" -e 1012 -m 1252 -p 1672


After much pain, here is what I did...

Delete the DTC resource
Delete MSDTC shared folder from the quorum disk
On Node 1:
* Stop Cluster service
* Remove Enable network DTC access
* Run msdtc -uninstall
* Verify success in event log
* Delete registry keys:
HKEY_CLASSES_ROOT\CID
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSDTC
HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\MSDTC
* Evict Node1 from cluster.
* Reboot
* Reinstall Enable network DTC access
* Add Node1 to Cluster
* Fail everything over to Node1
* Create MSDTC resource
Node 2
* Stop Cluster service
* Evict node from cluster
* Remove Enable network DTC access
* Run msdtc -uninstall
* Verify success in event log
* Delete registry keys
HKEY_CLASSES_ROOT\CID
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSDTC
HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\MSDTC
* Reboot
* Reinstall Enable network DTC access
* Verify service started, registry keys created
* Rejoin cluster
Then fail the cluster group over to the second node to verify that the DTC
resource comes online successfully on the second node. After that, reboot
both servers and verify that the resource would fail over properly to both
nodes with the rest of the group.