Skip to Content
0
Jul 12, 2013 at 06:30 AM

JDBC adapter Connection ISSUE: SSL Encryption:TDS protocol stream not valid

251 Views

Hi Experts,

I am trying to establish connection to a MS SQL 2008 DB. and i am getting this error constantly in the JDBC adapter.

I have tried many JDBC urls like: URL: jdbc:sqlserver://<Server Hostname: correctPORT>;databaseName=<DBNAME>;encrypt=false;trustServerCertificate=true

I am constantly getting above error and not able to establish connection to the server.

Other connections to DB's like MS 2005 are working fine without any issues.

Note: This is PI 7.31 dual stack and JDBC Driver 4 is being used sqljdbc4.jar

have someone faced similar issues in past.

Help will be deeply appreciated.

Regards,

Senthilprakash.

Attachments

Error.jpg (140.8 kB)