DTC on ACTIVE ACTIVE cluster - urgent

Greetings, we have 4 node cluster setup. 3 nodes are active and one is
passive. As I understood, MS DTC will run only one node and hence will be
available to the SQL instances running on that node. Can I run DTC on
multiple nodes in a cluster?
I have created one DTC resource prior to the SQL install. I can not add
addional DTC resource. Our apps need to have DTC on most of the instances
which we can not put them on one node. Any suggestions?
Thanks in advance.
The single DTC instance will support all SQL instances in the cluster,
regardless of their current host node. You do not need a unique DTC
instance for each SQL instance.
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
I support the Professional Association for SQL Server
www.sqlpass.org
"Mintz" <Mintz@.discussions.microsoft.com> wrote in message
news:8DBA18AB-FA21-474D-B630-78F0CA8B910D@.microsoft.com...
> Greetings, we have 4 node cluster setup. 3 nodes are active and one is
> passive. As I understood, MS DTC will run only one node and hence will be
> available to the SQL instances running on that node. Can I run DTC on
> multiple nodes in a cluster?
> I have created one DTC resource prior to the SQL install. I can not add
> addional DTC resource. Our apps need to have DTC on most of the instances
> which we can not put them on one node. Any suggestions?
> Thanks in advance.
|||I agree with Geoff but the key to DTC working properly is to enable DTC for
network access. You can do this from Control panel/Add remove programs/add
remove components/Application Server. You have to do this on all nodes in
your cluster.
Also refer to the following articles
http://support.microsoft.com/default...b;en-us;301600
http://support.microsoft.com/default.aspx?kbid=817064
"Geoff N. Hiten" wrote:

> The single DTC instance will support all SQL instances in the cluster,
> regardless of their current host node. You do not need a unique DTC
> instance for each SQL instance.
> --
> Geoff N. Hiten
> Microsoft SQL Server MVP
> Senior Database Administrator
> Careerbuilder.com
> I support the Professional Association for SQL Server
> www.sqlpass.org
> "Mintz" <Mintz@.discussions.microsoft.com> wrote in message
> news:8DBA18AB-FA21-474D-B630-78F0CA8B910D@.microsoft.com...
>
>
|||i stuck at step 4. so my questions are
1. do i need an separate IP address? can i use the ip in cluster group
2. for physical disk, do i have to create another physical disk which
is shared by both nodes? can i use drive "Q:\"?
right now i did not follow the doc and created MSDTC in cluster group
using ip, physical disk and network name in that group (created
automatically). only one node can see msdtc which is not what i
expect.
thanks,
jj
"Rony Thomas" <rony_p_thomas@.hotmail.com> wrote in message news:<4C07737F-248A-42DE-87DA-F1D1590C44E8@.microsoft.com>...[vbcol=seagreen]
> I agree with Geoff but the key to DTC working properly is to enable DTC for
> network access. You can do this from Control panel/Add remove programs/add
> remove components/Application Server. You have to do this on all nodes in
> your cluster.
> Also refer to the following articles
> http://support.microsoft.com/default...b;en-us;301600
> http://support.microsoft.com/default.aspx?kbid=817064
>
> "Geoff N. Hiten" wrote:
|||try creating another group with resources for DTC and make sure you enable
network access
"jj" wrote:

> i stuck at step 4. so my questions are
> 1. do i need an separate IP address? can i use the ip in cluster group
> 2. for physical disk, do i have to create another physical disk which
> is shared by both nodes? can i use drive "Q:\"?
> right now i did not follow the doc and created MSDTC in cluster group
> using ip, physical disk and network name in that group (created
> automatically). only one node can see msdtc which is not what i
> expect.
> thanks,
> jj
> "Rony Thomas" <rony_p_thomas@.hotmail.com> wrote in message news:<4C07737F-248A-42DE-87DA-F1D1590C44E8@.microsoft.com>...
>