December 11, 2008 at 4:59 pm
Hi,
We have a active\active\passive cluster setup of sql server 2005EE x64 on windows 2003 x64.
currently MSDTC is owned by node1 and the servce is running fine.On node2 and node3 msdtc is not running. when I started the msdtc on node 2,3 it giving me the below error in event viewer.
MS DTC cannot start on this cluster node because the MS DTC resource is currently owned by another node in the cluster. Error Specifics: d:t\com\complus\dtc\shared\mtxclu\mtxclusetuphelper.cpp:584, Pid: 7040, CmdLine: C:\WINDOWS\system32\msdtc.
In spotlight, We are getting an alram saying that DTC is installed but running on node2 and node3.
So How can we run the dtc on all nodes?orif it runs on the node which owns it what will happen on other nodes if we ran remote procedures and use linked servers?
December 11, 2008 at 8:22 pm
You only run MSDTC on one machine, it handles things for the whole cluster, so there is no need to try and get it to start up on the other nodes.
Just make sure that MSDTC is a clustered resource and able to failover between nodes.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply