• Index
  •  » Talend Open Studio for Data Integration » Usage, Operation
  •  » tMSSqlConnection can not connect to the SQL Server with SSL?

#1 2011-09-06 22:55:44

edwin.wang@oasolutions.ca
New member
Registered: 2010-08-23
Posts: 7

tMSSqlConnection can not connect to the SQL Server with SSL?

Tags: [database, mssql, ssl]

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!

Offline

#2 2011-09-08 07:37:32

shong
Talend team
Registered: 2007-08-29
Posts: 10310
Website

Re: tMSSqlConnection can not connect to the SQL Server with SSL?

Hi
Make sure you have configured SQL server with SSL correctly? Can you connect to SQL server with SSL on SQL server management studio or other client tool?

Best regards
Shong


Email:shong@talend.com
Choose Talend, Enjoy Talend!
New & Event: Talend Help Center
Talend-->the leader of open source data management and application integration solutions!

Offline

#3 2011-10-04 01:44:02

edwin.wang@oasolutions.ca
New member
Registered: 2010-08-23
Posts: 7

Re: tMSSqlConnection can not connect to the SQL Server with SSL?

I can connect to SQL server with SSL remotely., but can't locally

Offline

#4 2011-10-11 17:37:50

ienax_ridens
Member
Registered: 2010-10-27
Posts: 50

Re: tMSSqlConnection can not connect to the SQL Server with SSL?

I have the same problem...any idea by someone?

Offline

  • Index
  •  » Talend Open Studio for Data Integration » Usage, Operation
  •  » tMSSqlConnection can not connect to the SQL Server with SSL?

Board footer

Powered by FluxBB