Clarity with SQL Server: Unable to make the database available
search cancel

Clarity with SQL Server: Unable to make the database available

book

Article ID: 248823

calendar_today

Updated On:

Products

Clarity PPM On Premise

Issue/Introduction

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.

App logs:

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: [CA Clarity][SQLServer JDBC Driver]Error establishing socket to host and port: 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)

Environment

Clarity 16.0.2

Resolution

The SQL server port 1433 was opened up and clarity services restarted. 

Additional Information

How To Open Firewall Port 1433 for SQL Server Database Engine