[resolved] SSL and JDBC

[Anonymous]

Hi,
We access a SQL server that has SSL implemented on it. When I try to access the server using tMSSqlConnection, I get the error :-
Exception in component tMSSqlConnection_1
java.sql.SQLException: I/O Error: DB server closed connection.
Is there a way to get the JDBC working with SSL?
We are on Talend 2.4.1 - Maybe we need to upgrade?
Thanks,

[Anonymous]

Hi,
Some update - I have tried
integratedSecurity=true;encrypt=true;trustServerCertificate=true;
in the 'Additional JDBS Parameters" but still no joy.

[Anonymous · Accepted solution]

Hi,
I found the soluiton for me. In the 'Additional JDBS Parameters', I entered 'ssl=require;'

[Anonymous]

When I tried to connect to SQL Server with SSL, the tMSSqlConnection returns: java.sql.SQLException: I/O Error: DB server closed connection.
No matter what I entered in the 'Additional JDBC Parameters' (e.g. "integratedSecurity=true;encrypt=true;trustServerCertificate=true;" or "integratedSecurity=true;encrypt=true;trustServerCertificate=true;ssl=require;" or "ssl=require;" or "ssl=true;" ect. It doesn't work to me.
Anyone has any idea for that? thanks!