so although I have read a few things in both directions, it seems I need the
MSDTC for a SQL cluster. When I create it I have to assign dependencies to a
drive and name.
By default, when a cluster is built there is "group 0" which is my share
drive and "cluster group" which has the quorum and name/ip

How should I set the dependencies for this? What I have done is used the
"cluster group" and use the quorum and cluster name. dont seem to have any
problems doing this, but it just seems wrong.

what is the preferred way to configure this?


thanks
Justin

If you are not intending on doing many distributed transactions, then you
can leave the DTC in the cluster group. However, if you will be doing a lot
of distributed txns, then you'll want to create a separate group, containing
a disk and IP resource, as well as the DTC resource.

--
Tom

----------------------------------------------------
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
SQL Server MVP
Toronto, ON Canada
https://mvp.support.microsoft.com/profile/Tom.Moreau


"Justin Rich" <jrich523 (AT) yahoo (DOT) spam.com> wrote

so although I have read a few things in both directions, it seems I need the
MSDTC for a SQL cluster. When I create it I have to assign dependencies to a
drive and name.
By default, when a cluster is built there is "group 0" which is my share
drive and "cluster group" which has the quorum and name/ip

How should I set the dependencies for this? What I have done is used the
"cluster group" and use the quorum and cluster name. dont seem to have any
problems doing this, but it just seems wrong.

what is the preferred way to configure this?


thanks
Justin

If you are not intending on doing many distributed transactions, then you
can leave the DTC in the cluster group. However, if you will be doing a lot
of distributed txns, then you'll want to create a separate group, containing
a disk and IP resource, as well as the DTC resource.

--
Tom

----------------------------------------------------
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
SQL Server MVP
Toronto, ON Canada
https://mvp.support.microsoft.com/profile/Tom.Moreau


"Justin Rich" <jrich523 (AT) yahoo (DOT) spam.com> wrote

so although I have read a few things in both directions, it seems I need the
MSDTC for a SQL cluster. When I create it I have to assign dependencies to a
drive and name.
By default, when a cluster is built there is "group 0" which is my share
drive and "cluster group" which has the quorum and name/ip

How should I set the dependencies for this? What I have done is used the
"cluster group" and use the quorum and cluster name. dont seem to have any
problems doing this, but it just seems wrong.

what is the preferred way to configure this?


thanks
Justin

If you are not intending on doing many distributed transactions, then you
can leave the DTC in the cluster group. However, if you will be doing a lot
of distributed txns, then you'll want to create a separate group, containing
a disk and IP resource, as well as the DTC resource.

--
Tom

----------------------------------------------------
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
SQL Server MVP
Toronto, ON Canada
https://mvp.support.microsoft.com/profile/Tom.Moreau


"Justin Rich" <jrich523 (AT) yahoo (DOT) spam.com> wrote

so although I have read a few things in both directions, it seems I need the
MSDTC for a SQL cluster. When I create it I have to assign dependencies to a
drive and name.
By default, when a cluster is built there is "group 0" which is my share
drive and "cluster group" which has the quorum and name/ip

How should I set the dependencies for this? What I have done is used the
"cluster group" and use the quorum and cluster name. dont seem to have any
problems doing this, but it just seems wrong.

what is the preferred way to configure this?


thanks
Justin

If you are not intending on doing many distributed transactions, then you
can leave the DTC in the cluster group. However, if you will be doing a lot
of distributed txns, then you'll want to create a separate group, containing
a disk and IP resource, as well as the DTC resource.

--
Tom

----------------------------------------------------
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
SQL Server MVP
Toronto, ON Canada
https://mvp.support.microsoft.com/profile/Tom.Moreau


"Justin Rich" <jrich523 (AT) yahoo (DOT) spam.com> wrote

so although I have read a few things in both directions, it seems I need the
MSDTC for a SQL cluster. When I create it I have to assign dependencies to a
drive and name.
By default, when a cluster is built there is "group 0" which is my share
drive and "cluster group" which has the quorum and name/ip

How should I set the dependencies for this? What I have done is used the
"cluster group" and use the quorum and cluster name. dont seem to have any
problems doing this, but it just seems wrong.

what is the preferred way to configure this?


thanks
Justin

If you are not intending on doing many distributed transactions, then you
can leave the DTC in the cluster group. However, if you will be doing a lot
of distributed txns, then you'll want to create a separate group, containing
a disk and IP resource, as well as the DTC resource.

--
Tom

----------------------------------------------------
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
SQL Server MVP
Toronto, ON Canada
https://mvp.support.microsoft.com/profile/Tom.Moreau


"Justin Rich" <jrich523 (AT) yahoo (DOT) spam.com> wrote

so although I have read a few things in both directions, it seems I need the
MSDTC for a SQL cluster. When I create it I have to assign dependencies to a
drive and name.
By default, when a cluster is built there is "group 0" which is my share
drive and "cluster group" which has the quorum and name/ip

How should I set the dependencies for this? What I have done is used the
"cluster group" and use the quorum and cluster name. dont seem to have any
problems doing this, but it just seems wrong.

what is the preferred way to configure this?


thanks
Justin

If you are not intending on doing many distributed transactions, then you
can leave the DTC in the cluster group. However, if you will be doing a lot
of distributed txns, then you'll want to create a separate group, containing
a disk and IP resource, as well as the DTC resource.

--
Tom

----------------------------------------------------
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
SQL Server MVP
Toronto, ON Canada
https://mvp.support.microsoft.com/profile/Tom.Moreau


"Justin Rich" <jrich523 (AT) yahoo (DOT) spam.com> wrote

so although I have read a few things in both directions, it seems I need the
MSDTC for a SQL cluster. When I create it I have to assign dependencies to a
drive and name.
By default, when a cluster is built there is "group 0" which is my share
drive and "cluster group" which has the quorum and name/ip

How should I set the dependencies for this? What I have done is used the
"cluster group" and use the quorum and cluster name. dont seem to have any
problems doing this, but it just seems wrong.

what is the preferred way to configure this?


thanks
Justin

If you are not intending on doing many distributed transactions, then you
can leave the DTC in the cluster group. However, if you will be doing a lot
of distributed txns, then you'll want to create a separate group, containing
a disk and IP resource, as well as the DTC resource.

--
Tom

----------------------------------------------------
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
SQL Server MVP
Toronto, ON Canada
https://mvp.support.microsoft.com/profile/Tom.Moreau


"Justin Rich" <jrich523 (AT) yahoo (DOT) spam.com> wrote

so although I have read a few things in both directions, it seems I need the
MSDTC for a SQL cluster. When I create it I have to assign dependencies to a
drive and name.
By default, when a cluster is built there is "group 0" which is my share
drive and "cluster group" which has the quorum and name/ip

How should I set the dependencies for this? What I have done is used the
"cluster group" and use the quorum and cluster name. dont seem to have any
problems doing this, but it just seems wrong.

what is the preferred way to configure this?


thanks
Justin

If you are not intending on doing many distributed transactions, then you
can leave the DTC in the cluster group. However, if you will be doing a lot
of distributed txns, then you'll want to create a separate group, containing
a disk and IP resource, as well as the DTC resource.

--
Tom

----------------------------------------------------
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
SQL Server MVP
Toronto, ON Canada
https://mvp.support.microsoft.com/profile/Tom.Moreau


"Justin Rich" <jrich523 (AT) yahoo (DOT) spam.com> wrote

so although I have read a few things in both directions, it seems I need the
MSDTC for a SQL cluster. When I create it I have to assign dependencies to a
drive and name.
By default, when a cluster is built there is "group 0" which is my share
drive and "cluster group" which has the quorum and name/ip

How should I set the dependencies for this? What I have done is used the
"cluster group" and use the quorum and cluster name. dont seem to have any
problems doing this, but it just seems wrong.

what is the preferred way to configure this?


thanks
Justin

If you are not intending on doing many distributed transactions, then you
can leave the DTC in the cluster group. However, if you will be doing a lot
of distributed txns, then you'll want to create a separate group, containing
a disk and IP resource, as well as the DTC resource.

--
Tom

----------------------------------------------------
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
SQL Server MVP
Toronto, ON Canada
https://mvp.support.microsoft.com/profile/Tom.Moreau


"Justin Rich" <jrich523 (AT) yahoo (DOT) spam.com> wrote

so although I have read a few things in both directions, it seems I need the
MSDTC for a SQL cluster. When I create it I have to assign dependencies to a
drive and name.
By default, when a cluster is built there is "group 0" which is my share
drive and "cluster group" which has the quorum and name/ip

How should I set the dependencies for this? What I have done is used the
"cluster group" and use the quorum and cluster name. dont seem to have any
problems doing this, but it just seems wrong.

what is the preferred way to configure this?


thanks
Justin