PRO TIP: Configuring MSDTC for VMware vRealize Automation

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:

Uninstall-Dtc -confirm:$false

ProTip 2 – Install MS DTC via PowerShell

Once MS DTC has been removed, you can re-install it using the following command:

Install-Dtc

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

Leave a Reply

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

This site uses Akismet to reduce spam. Learn how your comment data is processed.