I've read and heard some conflicting information about the best method for
setting up a MSDTC resource in a cluster. I am running MSSQL 2000 SP3a and
Windows 2003. 2 node cluster with currently only once instance of MSSQL
with a great chance of growing.

A few questions I have:
Should the resource be in the cluster group or the virtual server group?
What else does it need, ip address, name...?
If it's not yet being used, is it safe to have it on the quorum drive
(currently 1GB RAID1)?
Has anyone found a white paper specific to Win2k3, MSSQL2k and MSDTC?

Thanks,

Joseph

Hi,

I've found this paper
http://support.microsoft.com/default...b;en-us;301600

It suggests to put MSDTC in its own group with its storage resource(disk).
On other hand if that is not possible you can put it in a group with disk.

Anyway I would mess with quorum drive, so I would put it in a Virtual Server
group.

Danijel

"Joseph" <Joseph (AT) discussions (DOT) microsoft.com> wrote