Setup MSDTC - SQL-FineBuild/Common GitHub Wiki
| 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 |
|---|