Error: "SQL Server did not return a response. The connection has been closed."

0
votes

When I try to connect to the MS SQL Server 2017 Express instance from JSP using JDBC driver 4.2, I get the following 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. The connection has been closed.".

Please help me to fix this.

1
sql-serverjspsslexceptionjdbc
any firewall protections are there in the network ? if not then can you upgrade the jdbc version to the latest and try again ? – Arunprasanth K V
Firewall protection? How can I make the firewall allow this connection? – Manohar Emani
check with your network administrator, he can help you. before that i request you to use latest version of jdbc driver and try whether this error is coming or not – Arunprasanth K V
where can I get the latest jdbc driver? – Manohar Emani
just google "jdbc download for sql server 2017 " – Arunprasanth K V

1 Answers

1
votes

  1. Edit $JAVA_HOME\jre\lib\security\java.security

  2. Find jdk.tls.disabledAlgorithms=

  3. Remove 3DES_EDE_CBC

This should fix it!