Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I found a solution for this. Not sure if it is still relevant. Posting for all the people who might need this information in the future.
In case we are connecting to a Microsoft SQL Server from Talend which has forced encryption(ssl required) enabled at the server side, then we need to add Additional JDBC parameters while establishing the connection.
The additional parameters are : "encrypt=true;trustServerCertificate=true;ssl=require"
I have tested in one of the sample jobs and it works fine for me. If I do not add these additional parameters, then I will get DB connection closed error. Image attached.
Hope this helps.
Regards,
Swati Sood
Hi Swati,
I faced the same issue. And your post was helpful to resolve this. Thank You!
Hello,
That is really good answer, have you thought of entering our competition?
https://community.talend.com/s/blog/aGn5b000000CaZw/getting-smart-about-talend-tip-of-the-day
Best regards
Sabrina