IBM Support

Unable to connect to MS SQL Server Content Store database when TLS 1.0 is disabled on the server

Troubleshooting


Problem

Content Store database connection fails with generic connection failed error message when TLS 1.0 is disabled on the server.

Cause

IBM JRE that comes shipped with the product defaults to use TLS 1.0 when JDBC driver makes SSLContext.getInstance("TLS") call.

Environment

Windows environment with TLS 1.0 disabled in registry settings

Resolving The Problem

Under <install directory>/bin64 directory find the bootstrap_wlp_win64.xml and make a backup copy before making modifications.
Open the file in text editor and add the following parameter:
<param condName="${java_vendor}" condValue="IBM">"-Dcom.ibm.jsse2.overrideDefaultTLS=true"</param>

This setting will allow you to override the JAVA default and use a higher version of TLS.
The setting will only be picked up during startup of therefore testing the data source in Cognos Configuration will still fail. To confirm the change correct the issue a start of the service is required.

[{"Product":{"code":"SSTSF6","label":"IBM Cognos Analytics"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Component":"Administration and Configuration v11x","Platform":[{"code":"PF033","label":"Windows"}],"Version":"11.0.10;11.0.9;11.0.8","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
15 June 2018

UID

swg22015898