Service failed to start with error "SQL Error occurred while preparing properties table"

Products

• CA Process Automation Base

Issue/Introduction

Orchestrator Service failed to start with below error in c2o.log file:

2022-06-30 21:55:28,422 ERROR [com.optinuity.c2o.jboss.SystemPropertiesInitializer] [ main] SQL Error occurred while preparing properties table due to java.sql.SQLException: Network error IOException: Connection refused: connect
caused by: java.net.ConnectException: Connection refused: connect

Environment

Release : 4.3.X

Component : Process Automation

Cause

SQL Server Service failed to start with error:

Resolution

After DBA fixed the database startup issue, Orchestrator service started successfully.