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

Prerequisites

  • 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.
« Previous Next »

Part of the series

  1. Building guest (virtual) Failover Cluster on Hyper-V host with Windows Server 2012 R2 - Part 1 - Create virtual machines
  2. Building guest (virtual) Failover Cluster on Hyper-V host with Windows Server 2012 R2 - Part 2 - Install and configure cluster
  3. Building Microsoft SQL Server AlwaysOn Failover Cluster Instances - Part 1 - Design
  4. Building Microsoft SQL Server AlwaysOn Failover Cluster Instances - Part 3 - Configure storage and mount points
  5. Building Microsoft SQL Server AlwaysOn Failover Cluster Instances - Part 4 - Install first node
  6. Building Microsoft SQL Server AlwaysOn Failover Cluster Instances - Part 5 - Install second node
  7. Building Microsoft SQL Server AlwaysOn Failover Cluster Instances - Part 6 - Install another instance
  8. Building Microsoft SQL Server AlwaysOn Failover Cluster Instances - Part 7 - Manually configure Reporting Services