DTC in multiple instance cluster

Giganews Newsgroups
Subject: DTC in multiple instance cluster
Posted by:  Bjørn (Bj…@discussions.microsoft.com)
Date: Thu, 22 Feb 2007

WE have a 2 node win 2k3 x64 cluster (also x86 clusters with same problem)
with 2 instanses of SQL 2005 x64 and the MSDTC resource  in the admin.
cluster group (quorum group).
This is a active/passive cluster, all 3 groups/vir. servers on same node.

The problem appears when one of the SQL servers fail over to the other node.
Then the MSDTC transactions fail on this sql server.
Result = we have to manually fail over the MSDTC resource/group also.

I have read about a DTC proxy but how do I get this to work ?

Bjørn

Replies