The following errors can appeared in vRA logs:
Error processing ping response Error executing query usp_SelectAgent Inner Exception: Error executing query usp_SelectAgentCapabilities
DataBaseStatsService: ignoring exception: Error executing query usp_SelectAgent Inner Exception: Error executing query usp_SelectAgentCapabilities
There can be a few reasons of that. The first one is related to security settings of MSDTC on database server. The MSDTC settings have to be configured as listed below.
The second reason of these errors is fact that MSSQL server and IaaS server have been cloned and duplicated CID of MSDTC appeared. Communication between both server will fail. If so check HKEY_CLASSES_ROOT\CID key in the registry.
Locate the CID whose underlying Description key is MSDTC.
New CID for MS DTC in one of the registries has to be created. To do that, simply re-install MSDTC on one of the servers:
sc start msdtc