One of the many prerequisites of the VMware vRealize Automation Infrastructure as a Service (IaaS) components (including Microsoft SQL Server) is the installation and configuration of Microsoft Distributed Transaction Coordinator (MS DTC).
Not installing and configuring MS DTC correctly can be the the bane of someone trying to install VMware vRealize Automation.
ProTip 1 – Uninstall MS DTC via PowerShell
MS DTC seems to be installed by default in Windows, but if you have cloned (without Sysprep) the Windows image, then MS DTC will need to be removed (and re-installed). A simple PowerShell command can be used to remove MS DTC:
ProTip 2 – Install MS DTC via PowerShell
Once MS DTC has been removed, you can re-install it using the following command:
There are options for changing the service startup type and location of logs, see Install-Dtc for more information.
ProTip 3 – Configure MS DTC in PowerShell
Once the installation has been completed, MS DTC can easily be configured using the following PowerShell command:
Set-DtcNetworkSetting -DtcName "Local" -RemoteAdministrationAccessEnabled:$False -RemoteClientAccessEnabled:$True -InboundTransactionsEnabled:$True -OutboundTransactionsEnabled:$True -LUTransactionsEnabled:$True -XATransactionsEnabled:$False -AuthenticationLevel Mutual -Confirm:$False