While setting up Clarity on SQL server, we notice the Database as unavailable on CSA page
Ping is working, TCP/IP is enabled but still SQL DB is unavailable.
Exception due to DB Connection failureERROR 2022-08-16 05:20:48,144 [http-nio-8090-exec-1] feature.FeatureCache (clarity:admin:-1:none) Failed to build cache for featurescom.niku.union.persistence.DBConnectionException: java.sql.SQLNonTransientConnectionException:: HOSTNAME:1433. Reason: Connection refused: connect at com.niku.union.persistence.PersistenceController.doProcessRequest(PersistenceController.java:616) at com.niku.union.persistence.PersistenceController.processRequest(PersistenceController.java:311)
The SQL server port 1433 was opened up and clarity services restarted.