Incredible. It was right in front of me all along. 😎
So here are the pictures.
This is the API response. (in this case I need status = success. It tells me I can go get the data)
This is how I set up the Rest GET Snap. I have Has next set to try again if status <> success.
Hopefully this won’t be as painful for you as it was for me!!
The current issue I encounter is, I am able to connect the SQL server outside snaplogic but not with snaplogic.
There were two errors, one while using groundplex(which is preferred) and an other using cloudplex.
Also, there are other SQL servers accounts which I’ve created in the past and still working on with them. So, for this account alone I see ‘Unexpected rethrowing’ error.
I really appreciate your responses. Thank you.
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.
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.
