Error occurs when linking tomcat msql.

Question

Error "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" accessing Microsoft SQL Server database. ClientConnectionId:730b2f11-cca7-49a8-9227-de381e4d6aac".

Error occurs when linking tomcat msql.
MSSQL SSL is disabled.
Tomcat is ssl disabled.

It works fine with jdk 1.8 but only with jdk 1.7 errors.

my jdbc url

jdbc:sqlserver://ip:1433;databasename=~;encrypt=false

• version

tomcat 7.0

jdk 1.7

Windwos 2019 std

MSSQL 2016, mssql-jdbc-6.4.0.jre7.jar

Answer 1

Hi @해리 김,

Please refer to these:
System requirements for the JDBC driver:

https://learn.microsoft.com/en-us/sql/connect/jdbc/system-requirements-for-the-jdbc-driver?view=sql-server-ver16

Using the JDBC driver:

https://learn.microsoft.com/en-us/sql/connect/jdbc/using-the-jdbc-driver?view=sql-server-ver16

Best regards,

Seeya

---

If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".