Building Microsoft SQL Server AlwaysOn Failover Cluster Instances – Part 2 – Distributed Transaction Coordinator (MSDTC)

This article is not part of the System Center Cloud series but we will use the final product to host System Center database instances.

Install guest (virtual) failover cluster


  • Cluster: Microsoft Windows Server 2012 R2
  • Two nodes
  • Failover Clustering
  • Storages
    • Witness disk: One disk on shared VHD or VHDX virtual disk
    • Cluster disks: One or more disks on shared VHD or VHDX virtual disk
  • Correctly configured Quorum

Add cluster disk for MS DTC

It is recommended to have a clustered MSDTC resource and it is a best practice to dedicate MSDTC resource for every SQL Server group in your environment.

  • Add another cluster disk for MSDTC service.
    • PowerShell
New-VHD -Path 'C:\ClusterStorage\Volume1\contsqlfcic0\Virtual Hard Disks\shared-disk-msdtc.vhdx' -Dynamic -SizeBytes 10GB
Add-VMHardDiskDrive  -VMName contsqlfcic0n0 -Path "C:\ClusterStorage\Volume1\contsqlfcic0\Virtual Hard Disks\shared-msdtc.vhdx" -ShareVirtualDisk
Add-VMHardDiskDrive -VMName contsqlfcic0n1 -Path "C:\ClusterStorage\Volume1\contsqlfcic0\Virtual Hard Disks\shared-msdtc.vhdx" -ShareVirtualDisk
  • Make the disk online on all nodes, initialize and format (NTFS) on one node.
  • Do not assign a drive letter. MS DTC does not require it.
  • Add Disks to cluster
      • MSDTC

Configure new role – Microsoft Distributed Transaction Coordinator (MS DTC)

  • New role
  • Distributed Transaction Coordinator (DTC)
  • Set name and IP address.
      • contsqlfcic0dtc
  • Choose our new storage.
  • And check the results.

Leave a Reply

Your email address will not be published. Required fields are marked *

Active Directory Advanced function AlwaysOn Availability Groups AlwaysOn Failover Cluster Instances Building Cloud Cloud Cluster Cmdlet Database Deployment Design DFS Domain Controller DSC Fabric Failover Clustering File Server Group Policy Hardware Profile Host Hyper-V Installation Library Library Asset Library Server Network Operations Manager Orchestrator PowerShell PowerShell User Group PowerShell Workflow Security Service Manager SQL Server Storage System Center Template Time Time Synchronization Tips Virtual Machine Virtual Machine Manager VM Network VM Template Windows Server 2012 R2