Jdbc Source test connection not working

Identity Security Cloud (ISC) ISC Discussion and Questions
1

We have recently built a new VA’s and all the test connectivity is opened. Verified port communication on VA’s directly but when we’re doing test connection of the JDBC sources getting the following error and working when going to old VA’s of the same cluster.

Error message: The server encountered an unexpected error while contacting target system. Please check the logs. The driver could not establish a secure connection to SQL Server by using Secure Sockets Layer (SSL) encryption. Error: “Unexpected rethrowing”.

Also tested by adding jdbc:sqlserver://**:1433;database=;encrypted=false;trustServerCertificate=true;
but no luck.

2

Hi @NeetuDixit

a quick observation.

encrypt vs. encrypted: The correct parameter for Microsoft JDBC driver is usually encrypt.

give a quick try of below URL’s

jdbc:sqlserver://<host>:<port>;database=<db_name>;encrypt=true;trustServerCertificate=true;

jdbc:sqlserver://<host>:<port>;database=<db_name>;encrypt=false;trustServerCertificate=true;

jdbc:sqlserver://<host>:<port>;database=<db_name>;encrypt=false;
3

Thanks Pattabhi !!

We have actually tried both encrypt vs. encrypted and getting the same error message.

5

Hello @NeetuDixit , did you tried

openSSl command from VA ?

6

Hi @NeetuDixit

Please check your driver(.jar) file and Driver Class Name.

image
image478×110 2.21 KB

under Base Configuration:

image
image1247×348 18.9 KB

One more suggestion:

try to follow below topic solution.

Test Connection on JDBC Source Timeout

7

The error you’re seeing indicates an SSL/TLS handshake issue, not just basic connectivity.Even though nc or port checks show that 1433 is open, that doesn’t guarantee JDBC over SSL will work. Make sure the Azure firewall and NSG rules explicitly allow traffic from the new VA subnet to the SQL Server, not just on a port level but for full session flow, including return traffic.

9

What is the authentication type you are using. If you are using Windows Authentication you have to do additional configurations in the VA.

10

Thank you everyone for all the suggestions. Issue is now resolved.
It was network connectivity issue. Although, we were getting the response on VA but its was blocked from DB server.