Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Is Distributed Transaction Coordinator (MSDTC) Service Required Expand / Collapse
Author
Message
Posted Tuesday, January 29, 2013 10:54 AM
SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Wednesday, May 22, 2013 8:43 AM
Points: 442, Visits: 620
Hi Folks

I have read where the MSDTC is required for a clustered sql server, but is it required for non-clusterd server ?

The powers that be have asked me to disable the service

Windows 2003 R2 X64
Microsoft SQL Server 2005 - 9.00.5069.00 (X64)
Developer Edition

Thanks
Jim
Post #1413197
Posted Monday, February 11, 2013 6:46 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Today @ 6:48 AM
Points: 1,288, Visits: 1,099
Hello,

Have a look here:-

http://msdn.microsoft.com/en-us/library/aa174499(v=sql.80).aspx

It should let you know whether or not you need to have the MSDTC service running.

Andrew
Post #1418387
Posted Monday, February 11, 2013 8:37 AM
SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Wednesday, May 22, 2013 8:43 AM
Points: 442, Visits: 620
Hi Andrew

thanks for the link


I found additional links in case someone else has questions:
http://blogs.msdn.com/b/sqlblog/archive/2006/10/06/msdtc-and-sql-server-on-a-cluster.aspx

What is MSDTC used for?
SQL Server 2005 requires MS DTC in the cluster for distributed queries and two-phase commit transactions, as well as for some replication functionality.

Should MSDTC be a clustered resource?
Microsoft only supports running MSDTC on cluster nodes as a clustered resource. We do not recommend or support running MSDTC in stand-alone mode on a cluster. Using MSDTC as a non-clustered resource on a Windows cluster is problematic. This configuration is problematic because transactions could be orphaned and you may experience data corruption if a cluster failover occurs

Jim
Post #1418479
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse