Post reply

Is Distributed Transaction Coordinator (MSDTC) Service Required

  • January 29, 2013 at 10:55 am

    #269838

    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

  • February 11, 2013 at 6:46 am

    #1586525

    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

  • February 11, 2013 at 8:37 am

    #1586611

    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

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply