03-04-2011 06:01 AM
Hi,
I have a three node cluster (Win2K8R2) with 3 instances of SQL Server 2008 (each on one node of the cluster.) Two of these instances need to participate in MSDTC communication (I believe that one sends to the other.) In reading the agent guide it mentions:
Solved! Go to Solution.
03-04-2011 07:25 AM
Hi Sheldonl,
The MSDTC doc is a little confusing. In your case, I would setup a seperate MSDTC service group that can failover to all three nodes in the cluster. That is it. You don't need to do anything else.
If you were going to run MSDTC in another cluster than your SQL cluster, or you were going to use a standalone MSDTC server out side of the SQL cluster, then you would need to configure the MSDTC client via the SFW-HA SQL wizard.
Let us know if you have any other questions.
Thanks,
Wally
03-04-2011 07:25 AM
Hi Sheldonl,
The MSDTC doc is a little confusing. In your case, I would setup a seperate MSDTC service group that can failover to all three nodes in the cluster. That is it. You don't need to do anything else.
If you were going to run MSDTC in another cluster than your SQL cluster, or you were going to use a standalone MSDTC server out side of the SQL cluster, then you would need to configure the MSDTC client via the SFW-HA SQL wizard.
Let us know if you have any other questions.
Thanks,
Wally
03-04-2011 07:36 AM
Thank you so much Wally! I was really concerned about this!
Cheers,
Sheldon.