Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
jspatz
Starting Member
15 Posts |
 Posted - 2009-04-30 : 09:59:17
|
| I am wondering if I missed a step or am doing something wrong. We have two mS Server 2003 R2 EEx64 servers clustered, and we are trying to setup Active/Active. However Everytime we start up an instance on the active server that doesn't have the MSDTC Resource, Distributed Transaction Coordinator shows as "stopped" in SSMS. When I move the group back to Node A with the MSDTC resource, it shows green, when I move the Cluster Group (yes I know not best practice to have msdtc in cluster group) to Node B, DTC shows green on Node B instances but red on Node A instances. So is this because SSMS isn't being truly cluster aware, or am I missing a step somewhere to have this working properly? Enable network DTC access is checked on both nodes in windows components.. I have checked msdn, and I have seen other people experiencing similar issues but I have never seen a resolution.Thanks for all replies! |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
jspatz
Starting Member
15 Posts |
Posted - 2009-04-30 : 13:54:18
|
| Thanks Tara .. thats the reaffirmation I was hoping for :) |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
|
|
|
MSDTC and Clustering Question for Active/Active Co