IBM Support

Error connecting to the database, some services may not work properly.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. TLS 1.2 Upgrade

Troubleshooting


Problem

After upgrading TLS version to TLS 1.2 Cognos services fail to start with the following error :
StartService    LogService        FAILED    Log Server Database error    <parameters><item name="DB URL">
jdbc:sqlserver://XXX:1433;databaseName=cognos11_audit_QA]]></item><item name="DB Error">
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.

Symptom

Cognos services will fail eventually with the following error message :
CFG-ERR-0106 IBM Cognos Configuration did not receive a response from the IBM Cognos service in the time allotted.
Check that IBM Cognos service is available and properly configured.

Document Location

Worldwide

[{"Business Unit":{"code":"BU048","label":"IBM Software"},"Product":{"code":"SSTSF6","label":"IBM Cognos Analytics"},"Component":"bootstrap","Platform":[{"code":"PF016","label":"Linux"},{"code":"PF033","label":"Windows"}],"Version":"CA 11.0.8;CA 11.0.9;CA 11.0.10;CA 11.0.10;CA 11.0.11;CA 11.0.12;CA 11.0.13;CA 11.1","Edition":"","Line of Business":{"code":"LOB76","label":"Data Platform"}},{"Product":{"code":"SS6G84","label":"IBM Cognos Analytics on Cloud"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Component":" ","Platform":[{"code":"","label":""}],"Version":"","Edition":"","Line of Business":{"code":"LOB76","label":"Data Platform"}}]

Log InLog in to view more of this document

This document has the abstract of a technical article that is available to authorized users once you have logged on. Please use Log in button above to access the full document. After log in, if you do not have the right authorization for this document, there will be instructions on what to do next.

Document Information

Modified date:
01 May 2025

UID

ibm10964810