Setup MSDTC

Previous Setup Slipstream Install Media	Check MSDTC Kerberos Next

SQL FineBuild can configure the Microsoft Distributed Tansaction Coordinator (MSDTC) for both Clustered and Non-clustered SQL Server installs.

Useful information about MSDTC can be found at the following links:

Item	Location
Introduction to MSDTC	https://en.wikipedia.org/wiki/Microsoft_Distributed_Transaction_Coordinator
MSDTC Recommendations on SQL Failover Cluster	https://docs.microsoft.com/en-gb/archive/blogs/alwaysonpro/msdtc-recommendations-on-sql-failover-cluster
Troubleshooting MSDTC	https://docs.microsoft.com/en-gb/archive/blogs/distributedservices/troubleshooting-msdtc-communication-checklist
	https://www.mssqltips.com/sqlservertip/4367/troubleshooting-distributed-transaction-performance-problems-in-sql-server/

MSDTC is included as a standard part of Windows, but it needs to be configured in order for it to work as needed for SQL Server. All of the following processes must be completed to configure MSDTC:

Item	Comment
Check MSDTC Kerberos	Check MSDTC Kerberos configuration
Setup MSDTC CID	Setup new CID GUID for MSDTC
Setup MSDTC Network Access	Setup Network Access for MSDTC
Setup MSDTC Cluster	Build the MSDTC Cluster
Setup MSDTC Cluster Access	Setup Network Access for MSDTC Cluster
Register MSDTC Cluster Resources	Register MSDTC Install Status
Check MSDTC Cluster Service	Check MSDTC Cluster is working correctly

Copyright FineBuild Team © 2013- 2021. License and Acknowledgements

Previous Setup Slipstream Install Media	Top	Check MSDTC Kerberos Next