Hi,

Can I put the MSDTC resource in Defaul Cluster Group ? I dont have available
disk to it.

thanks,
Rubens

Yes, you can put it in this group, but this goes against best practices. You
might want to consider unchecking the "affect the group" paramter for this
resource so a failure of this resource does not kill your cluster group.

Regards,
John

"Rubens Luque Sanches Jr." <rubensluque (AT) yahoo (DOT) com.br> wrote

If one node fail,can msdtc resource automatically move to another node?

Could you tell me more information about following line?
You might want to consider unchecking the "affect the group" paramter for
this resource so a failure of this resource does not kill your cluster
group.



"John Toner [MVP]" <jtoner (AT) DIE (DOT) SPAM.DIE.mvps.org> дÈëÏûÏ¢ÐÂÎÅ:%23i%23CfY$HFHA.588 (AT) TK2MSFTNGP15 (DOT) phx.gbl...

Yes, please read through the following KB article for more details about
setting up MSDTC resource in the cluster.

http://support.microsoft.com/kb/301600
Regards,
John

"lv ming tong" <lmt (AT) taeco (DOT) com.diss> wrote

While SQL Server does not require MS DTC, MS DTC on a cluster is only
supported when clustered and it is recommended to cluster it.

When clustering MS DTC it is preferred to have it in its own group with its
own resources, your second choice should be to put it in the cluster group,
use the quorum disk and create MS DTC its own Network Name and IP Address
resources for your MSDTC resource to use and set that resources properties
not to affect the group.

Here are some KB articles on correctly setting this up:

301600 How to configure Microsoft Distributed Transaction Coordinator on a
http://support.microsoft.com/?id=301600

817064 How to enable network DTC access in Windows Server 2003
http://support.microsoft.com/?id=817064

Also this article which may be of interest:

817065 How To Enable Network COM Access in Windows Server 2003
http://support.microsoft.com/?id=817065

Dave Whitney
SQL Support