jhrabovsky
asked on
Red MSDTC icon in SQL Management Studio
In SQL Management Studio I can see the MSDTC is not running (red). But it is and works well! What should I do to see the green MSDTC? Is it bug of Management studio or configuration?
We have W2k3 cluster with SQL 2005 x64 SP2. MSDTC is in Quorum cluster group. SQL server is installed in its cluster group. MSDTC and SQL are on different nodes.
Thanks a lot
Jiri Hrabovsky
We have W2k3 cluster with SQL 2005 x64 SP2. MSDTC is in Quorum cluster group. SQL server is installed in its cluster group. MSDTC and SQL are on different nodes.
Thanks a lot
Jiri Hrabovsky
In services Find the Distributed Transaction Coordinator (msdtc.exe) and Start this service
ASKER
Hi Imran,
the service MSDTC is started and working.
Icon is green when MSDTC group is on the same node as SQL group. The icon became red when MSDTC is moved to the other node. But should be green in both cases.
the service MSDTC is started and working.
Icon is green when MSDTC group is on the same node as SQL group. The icon became red when MSDTC is moved to the other node. But should be green in both cases.
MSDTC and SQL Integration should be on both nodes and the service should be started on the active node.
ASKER
So, we have reinstalled whole cluster with Win2003 Enterprise x64 SP2 (both nodes) and installed SQL2005 Enterprise x64 SP2 again and there is the same issue.
MSDTC resource is created as cluster resource in cluster group and it is now on node1 and it is running
SQL virtual server is installed to node1 and node2
When SQL is on node1 in Mmanagement 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.
So I really don't know where could be a problem if in SQL Management Studio or it is "by default"
Thank you.
J.
MSDTC resource is created as cluster resource in cluster group and it is now on node1 and it is running
SQL virtual server is installed to node1 and node2
When SQL is on node1 in Mmanagement 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.
So I really don't know where could be a problem if in SQL Management Studio or it is "by default"
Thank you.
J.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.