SQL server snap - Unexpected Re-throwing connection error

[tharunm]

Hi Community,

I was trying to access SQL server via snaplogic but I wasn’t successful as I was facing an issue with the connection. Below are the two error messages when I tried with different plexes.

Error while validating with groundplex
Failed to validate account: Failed to retrieve a database connection. Cause: The driver could not establish a secure connection to SQL Server by using Secure Sockets Layer (SSL) encryption. Error: “Unexpected rethrowing”. (Reason: The driver could not establish a secure connection to SQL Server by using Secure Sockets Layer (SSL) encryption. Error: “Unexpected rethrowing”.; Resolution: Address the reported issue.)

Error while validating with cloudplex:
Failed to validate account: Failed to retrieve a database connection. Cause: The TCP/IP connection to the host ***********************, port 1433 has failed. Error: “null. Verify the connection properties. Make sure that an instance of SQL Server is running on the host and accepting TCP/IP connections at the port. Make sure that TCP connections to the port are not blocked by a firewall.”. (Reason: The TCP/IP connection to the host ****************************, port 1433 has failed. Error: “null. Verify the connection properties. Make sure that an instance of SQL Server is running on the host and accepting TCP/IP connections at the port. Make sure that TCP connections to the port are not blocked by a firewall.”.; Resolution: Address the reported issue.)

JDBC drives that I used:

1. mssql-jdbc-9.4.0.jre8
2. mssql-jdbc-7.4.1.jre8
3. mssql-jdbc-10.2.0.jre8.jar
4. mssql-jdbc-7.4.1.jre11.jar*

Details:

I would really appreciate if anyone could help me on this.

Thank you.

[tharunm]

Hello Community,

As the issue is related to firewall, we raised a request the vendor(SQL server) to whitelist our IPs to resolve the persisting issue of re-throwing error.

Thank you.