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 plex...
accounts
jdbc
sqlserver
mbowen's avatar
mbowen
Employee
4 years ago
Copy Link

A couple things to try on your Groundplex.

  • If you don’t specify a JDBC jar, the SQL Server snap pack will use the jdbc driver bundled with the snap pack (a 4.0 driver). So, try that if you haven’t already.

  • Try adding this property to the Url Properties at the bottom of the account.

trustServerCertificate=true

  • If neither of the above help, let’s trying pinning the TLS version. Add this property to Url Properties. Try v1 then v1.2. I’m not sure of TLS version enabled for 2016 sql server.

    sslProtocol=TLSv1
    OR
    sslProtocol=TLSv1.2

Let us know results.

tharunm's avatar
tharunm
New Contributor II
4 years ago
Copy Link

Hi Bowen,
many thanks for your response.

I have tried again with 4 different JDBC drivers, and also the default ones(by not specifying anything) and also by adding the URL properties as mentioned above, adding one at a time and both of the properties at a time, in my Dev and Test environments on 4 different groundplexes and yet the error remains the same. ‘Unexpected Rethrowing’ as the driver couldn’t establish a secure connection to SQL server.

so, we are still at square one I suppose.

Thanks.