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

Question

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.

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, Nov 05 '18 at 11:46
Firewall protection? How can I make the firewall allow this connection? — Manohar Emani, Nov 06 '18 at 04:30
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, Nov 06 '18 at 05:02
Can you mention any trusted source other than Microsoft. I'm restricted to download from MS. — Manohar Emani, Nov 08 '18 at 02:57

score 2 · Answer 1 · edited Mar 31 '20 at 05:46

2

Edit $JAVA_HOME\jre\lib\security\java.security
Find jdk.tls.disabledAlgorithms=
Remove 3DES_EDE_CBC

This should fix it!

edited Mar 31 '20 at 05:46

nj2237

1,220
3
21
25

answered Mar 31 '20 at 02:41

Bourne Jiang

21
2

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

1 Answers1

Linked