Active/Passive SQL2005 Ent x64 x MSDTC -- sql server clustering

Jiri
8/30/2007 1:48:00 AM

Hi All,

I have a question, we have 2 node cluster Win2003 R2 Enterprise with SP2 ,
SQL Server virtual is installed on cluster. It is SQL2005 Enterprise x64 with
SP2.

MSDTC resource is created as cluster resource in cluster group on node1 and
it is running, one SQL virtual server is installed on cluster (both nodes are
owners).
In Management studio in section Management there is a Distributed
Transaction Coordinator icon.

When SQL is on node1 in Management studio it seems all is OK (icon is
green), but when I move SQL to node2 and MSDTC is still on node1 in
Management studio there is red icon and it seems that MSDTC is offline, but
MSDTC is running well on node1.
The same situation is when I move the cluster group (with MSDTC) to node2
and SQL remains on node1, in Management studio there is red icon again, but
MSDTC is running well on node2.

The green icon is only when both (cluster and SQL) groups are together on
one node (not matter which node, it is same on node1 or node2)
So I really don't know where could be a problem if in SQL Management Studio
or it is "by default"

Is it normal ?

Ayad Shammout
8/31/2007 12:10:41 AM

This is normal behavior. If MSDTC is active on node1 and SQL is active on
node2, you will see red icon next to DTC because the DTC service is not
running on the same node as SQL. If both DTC and SQL services are active on
the same node, then you will see green icon in SMSS.

Ayad Shammout

[quoted text, click to view]

sql server clustering : Active/Passive SQL2005 Ent x64 x MSDTC