 | |
Re: DTC on ACTIVE ACTIVE cluster - urgent
microsoft.public.sqlserver.clustering microsoft.public.sqlserver.clustering
 |
| | Thread Tools | Display Modes |
#1
 
| |||
| |||
|
Re: DTC on ACTIVE ACTIVE cluster - urgent -
08-31-2004
, 10:14 AM
|
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. |
#2
| |||
| |||
|
|
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 (AT) discussions (DOT) microsoft.com> wrote in message news:8DBA18AB-FA21-474D-B630-78F0CA8B910D (AT) microsoft (DOT) 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. |
#3
| |||
| |||
|
|
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 (AT) hotmail (DOT) com> wrote 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 (AT) discussions (DOT) microsoft.com> wrote in message news:8DBA18AB-FA21-474D-B630-78F0CA8B910D (AT) microsoft (DOT) 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. |
|
« Previous Thread
|
Next Thread »
| Thread Tools | |
| Display Modes | |
Linear Mode
| |
Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.