Home Forums SQL Server 2005 SQL Server Newbies Is Distributed Transaction Coordinator (MSDTC) Service Required RE: Is Distributed Transaction Coordinator (MSDTC) Service Required

  • 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