Finesse cannot connect to awdb

[harresh123]

We are running Finesse 11.6(1). When we are configuring the cfadmin for Finesse to connect to AWDB, it throws out an error cannot connect to primary or secondary DB. we are using a local sql account with sysadmin role for connection. Cannot figure out what could be the issue. Below is what we see in Finesse logs. Has anyone else run into this issue?

Error connecting AWDB Connection Pool java.sql.SQLException: activeCpds is null

[dekwan]

Hi,

I would suggest opening a TAC case so that they can dive deeper into the error.

Thanx,

Denise

[Gerry O'Rourke]

Harresh,

Its very likely to be something simple.

Can you Telnet to the SQL server on port 1433?

You can try "utils network connectivity" from the finesse server or a "telnet <host> <port>" from your PC.

Why don't you try to confirm you can connect to AW Database from another machine without issue.

e.g. from your PC or or the B side AW Database connect to the A side AW database using the same account.

The account does NOT need to be sysadmin - a read only account will suffice and makes more sense.

You can download the SQL Client and try to connect to the SQL server from your PC.

https://docs.microsoft.com/en-us/sql/ssms/download-sql-server-management-studio-ssms?view=sql-server-ver15

First thing I would check is do you have windows FW enabled on the AW Database machine.

In summary

1) Can you connect to SQL Server via TCP 1433?

2) Can SQL Studio from your PC or other AW server connect to the AW database using the SQL user account?

Gerry

Gerard

[harresh123 · Accepted solution]

Yes we tried all of those scenarios and every one of them worked. In the end it turned out to being an issue with forced encryption turned on our sql and apparently finesse doesn’t support forced encryption. We had an enhancement defect raised for the same.

https://bst.cloudapps.cisco.com/bugsearch/bug/CSCvx29072