cancel
Showing results for 
Search instead for 
Did you mean: 

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

Senthilprakash1
Participant
0 Kudos

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.

Accepted Solutions (0)

Answers (2)

Answers (2)

former_member360941
Discoverer
0 Kudos

Hi, i know that is an old post... but now i have the same problem whit a 2005 sql server.

Could you solve the problem?

Regards

former_member186228
Active Participant
0 Kudos

Hi,

Download and install SQL Server Native Client from microsoft website. I think this will solve your error.