MSDTC Failing In A Cluster
Thursday, June 16, 2011 at 5:30AM I’m merrily working away on installing SQL 2008R2 on a bunch of new clusters. The SQL installs have gone fine and I’m getting set to install MSDTC, one for each SQL instance (read the awesome post by Cindy Gross on this).
The install of MSDTC went smoothly and it seemed very happy. Then I failed over the cluster…
MSDTC failed.
It wouldn’t restart.
I failed back to the original node and it wouldn’t start there either.
What’s the error?
I dumped the last few minutes of the cluster log by opening a dos box command prompt and running…
cluster log /gen /span:5
This dumps the last five minutes of cluster logs into C:\Windows\Cluster\cluster.log
I scrolled through to get to the MSDTC error piece:
INFO [RES] Physical Disk: Failed to get vol MP root for path \\?, status 123
ERR [RHS] Error 123 from ResourceControl for resource <instance>_MSDTC.
WARN [RCM] ResourceControl(STORAGE_IS_PATH_VALID) to <instance>_MSDTC returned 123.
