| title | Cluster DTC service for an availability group |
|---|---|
| description | Describes the requirements and steps for clustering the Microsoft Distributed Transaction Coordinator (DTC) service for an Always On availability group. |
| ms.custom | seo-lt-2019 |
| ms.date | 08/30/2016 |
| ms.prod | sql |
| ms.reviewer | |
| ms.technology | high-availability |
| ms.topic | how-to |
| ms.assetid | a47c5005-20e3-4880-945c-9f78d311af7a |
| author | MashaMSFT |
| ms.author | mathoma |
| monikerRange | >=sql-server-2016||=sqlallproducts-allversions |
[!INCLUDEsql windows only]
This topic describes the requirements and steps for clustering the Microsoft Distributed Transaction Coordinator (DTC) service for [!INCLUDEssHADR]. For additional information regarding distributed transactions and [!INCLUDEssHADR], see Cross-Database Transactions and Distributed Transactions for Always On Availability Groups and Database Mirroring (SQL Server).
| Task | Reference |
|---|---|
| Ensure all nodes, services and the Availability Group have been configured correctly. | Prerequisites, Restrictions, and Recommendations for Always On Availability Groups (SQL Server) |
| Ensure Availability Group DTC requirements have been met. | Cross-Database Transactions and Distributed Transactions for Always On Availability Groups and Database Mirroring (SQL Server) |
| Task | Reference |
|---|---|
| A shared-storage drive. | Configuring the Shared-Storage Drive. Consider using drive letter M. |
| A unique DTC Network Name resource. The name will be registered as a cluster computer object in Active Directory. Make sure that either of the following is true: • The user who creates the DTC Network Name resource has the Create Computer objects permission to the OU or the container where the DTC Network Name resource will reside. • If the user does not have the Create Computer objects permission, ask a domain administrator to prestage a cluster computer object for the DTC Network Name resource. |
Prestage Cluster Computer Objects in Active Directory Domain Services |
| A valid available static IP address and the appropriate subnet mask for that IP address. |
Once you have created your Availability Group resource, create a clustered DTC resource and add it to the Availability Group. A sample script can be seen at Create Clustered DTC for an Always On Availability Group.
| Task | Reference |
|---|---|
| Enable network access securely for the clustered DTC resource. | Enable Network Access Securely for MS DTC |
| Stop and disable local DTC service. | Configure How a Service Is Started |
| Cycle the SQL Server service for each instance in the Availability Group. Failover the Availability Group as needed. | Perform a Planned Manual Failover of an Availability Group (SQL Server) Start, Stop, Pause, Resume, Restart the Database Engine, SQL Server Agent, or SQL Server Browser Service |
-
If the server is Windows Server 2012 R2 the operating system must have KB 3030373 applied.
-
Prepare the servers for Availability Groups according to the checklists at Prerequisites, Restrictions, and Recommendations for Always On Availability Groups.
-
Configure the server instances for Always On Availability Groups.
More Information on Testing DTC on Availability Groups:
Monitoring Always on Availability groups system views
Create Availability Group Step by Step
SQL Server 2016 DTC Support in Availability Groups
External link: Configure DTC for a clustered instance of SQL Server with Windows Server 2008 R2