The driver cannot establish a secure connection exception resolution by using Secure Sockets Layer (SSL) encryption with SQL Server

Reprint: http://m.educity.cn/wenda/584424.html

The driver cannot establish a secure connection error resolution with SQL Server by using Secure Sockets Layer (SSL) encryption

The following error always occurs when connecting sqlserver2005 with Java

June, 10:05:34 AM com.microsoft.sqlserver.jdbc.TDSChannel Enablessl
Information: java.security path:c:\java\jre6\lib\security
Security providers: [SUN version 1.6, sunrsasign version 1.5, Sunjsse version 1.6, SUNJGSS version 1.0, SUNSASL version 1. 5, XMLDSig version 1.0, SUNPCSC version 1.6]
Sslcontext provider Info:sun JSSE provider (PKCS12, SunX509 key/trust factories, SSLv3, TLSV1)
Sslcontext Provider Services:
[SunJSSE:KeyFactory.RSA-Sun.security.rsa.RSAKeyFactory
Aliases: [1.2.840.113549.1.1, oid.1.2.840.113549.1.1]
, SunJSSE:KeyPairGenerator.RSA-Sun.security.rsa.RSAKeyPairGenerator
Aliases: [1.2.840.113549.1.1, oid.1.2.840.113549.1.1]
, SunJSSE:Signature.MD2withRSA-Sun.security.rsa.rsasignature$md2withrsa
Aliases: [1.2.840.113549.1.1.2, oid.1.2.840.113549.1.1.2]
, SunJSSE:Signature.MD5withRSA-Sun.security.rsa.rsasignature$md5withrsa
Aliases: [1.2.840.113549.1.1.4, oid.1.2.840.113549.1.1.4]
, SunJSSE:Signature.SHA1withRSA-Sun.security.rsa.rsasignature$sha1withrsa
Aliases: [1.2.840.113549.1.1.5, oid.1.2.840.113549.1.1.5, 1.3.14.3.2.29, oid.1.3.14.3.2.29]
, SunJSSE:Signature.MD5andSHA1withRSA-Co.ssl.internal.ssl.RSASignature
, SunJSSE:KeyManagerFactory.SunX509-co.ssl.internal.ssl.keymanagerfactoryimpl$sunx509
, SunJSSE:KeyManagerFactory.NewSunX509-co.ssl.internal.ssl.keymanagerfactoryimpl$x509
, SunJSSE:TrustManagerFactory.SunX509-Co.ssl.internal.ssl.trustmanagerfactoryimpl$simplefactory
, SunJSSE:TrustManagerFactory.PKIX-Co.ssl.internal.ssl.trustmanagerfactoryimpl$pkixfactory
Aliases: [Sunpkix, X509,]
, SunJSSE:SSLContext.SSL-Co.ssl.internal.ssl.SSLContextImpl
, SunJSSE:SSLContext.SSLv3-Co.ssl.internal.ssl.SSLContextImpl
, SunJSSE:SSLContext.TLS-Co.ssl.internal.ssl.SSLContextImpl
, SunJSSE:SSLContext.TLSv1-Co.ssl.internal.ssl.SSLContextImpl
, SunJSSE:SSLContext.Default-Co.ssl.internal.ssl.DefaultSSLContextImpl
, SunJSSE:KeyStore.PKCS12-Co.ssl.internal.pkcs12.PKCS12KeyStore
]
Java.ext.dirs:c:\java\jre6\lib\ext; C:\Windows\Sun\Java\lib\ext
Com.microsoft.sqlserver.jdbc.SQLServerException: The driver cannot establish a secure connection to SQL Server by using Secure Sockets Layer (SSL) encryption. Error: "RSA premaster secret Error".
At Com.microsoft.sqlserver.jdbc.SQLServerConnection.terminate (sqlserverconnection.java:1352)
At Com.microsoft.sqlserver.jdbc.TDSChannel.enableSSL (iobuffer.java:1533)
At Com.microsoft.sqlserver.jdbc.SQLServerConnection.connectHelper (sqlserverconnection.java:1042)
At Com.microsoft.sqlserver.jdbc.SQLServerConnection.login (sqlserverconnection.java:817)
At Com.microsoft.sqlserver.jdbc.SQLServerConnection.connect (sqlserverconnection.java:700)
At Com.microsoft.sqlserver.jdbnnect (sqlserverdriver.java:842)
At Java.sql.DriverManager.getConnection (Unknown Source)
At Java.sql.DriverManager.getConnection (Unknown Source)
At Conndb.main (conndb.java:14)


Online access to information, found that some people say that the problem is the JDBC driver package, but after changing the driver package, the problem remains unresolved.

After I changed my window-〉preference-〉java-〉install jres to Jre6, the problem was solved.

I used the JDK, directory in C:\Program files\java\jdk1.6.0_25, changed to the JRE directory is C:\Program files\java\jre6.



Although I do not know why, but the problem finally solved.

The driver cannot establish a secure connection exception resolution by using Secure Sockets Layer (SSL) encryption with SQL Server