MSDTC in sql install.

Hi,
i need to install sql 2000 cluster on win 2003.
i have all the maluals but something is not clear for me .
do i need to install MSDTC before !!! the sql set up via comclust.exe
on each node (like i wrote the OS is win2k3)
thank`s,
Ronald.
In previous versions of Windows, the COMCLUST.EXE utility had to be run on
each node in order to cluster the MSDTC. Under Windows 2003, it is now
possible to configure MSDTC as a resource type, assign it to a resource
group, and have it automatically configured on all cluster nodes
COMCLUST.EXE falls away.
Regards
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"w2system5" <none@.none.com> wrote in message
news:cph3em$nvb$1@.news2.netvision.net.il...
> Hi,
> i need to install sql 2000 cluster on win 2003.
> i have all the maluals but something is not clear for me .
> do i need to install MSDTC before !!! the sql set up via comclust.exe
> on each node (like i wrote the OS is win2k3)
> thank`s,
> Ronald.
>
|||First of all do you even need MSDTC? Do you have any applications written to
use it?
If so, do 817064 BEFORE you install clustering.
Then 301600 BEFORE you install SQL.
Also, Microsoft recommends to run MSDTC and SQL on the same node.
For complete detail see the revised
http://msmvps.com/clustering/archive.../25/16672.aspx blog post.
Cheers,
Rod
MVP - Windows Server - Clustering
http://www.nw-america.com - Clustering
http://www.msmvps.com/clustering - Blog
"w2system5" <none@.none.com> wrote in message
news:cph3em$nvb$1@.news2.netvision.net.il...
> Hi,
> i need to install sql 2000 cluster on win 2003.
> i have all the maluals but something is not clear for me .
> do i need to install MSDTC before !!! the sql set up via comclust.exe
> on each node (like i wrote the OS is win2k3)
> thank`s,
> Ronald.
>
|||> Also, Microsoft recommends to run MSDTC and SQL on the same node.
Really? What happens if you have two SQL instances running on two different
nodes?
Linchi
"Rodney R. Fournier [MVP]" <rod@.die.spam.die.nw-america.com> wrote in
message news:OJUNzLG4EHA.1564@.TK2MSFTNGP09.phx.gbl...
> First of all do you even need MSDTC? Do you have any applications written
to[vbcol=seagreen]
> use it?
> If so, do 817064 BEFORE you install clustering.
> Then 301600 BEFORE you install SQL.
> Also, Microsoft recommends to run MSDTC and SQL on the same node.
> For complete detail see the revised
> http://msmvps.com/clustering/archive.../25/16672.aspx blog post.
> Cheers,
> Rod
> MVP - Windows Server - Clustering
> http://www.nw-america.com - Clustering
> http://www.msmvps.com/clustering - Blog
> "w2system5" <none@.none.com> wrote in message
> news:cph3em$nvb$1@.news2.netvision.net.il...
comclust.exe
>
|||Good point. I did think to ask support that question when I had them on the
line. I was only running one instance. Hmm. I will tell you this, I tested
our config with MSDTC running on one node and SQL on the other, everything
worked great
Rod
"Linchi Shea" <linchi_shea@.NOSPAM.ml.com> wrote in message
news:OGa111l4EHA.2180@.TK2MSFTNGP10.phx.gbl...
> Really? What happens if you have two SQL instances running on two
> different
> nodes?
> Linchi
> "Rodney R. Fournier [MVP]" <rod@.die.spam.die.nw-america.com> wrote in
> message news:OJUNzLG4EHA.1564@.TK2MSFTNGP09.phx.gbl...
> to
> comclust.exe
>
|||My understanding is that when you cluster MSDTC it installs DTC re-directs
on all nodes to the clustered MSDTC so it doesn't matter which node it runs
on.
Otherwise MSDTC would HAVE to be in the same group as the SQL Server
instance, which it doesn't.
Christian Bolton
Microsoft
"Rodney R. Fournier [MVP]" <rod@.die.spam.die.nw-america.com> wrote in
message news:eDYSemm4EHA.2192@.TK2MSFTNGP14.phx.gbl...
> Good point. I did think to ask support that question when I had them on
> the line. I was only running one instance. Hmm. I will tell you this, I
> tested our config with MSDTC running on one node and SQL on the other,
> everything worked great
> Rod
> "Linchi Shea" <linchi_shea@.NOSPAM.ml.com> wrote in message
> news:OGa111l4EHA.2180@.TK2MSFTNGP10.phx.gbl...
>