驱动程序无法使用SSL建立与SQL Server的安全连接 [英] The driver could not establish a secure connection to SQL Server by using SSL
本文介绍了驱动程序无法使用SSL建立与SQL Server的安全连接的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！
问题描述
我在连接SQL数据库时遇到问题。每当我尝试连接到SQL服务器时，我都会收到以下错误;
引起：org.hibernate.exception.JDBCConnectionException：调用驱动程序#connect
时出错org.hibernate.exception.internal.SQLStateConversionDelegate.convert（SQLStateConversionDelegate.java:132）
at org.hibernate.engine.jdbc.connections.internal.BasicConnectionCreator $ 1 $ 1.convert （BasicConnectionCreator.java:118）
at org.hibernate.engine.jdbc.connections.internal.BasicConnectionCreator.convertSqlException（BasicConnectionCreator.java:140）
at org.hibernate.engine.jdbc.connections.internal .DriverConnectionCreator.makeConnection（DriverConnectionCreator.java:58）
at org.hibernate.engine.jdbc.connections.internal.BasicConnectionCreator.createConnection（BasicConnectionCreator.java:75）
at org.hibernate.engine.jdbc .connections.internal.DriverManagerConnectionProviderImpl.configure（DriverManagerConnectionProviderImpl.java:106）
at org.hiberna te.boot.registry.internal.StandardServiceRegistryImpl.configureService（StandardServiceRegistryImpl.java:111）
at org.hibernate.service.internal.AbstractServiceRegistryImpl.initializeService（AbstractServiceRegistryImpl.java:234）
at org.hibernate。 service.internal.AbstractServiceRegistryImpl.getService（AbstractServiceRegistryImpl.java:206）
at org.hibernate.engine.jdbc.internal.JdbcServicesImpl.buildJdbcConnectionAccess（JdbcServicesImpl.java:260）
at org.hibernate.engine。 jdbc.internal.JdbcServicesImpl.configure（JdbcServicesImpl.java:94）
at org.hibernate.boot.registry.internal.StandardServiceRegistryImpl.configureService（StandardServiceRegistryImpl.java:111）
at org.hibernate.service。 internal.AbstractServiceRegistryImpl.initializeService（AbstractServiceRegistryImpl.java:234）
at org.hibernate.service.internal.AbstractServiceRegistryImpl.getService（AbstractServiceRegistryImpl.java:206）
at org.hibernate.cfg.Configuration.buil dTypeRegistrations（Configuration.java:1887）
at org.hibernate.cfg.Configuration.buildSessionFactory（Configuration.java:1845）
at org.hibernate.jpa.boot.internal.EntityManagerFactoryBuilderImpl $ 4.perform（EntityManagerFactoryBuilderImpl .java：857）
at org.hibernate.jpa.boot.internal.EntityManagerFactoryBuilderImpl $ 4.perform（EntityManagerFactoryBuilderImpl.java:850）
at org.hibernate.boot.registry.classloading.internal.ClassLoaderServiceImpl。 withTccl（ClassLoaderServiceImpl.java:425）
org.hibernate.jpa.boot.internal.EntityManagerFactoryBuilderImpl.build（EntityManagerFactoryBuilderImpl.java:849）
at org.hibernate.jpa.HibernatePersistenceProvider.createEntityManagerFactory（HibernatePersistenceProvider。 java：75）
... 143更多
引起：com.microsoft.sqlserver.jdbc.SQLServerException：驱动程序无法通过使用安全套接字层（SSL）加密与SQL Server建立安全连接。错误：SQL Server未返回响应。连接已关闭.ClientConnectionId：.....。
at com.microsoft.sqlserver.jdbc.SQLServerConnection.terminate（SQLServerConnection.java:1667）
at com.microsoft.sqlserver.jdbc.TDSChannel.enableSSL（IOBuffer.java:1668)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.connectHelper（SQLServerConnection.java:1323）
at com.microsoft.sqlserver.jdbc.SQLServerConnection.login（SQLServerConnection.java:991）
at com.microsoft .sqlserver.jdbc.SQLServerConnection.connect（SQLServerConnection.java:827）
at com.microsoft.sqlserver.jdbc.SQLServerDriver.connect（SQLServerDriver.java:1012）
at org.hibernate.engine.jdbc .connections.internal.DriverConnectionCreator.makeConnection（DriverConnectionCreator.java:55）
... 160 more
引起：java.io.IOException：SQL Server没有返回响应。连接已关闭。 ClientConnectionId：.....
at com.microsoft.sqlserver.jdbc.TDSChannel $ SSLHandshakeInputStream.ensureSSLPayload（IOBuffer.java:651）
at com.microsoft.sqlserver.jdbc.TDSChannel $ SSLHandshakeInputStream.readInternal （IOBuffer.java:708）
at com.microsoft.sqlserver.jdbc.TDSChannel $ SSLHandshakeInputStream.read（IOBuffer.java:700）
at com.microsoft.sqlserver.jdbc.TDSChannel $ ProxyInputStream.readInternal （IOBuffer.java:895）
at com.microsoft.sqlserver.jdbc.TDSChannel $ ProxyInputStream.read（IOBuffer.java:883）
at sun.security.ssl.InputRecord.readFully（InputRecord.java） ：465）
at sun.security.ssl.InputRecord.read（InputRecord.java:503）
at sun.security.ssl.SSLSocketImpl.readRecord（SSLSocketImpl.java:973)
at sun.security.ssl.SSLSocketImpl.performInitialHandshake（SSLSocketImpl.java:1375）
at sun.security.ssl.SSLSocketImpl.startHandshake（SSLSocketImpl.java:1403）
at sun.security.ssl.SSLSocketImpl。 startHandshake（的SSLSocket Impl.java:1387）
at com.microsoft.sqlserver.jdbc.TDSChannel.enableSSL（IOBuffer.java:1618）
... 165更多
这是使用 com.microsoft.sqlserver.jdbc.SQLServerDriver
每当我使用JtDS驱动程序时（例如，建议使用）。 这篇文章），我仍然无法连接到SQL服务器，我收到以下错误。
由以下原因引起： org.hibernate.exception.JDBCConnectionException：在org.hibernate.engine.jdbc.connections上调用org.hibernate.exception.internal.SQLStateConversionDelegate.convert（SQLStateConversionDelegate.java:132）
时调用Driver＃connect
时出错.internal.BasicConnectionCreator $ 1 $ 1.convert（BasicConnectionCreator.java:118）
at org.hibernate.engine.jdbc.connections.internal.BasicConnectionCreator.convertSqlException（BasicConnectionCreator.java:140）
at org.hibernate .engine.jdbc.connections.internal.DriverConnectionCreator.makeConnection（DriverConnectionCreator.java:58）
at org.hibernate.engine.jdbc.connections.internal.BasicConnectionCreator.createConnection（BasicConnectionCreator.java:75)
a t org.hibernate.engine.jdbc.connections.internal.DriverManagerConnectionProviderImpl.configure（DriverManagerConnectionProviderImpl.java:106）
at org.hibernate.boot.registry.internal.StandardServiceRegistryImpl.configureService（StandardServiceRegistryImpl.java:111)
at org.hibernate.service.internal.AbstractServiceRegistryImpl.initializeService（AbstractServiceRegistryImpl.java:234）
at org.hibernate.service.internal.AbstractServiceRegistryImpl.getService（AbstractServiceRegistryImpl.java:206）
at org .hibernate.engine.jdbc.internal.JdbcServicesImpl.buildJdbcConnectionAccess（JdbcServicesImpl.java:260）
at org.hibernate.engine.jdbc.internal.JdbcServicesImpl.configure（JdbcServicesImpl.java:94）
at org .hibernate.boot.registry.internal.StandardServiceRegistryImpl.configureService（StandardServiceRegistryImpl.java:111）
at org.hibernate.service.internal.AbstractServiceRegistryImpl.initializeService（AbstractServiceRegistryImpl.java:234）
at org.hibernate.service.internal.AbstractServiceRegistryImpl.getService（AbstractServiceRegistryImpl.java:206）
at org.hibernate.cfg.Configuration.buildTypeRegistrations（Configuration.java:1887)
at org.hibernate.cfg .Configuration.buildSessionFactory（Configuration.java:1845）
at org.hibernate.jpa.boot.internal.EntityManagerFactoryBuilderImpl $ 4.perform（EntityManagerFactoryBuilderImpl.java:857）
at org.hibernate.jpa.boot。 internal.EntityManagerFactoryBuilderImpl $ 4.perform（EntityManagerFactoryBuilderImpl.java:850）
at org.hibernate.boot.registry.classloading.internal.ClassLoaderServiceImpl.withTccl（ClassLoaderServiceImpl.java:425）
at org.hibernate.jpa .boot.internal.EntityManagerFactoryBuilderImpl.build（EntityManagerFactoryBuilderImpl.java:849）
at org.hibernate.jpa.HibernatePersistenceProvider.createEntityManagerFactory（HibernatePersistenceProvider.java:75）
... 143更多
引起by：java.sql.SQLException：I / O错误： DB服务器关闭连接。
at net.sourceforge.jtds.jdbc.TdsCore.nextToken（TdsCore.java:2481）
at net.sourceforge.jtds.jdbc.TdsCore.login（TdsCore.java:632）
在net.sourceforge.jtds.jdbc.JtdsConnection。< init>（JtdsConnection.java:371）
at net.sourceforge.jtds.jdbc.Driver.connect（Driver.java:184）
at org.hibernate.engine.jdbc.connections.internal.DriverConnectionCreator.makeConnection（DriverConnectionCreator.java:55）
... 160 more
引起：java.io.IOException：数据库服务器已关闭连接。
at net.sourceforge.jtds.jdbc.SharedSocket.readPacket（SharedSocket.java:852)
at net.sourceforge.jtds.jdbc.SharedSocket.getNetPacket（SharedSocket.java:731)
at net.sourceforge.jtds.jdbc.ResponseStream.getPacket（ResponseStream.java:477）
at net.sourceforge.jtds.jdbc.ResponseStream.read（ResponseStream.java:114）
at net.sourceforge .jtds.jdbc.TdsCore.nextToken（TdsCore.java:2368）
... 164更多
我使用的连接字符串:(使用jtds）
jdbc：jtds：sqlserver：//url.database.windows.net： [PORT]; database = name;
或者当不使用jtds时..
jdbc：sqlserver：//url.database.windows.net: [PORT]; database = name;
<我还有一台服务器，它实际上可以使用这些配置运行并连接到数据库。我只是在尝试连接到本地数据库时遇到这些错误。
我正在运行macOS Sierra版本10.21
jtds版本：
< dependency>
< groupId> net.sourceforge.jtds< / groupId>
< artifactId> jtds< / artifactId>
< version> 1.3.1< / version>
< / dependency>
sqlserver版本：
<依赖性>
< groupId> com.microsoft.sqlserver< / groupId>
< artifactId> sqljdbc4< / artifactId>
< version> 4.0< / version>
< / dependency>
编辑：
我能够使用相同的配置连接到数据库，并在不同的网络上使用相同的笔记本电脑。只有在家里的网络上我才会收到此错误
解决方案
我怀疑当你的笔记本电脑开启时一个不同的网络，它然后在防火墙内，也保护您连接的数据库服务器。因此，在这种情况下建立数据库连接没有问题。
您的家中网络我认为是在防火墙之外保护您正在尝试的数据库服务器连接到。因此，由于防火墙保护，您的数据库连接尝试被忽略。
如果这些假设是正确的，您将需要联系网络管理员不同的网络从您的家庭网络通过防火墙访问。
我希望这会有所帮助。
I'm having problems connecting to SQL databases. Whenever I try to connect to a SQL server I get the following error;
Caused by: org.hibernate.exception.JDBCConnectionException: Error calling Driver#connect
at org.hibernate.exception.internal.SQLStateConversionDelegate.convert(SQLStateConversionDelegate.java:132)
at org.hibernate.engine.jdbc.connections.internal.BasicConnectionCreator$1$1.convert(BasicConnectionCreator.java:118)
at org.hibernate.engine.jdbc.connections.internal.BasicConnectionCreator.convertSqlException(BasicConnectionCreator.java:140)
at org.hibernate.engine.jdbc.connections.internal.DriverConnectionCreator.makeConnection(DriverConnectionCreator.java:58)
at org.hibernate.engine.jdbc.connections.internal.BasicConnectionCreator.createConnection(BasicConnectionCreator.java:75)
at org.hibernate.engine.jdbc.connections.internal.DriverManagerConnectionProviderImpl.configure(DriverManagerConnectionProviderImpl.java:106)
at org.hibernate.boot.registry.internal.StandardServiceRegistryImpl.configureService(StandardServiceRegistryImpl.java:111)
at org.hibernate.service.internal.AbstractServiceRegistryImpl.initializeService(AbstractServiceRegistryImpl.java:234)
at org.hibernate.service.internal.AbstractServiceRegistryImpl.getService(AbstractServiceRegistryImpl.java:206)
at org.hibernate.engine.jdbc.internal.JdbcServicesImpl.buildJdbcConnectionAccess(JdbcServicesImpl.java:260)
at org.hibernate.engine.jdbc.internal.JdbcServicesImpl.configure(JdbcServicesImpl.java:94)
at org.hibernate.boot.registry.internal.StandardServiceRegistryImpl.configureService(StandardServiceRegistryImpl.java:111)
at org.hibernate.service.internal.AbstractServiceRegistryImpl.initializeService(AbstractServiceRegistryImpl.java:234)
at org.hibernate.service.internal.AbstractServiceRegistryImpl.getService(AbstractServiceRegistryImpl.java:206)
at org.hibernate.cfg.Configuration.buildTypeRegistrations(Configuration.java:1887)
at org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:1845)
at org.hibernate.jpa.boot.internal.EntityManagerFactoryBuilderImpl$4.perform(EntityManagerFactoryBuilderImpl.java:857)
at org.hibernate.jpa.boot.internal.EntityManagerFactoryBuilderImpl$4.perform(EntityManagerFactoryBuilderImpl.java:850)
at org.hibernate.boot.registry.classloading.internal.ClassLoaderServiceImpl.withTccl(ClassLoaderServiceImpl.java:425)
at org.hibernate.jpa.boot.internal.EntityManagerFactoryBuilderImpl.build(EntityManagerFactoryBuilderImpl.java:849)
at org.hibernate.jpa.HibernatePersistenceProvider.createEntityManagerFactory(HibernatePersistenceProvider.java:75)
... 143 more
Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: The driver could not establish a secure connection to SQL Server by using Secure Sockets Layer (SSL) encryption. Error: "SQL Server did not return a response. The connection has been closed. ClientConnectionId:.....".
at com.microsoft.sqlserver.jdbc.SQLServerConnection.terminate(SQLServerConnection.java:1667)
at com.microsoft.sqlserver.jdbc.TDSChannel.enableSSL(IOBuffer.java:1668)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.connectHelper(SQLServerConnection.java:1323)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.login(SQLServerConnection.java:991)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.connect(SQLServerConnection.java:827)
at com.microsoft.sqlserver.jdbc.SQLServerDriver.connect(SQLServerDriver.java:1012)
at org.hibernate.engine.jdbc.connections.internal.DriverConnectionCreator.makeConnection(DriverConnectionCreator.java:55)
... 160 more
Caused by: java.io.IOException: SQL Server did not return a response. The connection has been closed. ClientConnectionId:.....
at com.microsoft.sqlserver.jdbc.TDSChannel$SSLHandshakeInputStream.ensureSSLPayload(IOBuffer.java:651)
at com.microsoft.sqlserver.jdbc.TDSChannel$SSLHandshakeInputStream.readInternal(IOBuffer.java:708)
at com.microsoft.sqlserver.jdbc.TDSChannel$SSLHandshakeInputStream.read(IOBuffer.java:700)
at com.microsoft.sqlserver.jdbc.TDSChannel$ProxyInputStream.readInternal(IOBuffer.java:895)
at com.microsoft.sqlserver.jdbc.TDSChannel$ProxyInputStream.read(IOBuffer.java:883)
at sun.security.ssl.InputRecord.readFully(InputRecord.java:465)
at sun.security.ssl.InputRecord.read(InputRecord.java:503)
at sun.security.ssl.SSLSocketImpl.readRecord(SSLSocketImpl.java:973)
at sun.security.ssl.SSLSocketImpl.performInitialHandshake(SSLSocketImpl.java:1375)
at sun.security.ssl.SSLSocketImpl.startHandshake(SSLSocketImpl.java:1403)
at sun.security.ssl.SSLSocketImpl.startHandshake(SSLSocketImpl.java:1387)
at com.microsoft.sqlserver.jdbc.TDSChannel.enableSSL(IOBuffer.java:1618)
... 165 more
This is using com.microsoft.sqlserver.jdbc.SQLServerDriver
Whenever I use the JtDS driver (suggested by eg. this post), I'm still not able to connect to the SQL server and I get the following error.
Caused by: org.hibernate.exception.JDBCConnectionException: Error calling Driver#connect
at org.hibernate.exception.internal.SQLStateConversionDelegate.convert(SQLStateConversionDelegate.java:132)
at org.hibernate.engine.jdbc.connections.internal.BasicConnectionCreator$1$1.convert(BasicConnectionCreator.java:118)
at org.hibernate.engine.jdbc.connections.internal.BasicConnectionCreator.convertSqlException(BasicConnectionCreator.java:140)
at org.hibernate.engine.jdbc.connections.internal.DriverConnectionCreator.makeConnection(DriverConnectionCreator.java:58)
at org.hibernate.engine.jdbc.connections.internal.BasicConnectionCreator.createConnection(BasicConnectionCreator.java:75)
at org.hibernate.engine.jdbc.connections.internal.DriverManagerConnectionProviderImpl.configure(DriverManagerConnectionProviderImpl.java:106)
at org.hibernate.boot.registry.internal.StandardServiceRegistryImpl.configureService(StandardServiceRegistryImpl.java:111)
at org.hibernate.service.internal.AbstractServiceRegistryImpl.initializeService(AbstractServiceRegistryImpl.java:234)
at org.hibernate.service.internal.AbstractServiceRegistryImpl.getService(AbstractServiceRegistryImpl.java:206)
at org.hibernate.engine.jdbc.internal.JdbcServicesImpl.buildJdbcConnectionAccess(JdbcServicesImpl.java:260)
at org.hibernate.engine.jdbc.internal.JdbcServicesImpl.configure(JdbcServicesImpl.java:94)
at org.hibernate.boot.registry.internal.StandardServiceRegistryImpl.configureService(StandardServiceRegistryImpl.java:111)
at org.hibernate.service.internal.AbstractServiceRegistryImpl.initializeService(AbstractServiceRegistryImpl.java:234)
at org.hibernate.service.internal.AbstractServiceRegistryImpl.getService(AbstractServiceRegistryImpl.java:206)
at org.hibernate.cfg.Configuration.buildTypeRegistrations(Configuration.java:1887)
at org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:1845)
at org.hibernate.jpa.boot.internal.EntityManagerFactoryBuilderImpl$4.perform(EntityManagerFactoryBuilderImpl.java:857)
at org.hibernate.jpa.boot.internal.EntityManagerFactoryBuilderImpl$4.perform(EntityManagerFactoryBuilderImpl.java:850)
at org.hibernate.boot.registry.classloading.internal.ClassLoaderServiceImpl.withTccl(ClassLoaderServiceImpl.java:425)
at org.hibernate.jpa.boot.internal.EntityManagerFactoryBuilderImpl.build(EntityManagerFactoryBuilderImpl.java:849)
at org.hibernate.jpa.HibernatePersistenceProvider.createEntityManagerFactory(HibernatePersistenceProvider.java:75)
... 143 more
Caused by: java.sql.SQLException: I/O Error: DB server closed connection.
at net.sourceforge.jtds.jdbc.TdsCore.nextToken(TdsCore.java:2481)
at net.sourceforge.jtds.jdbc.TdsCore.login(TdsCore.java:632)
at net.sourceforge.jtds.jdbc.JtdsConnection.<init>(JtdsConnection.java:371)
at net.sourceforge.jtds.jdbc.Driver.connect(Driver.java:184)
at org.hibernate.engine.jdbc.connections.internal.DriverConnectionCreator.makeConnection(DriverConnectionCreator.java:55)
... 160 more
Caused by: java.io.IOException: DB server closed connection.
at net.sourceforge.jtds.jdbc.SharedSocket.readPacket(SharedSocket.java:852)
at net.sourceforge.jtds.jdbc.SharedSocket.getNetPacket(SharedSocket.java:731)
at net.sourceforge.jtds.jdbc.ResponseStream.getPacket(ResponseStream.java:477)
at net.sourceforge.jtds.jdbc.ResponseStream.read(ResponseStream.java:114)
at net.sourceforge.jtds.jdbc.TdsCore.nextToken(TdsCore.java:2368)
... 164 more
The connection string I use: (using jtds)
jdbc:jtds:sqlserver://url.database.windows.net:[PORT];database=name;
OR when not using jtds..
jdbc:sqlserver://url.database.windows.net:[PORT];database=name;
I also have a server that is actually able to run and connect to the database using these configurations. I just keep getting these errors trying to connect to the database locally.
I am running macOS Sierra version 10.21
jtds version:
<dependency>
<groupId>net.sourceforge.jtds</groupId>
<artifactId>jtds</artifactId>
<version>1.3.1</version>
</dependency>
sqlserver version:
<dependency>
<groupId>com.microsoft.sqlserver</groupId>
<artifactId>sqljdbc4</artifactId>
<version>4.0</version>
</dependency>
EDIT:
I am able to connect to the database using the same configuration AND same laptop on a different network. It is only on my network at home that I get this error
解决方案
I suspect that when your laptop is on a "different network" that it is then inside the firewall that is also protecting the database servers you are connecting to. Hence, there is no problem making the database connections for this case.
Your "network at home" I presume is outside of the firewall protecting the database servers that you are trying to connect to. Hence, your database connection attempts for this case are being ignored due to the firewall protection.
If these assumptions are correct, you will need to contact the network administrator of the "different network" to gain access through the firewall from your home network.
I hope this helps.
这篇关于驱动程序无法使用SSL建立与SQL Server的安全连接的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
查看全文
