Connection Errors Between vSphere Replication and SQL Server Cannot be Resolved

You cannot resolve a connection error between the vSphere Replication appliance and SQL Server.

Problem

vSphere Replication might not be able to connect to SQL Server, and you have insufficient information to solve this problem.

Cause

Several issues can cause this problem, and initially available information about the problem is insufficient to affect a resolution.

Solution

1. Use a file management tool to connect to the vSphere Replication appliance.
   For example, you might use SCP or WinSCP. Connect using the root account, which is the same account used to connect to the VAMI.
2. Delete any files you find in /opt/vmware/hms/logs.
3. Connect to the VAMI and attempt to save the vSphere Replication configuration.
   This action recreates the SQL error.
4. Connect to the vSphere Replication appliance again and find the hms-configtool.log file which is in /opt/vmware/hms/logs.
   This log file contains information about the error that just occurred. Use this information to troubleshoot the connection issue, or provide the information to VMware for further assistance. See Reconfigure vSphere Replication to Use an External Database.