MSDTC settings in a cluster.

Hi everyone,
I am new to this so any help will be much appreciated.
I have a problem running triggers between two SQL servers. I am running
Windows Server 2003 and SQL server 2000 SP4. I found Microsoft article
which pointed me to enable MSDTC by checking the Allow Outbound and
Allow Inbound checkboxes. My question is where do I set these boxes on
the cluster, on the nodes that make up the cluster or on both?
Thanks for your help!
Eugene.On the node that has control of the MSDTC resource. The cluster service take
care of replicating the setting to the other possible nodes.
Linchi
"Eugene" wrote:

> Hi everyone,
> I am new to this so any help will be much appreciated.
> I have a problem running triggers between two SQL servers. I am running
> Windows Server 2003 and SQL server 2000 SP4. I found Microsoft article
> which pointed me to enable MSDTC by checking the Allow Outbound and
> Allow Inbound checkboxes. My question is where do I set these boxes on
> the cluster, on the nodes that make up the cluster or on both?
> Thanks for your help!
> Eugene.
>|||Also in the cluster manager you can create the service to be handle by the
clusters nodes and you will have the setting on all notes just in case.
Santos Martinez,MCSE, MCDBA, MCTS
IT Community Staff of Puerto Rico
http://www.itcspr.org
"Linchi Shea" wrote:
[vbcol=seagreen]
> On the node that has control of the MSDTC resource. The cluster service ta
ke
> care of replicating the setting to the other possible nodes.
> Linchi
> "Eugene" wrote:
>