Connection error on SQL Server : DB server closed connection

Connection error on SQL Server : DB server closed connection

Symptom

Error message :

SQL Server : Error : java.io.IOException: DB server closed connection

Where to find the information :

When connecting 360Suite / 360Eyes to SQL Server database

Environment

  • Product : 360Suite / 360Eyes

  • Product Version : All

  • Database : SQL Server 2017 (and higher versions)

Cause

TLS encryption implementation in SQL Server has changed starting version 2017.

All the SQL Server versions can support TLS encryption during the connection but version 2016 and earlier need some additional local configuration, whereas version 2017 and later include it natively (SQL Server side).

You can check the following link to know more about this change :

Resolution


If you encounter this error message during the connection to SQL Server 2017 or higher, it means that your JDBC URL is not compliant with what is expected by SQL Server.
TLS being natively implemented, you will have to use the following JDBC URL format to bypass the local certificate verification and rely on the security method offered by SQL Server :

jdbc:sqlserver://<host>:<port>;databaseName=<db>;encrypt=true;trustServerCertificate=true
 
Here's a Microsoft article about this specific parameter :



    • Related Articles

    • SQL Anywhere: JZ0C0: Connection already closed

      Symptoms When running Web Intelligence (WebI) jobs in SAP BusinessObjects connected to a SQL Anywhere (Sybase) audit database, the job may fail with the following error: JZ0C0: Connection already closed. This results in WebI job crashes and ...

    • Wrong collation for 360Eyes database on SQL Server

      Error Updating SQL Server Password in 360Eyes – Collation Issue Description After updating the SQL Server account password used in 360Eyes, attempts to update the password in the Eyes Configuration (Admin Page) result in a runtime error: [ERROR] ...

    • How to configure SQL Server with Windows Authentication

      Symptom When trying to configure a SQL Server database using Windows Authentication as part of the 360eyes database configuration, the following error is returned: "The driver is not configured for integrated authentication". Environment 360Eyes ...

    • Audit Snapshot Fails in 360Eyes — Unsupported DB URL (jdbc:sqlanywhere)

      Symptoms When running the 360Eyes – Audit job, the job fails during DO_SPECIFIC_JOB_ACTIONS and the log displays: Could not generate snapshot : Current DB URL (jdbc:sqlanywhere:DSN=BIA_Audit_PROD) is not supported. Cause The Audit data source is ...

    • How to install 360Eyes on SQL Server on Azure

      Symptom Installing 360Eyes using SQL Server on Azure. Environment 360Eyes SAP BusinessObjects Enterprise XI 3.1 SAP BusinessObjects Business Intelligence 4.0 SAP BusinessObjects Business Intelligence 4.1 SAP BusinessObjects Business Intelligence 4.2 ...