I need to add MSDTC service to an already running Windows 2000 ADV server
cluster (SP4) w/dual instances of SQL server installed. There are 3 disk
groups: Cluster group, Transaction and Data Warehouse.

I want to add the MSDTC service to the disk group called Transaction. Per Q
article 290624, when MSDTC is installed via the "comclust.exe" command it
installs in the first disk group going alphabetically in the order their
listed in Cluster Administrator if they contain a IP address resource,
Network Name resource and a Disk resource. All 3 groups contain these
requirements. So, if I install MSDTC it will install in the Cluster group
(the first group listed alphabetically). I don't want it there.

My Question: If I rename the cluster group "Transaction" to "Atransaction"
(added an "A" at the beginning so it becomes the first group listed
alphabetically) and I then install MSDTC via Comclust.exe will it install in
the Atransaction group? If so, I could then rename it back to "transaction"
and be done.

Is my logic correct? Does anyone have experience with this scenario?

TIA,

ML

Here are the instructions for moving DTC to another group. I don't believe
that simply renaming the groups will work, but I can't say I've tried doing
that way either. <g>

http://support.microsoft.com/default...&Product=sql2k

--
--Brian
(Please reply to the newsgroups only.)


"ml.net" <dont (AT) trustbill (DOT) com> wrote

Also, Microsoft has generally recommended leaving MSDTC in
its default group, which varies per the Windows OS
version. See http://support.microsoft.com/?id=254321.

I'm curious about any specific reason you may have for "I
don't want it there."

Linchi

What I would like to know if I can install a MSDTC
service in multiple groups. Why? I have a active active
cluster and the second node is running ok, but connecting
to an instance via COM+ on the second node fails because
of not running MSDTC. MSDTC is running on the first
node...

Since MSDTC is clustered, applications running on either node should be
able to access it, there shouldn't be a need to have multiple DTCs.

Cindy Gross, MCDBA, MCSE
http://cindygross.tripod.com
This posting is provided "AS IS" with no warranties, and confers no rights.

It is incorrect to have multiple MSDTC resources in the cluster. The single
MSDTC resource should be accessible from all nodes in the cluster. The
MSDTC configuration directs DtcGetTransactionManager calls to the instance
of the MSDTC serivce running on the node where the MSDTC resource is online.

Jim Carley (MSFT)

"Cindy Gross (MSFT)" <cgross (AT) online (DOT) microsoft.com> wrote