on 07-12-2013 7:30 AM
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.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
Download and install SQL Server Native Client from microsoft website. I think this will solve your error.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
25 | |
12 | |
9 | |
6 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.