Groups | Blog | Home
all groups > sql server clustering > january 2006 >

sql server clustering : Is DTC required in a SQL 2000/Windows 2003 cluster ?


SteveO
1/27/2006 1:16:02 AM
Hi,

If the SQL environment is not going to use distributed transactions, is it
still necessary to configure a DTC resource on the cluster ?

Michael Hotek
1/27/2006 11:12:33 AM
Yes. You will always configured DTC into the cluster. There are other
services which will use it.

--
Mike
http://www.solidqualitylearning.com
Disclaimer: This communication is an original work and represents my sole
views on the subject. It does not represent the views of any other person
or entity either by inference or direct reference.

[quoted text, click to view]

Geoff N. Hiten
1/27/2006 12:24:24 PM
In theory, you can run SQL 2000 clustered without DTC. In practice, it can
limit functionality. I generally configure a DTC resource, just to simplify
installation and maintenance.

--
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP


[quoted text, click to view]

Michael Hotek
1/28/2006 12:09:06 AM
Well, you'd have to take that up with the failover clustering team. It is
their explicit recommendation for ALL clusters that you will install a
failover cluster instance in.

Not having it there is going to cause several errors during the upgrade as
well as throwing additional errors during a fresh install. I haven't tested
enough permutations to say whether it is needed or not, so at this point, I
tend to trust the people who have spent thousands of hours testing hundreds
of different configurations. They know the code a lot better than me since
they wrote it. If that's the recommendation, I'm sticking into in this
case, because I have no way of proving that it shouldn't be followed.

--
Mike
http://www.solidqualitylearning.com
Disclaimer: This communication is an original work and represents my sole
views on the subject. It does not represent the views of any other person
or entity either by inference or direct reference.


[quoted text, click to view]


Rodney R. Fournier [MVP]
1/28/2006 12:39:41 AM
I have 15 SQL Clusters in Production without MSDTC in the cluster, the local
service is disabled. No issues. Our application simply does not use it!

Cheers,

Rod

MVP - Windows Server - Clustering
http://www.nw-america.com - Clustering Website
http://www.msmvps.com/clustering - Blog
http://www.clusterhelp.com - Cluster Training


[quoted text, click to view]

Linchi Shea
1/28/2006 12:56:03 AM
I hate to nitpick. But technically, you don't have to if you don't need it.

Linchi

[quoted text, click to view]

AddThis Social Bookmark Button