SQL Server Connection issues after upgrade to 6.0

0

Hi All,

I've just upgraded our test server to 6.0, and no the MS SQL Server 2005 Driver (com.microsoft.sqlserver.jdbc.SQLServerDriver) no longer works.

Whenever you try to connect to the server it just returns this error - 

The driver could not establish a secure connection to SQL Server by using Secure Sockets Layer (SSL) encryption. Error: "Server key".

Anyone else experiencing this problem?

This is running on SQL Server 2014. I think the JVM installed with jaspersoft may be contributing here (I loathe to play with it though, for fear of breaking things further), thats on version 1.6.0_18.

Full stack trace is here -

com.microsoft.sqlserver.jdbc.SQLServerException: The driver could not establish a secure connection to SQL Server by using Secure Sockets Layer (SSL) encryption. Error: "Server key"

cameron_1's picture
896
Joined: May 5 2013 - 8:32pm
Last seen: 2 years 3 months ago

1 Answer:

1

I got the same InvalidKeySpecException doing something else. The workaround is to use Oracle's JRE 1.7.0 instead of OpenJDK.

sbyrne's picture
89
Joined: Mar 18 2015 - 6:53am
Last seen: 4 years 2 months ago
Feedback
randomness