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
I have tried to set up DB connection in metadata and its working for the server which was already working with tMSSqlconnection but I am getting error for the server which was not working with tMSSqlconnection.