Forum Discussion

tharunm's avatar
tharunm
New Contributor II
4 years ago

SQL server snap - Unexpected Re-throwing connection error

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.

10 Replies

  • Hi @manohar,

    You can try by using Mapper Snap with the following expression for the attachments:

    sl.range(0,$docname.length).map((x,ind) => {"docname":$docname[ind],"id":$id,"docext":$docext[ind],"docid":$docid[ind]})
    

    Try with this, and let me know if this helps you.

    BR,
    Aleksandar.