cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
Announcements
Walkthrough Wednesdays
278
Views
0
Helpful
3
Replies
harresh123
Beginner

Finesse cannot connect to awdb

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

1 ACCEPTED SOLUTION

Accepted Solutions

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

View solution in original post

3 REPLIES 3
dekwan
Cisco Employee

Hi,

 

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

 

Thanx,

Denise

gorourke
Rising star

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

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

View solution in original post

Content for Community-Ad