Error 'Liquibase releaseLocks Failed: liquibase.exception.DatabaseException: java.sql.SQLException: Network error IOException: Connection refused: connect' when Installating vRA 7.0.x

Products

• VMware Aria Suite

Issue/Introduction

This article provides details to enable TCP/IP protocol in SQL server.

Symptoms:

While installing vRealize Automation 7.0.x, you see these symptoms:

• The installation fails.
• In the installation logs, you see entries similar to :
  
  Liquibase releaseLocks Failed: liquibase.exception.DatabaseException: java.sql.SQLException: Network error IOException: Connection refused: connect
  

Environment

VMware vRealize Automation 7.0.x

Cause

This issue occurs if the TCP connection is not enabled in database server. The MS SQL Server installations does not have the TCP connection enabled. If MS SQL Express, in particular, is being used for a test or proof of concept environment, TCP connections are often disabled.

Resolution

To resolve the issue, enable the TCP/IP protocol in SQL server.

1. Open the Sql Server Configuration Manager and connect to the appropriate server, if it is not.
2. Navigate to Client Protocols nodes under the SQL Native Client 11.0 Configuration (32bit) and SQL Native Client 11.0 Configuration items.
3. If the TCP/IP protocol is not enabled, double click to open the properties and change the Enable property to Yes.
4. Restart the MS SQL services. This should take effect without additional intervention.
   

Additional Information

To be alerted when this document is updated, click the Subscribe to Article link in the Actions box