Why am I receiving I/O Error: DB server closed connection when I attempt to connect to my database?
Article ID: 255
Category: Web Reports
Applies to: 3.0
Updated: 2018-11-08
Since Java 6 update 29 there is a default protection that prevents connections with SQL Server when Forced Encryption is enabled. According to support.microsoft.com, "This issue occurs because the SQL Server engine cannot handle login records when SSL data is split into multiple Tabular Data Stream (TDS) packets."
https://support.microsoft.com/kb/2653857
Option 1
Installing the latest service pack may resolve this issue:
- SQL Server 2012 Production version and later
- SQL Server 2008 Service Pack 3 Cumulative Update 4
- SQL Server 2008R2 Service Pack 1 Cumulative Update 6
- SQL Server 2008R2 Service Pack 2
Option 2
If the latest service pack does not resolve the issue, it is possible to disable the protection.
Please make this change at your own risk.
From the Command Prompt:
1 |
cd \Program Files (x86)\EventSentry\WebReports\web\bin\ |
1 |
es_webreports_svc.exe //US/EventSentryWebReports ++JvmOptions="-Djsse.enableCBCProtection=false" |
