• Cannot provision a machine using VMware vRealize Automation (formerly known as VMware vCloud Automation Center)
• Provisioning a machine using VMware vRealize Automation fails
• You see the error:
  
  Error executing query usp_SelectHostReservation
  
  
• In the Event Viewer on the portal, you see an error similar to:
  
  INNER EXCEPTION: System.ApplicationException: INNER EXCEPTION: System.ApplicationException: Error executing query usp_SelectGroup
  System.Transactions.TransactionManagerCommunicationException: Communication with the underlying transaction manager has failed.
  System.Runtime.InteropServices.COMException: The MSDTC transaction manager was unable to pull the transaction from the source transaction manager due to communication problems. Possible causes are: a firewall is present and it doesn't have an exception for the MSDTC process, the two machines cannot find each other by their NetBIOS names, or the support for network transactions is not enabled for one of the two transaction managers. (Exception from HRESULT: 0x8004D02B)
  System.Transactions.TransactionManagerCommunicationException: Communication with the underlying transaction manager has failed.
  System.Runtime.InteropServices.COMException: The MSDTC transaction manager was unable to pull the transaction from the source transaction manager due to communication problems. Possible causes are: a firewall is present and it doesn't have an exception for the MSDTC process, the two machines cannot find each other by their NetBIOS names, or the support for network transactions is not enabled for one of the two transaction managers. (Exception from HRESULT: 0x8004D02B)

1. Go to Start > Administrative Tools.
2. Open Component Services.
3. Expand Component Service > Computers > My Computer > Distributed Transaction Coordinator.
4. Right-click Local DTC and click Properties.
5. Click the Security tab.
6. Select the Network DTC Access option.
7. Select Allow Remote Client and Allow Remote Administration options.
8. Select the Allow Inbound and Allow Outbound options.
9. Specify NetworkService for DTC Log in Account.
10. Click OK.
    

Note: The Manager Service machine hosting the Manager Service should be able to resolve the NETBIOS name of the IaaS MS-SQL DB machine. If it is not achievable due to any reason, the workaround will be to add the NETBIOS name of the DB machine to the /etc/hosts file of the Manager Service machine and restarting Manager Service.