Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion Groups
DB Engine
SQL ServerMSDESQL Server CE
Services
Analysis (Data Mining)Analysis (OLAP)DTSIntegration ServicesNotification ServicesReporting Services
Programming
CLRConnectivitySQLXML
Other Technologies
ClusteringEnglish QueryFull-Text SearchReplicationService Broker
General
Data WarehousingPerformanceSecuritySetupSQL Server ToolsOther SQL Server Topics
DirectoryUser Groups
Related Topics
MS AccessOther DB ProductsMS Server Products.NET DevelopmentVB DevelopmentJava DevelopmentMore Topics ...

SQL Server Forum / Other Technologies / Clustering / January 2006

Tip: Looking for answers? Try searching our database.

Is DTC required in a SQL 2000/Windows 2003 cluster ?

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
SteveO - 27 Jan 2006 09:16 GMT
Hi,

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

Thanks
Michael Hotek - 27 Jan 2006 17:12 GMT
Yes.  You will always configured DTC into the cluster.  There are other
services which will use it.

Signature

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.

> Hi,
>
> If the SQL environment is not going to use distributed transactions, is it
> still necessary to configure a DTC resource on the cluster ?
>
> Thanks
Linchi Shea - 28 Jan 2006 05:56 GMT
I hate to nitpick. But technically, you don't have to if you don't need it.

Linchi

> Yes.  You will always configured DTC into the cluster.  There are other
> services which will use it.
[quoted text clipped - 6 lines]
>>
>> Thanks
Michael Hotek - 28 Jan 2006 06:09 GMT
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.

Signature

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.

>I hate to nitpick. But technically, you don't have to if you don't need it.
>
[quoted text clipped - 10 lines]
>>>
>>> Thanks
Rodney R. Fournier [MVP] - 28 Jan 2006 06:39 GMT
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

> 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
[quoted text clipped - 24 lines]
>>>>
>>>> Thanks
Geoff N. Hiten - 27 Jan 2006 17:24 GMT
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.

Signature

Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP

> Hi,
>
> If the SQL environment is not going to use distributed transactions, is it
> still necessary to configure a DTC resource on the cluster ?
>
> Thanks
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2009 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.