IBM Support

Connection to SQL Server fails when the server is configured to use TLS 1.2 or connecting to SQL Server 2016

Troubleshooting


Problem

When the SQL Server machine is configured to disable TLS 1.0 and 1.1, only allowing TLS 1.2 or when connecting a SqlServer of version 2016 or higher, Cognos must make a TLS 1.2 connection to it even if SQL Server is not forcing encryption and there is no SSL certificate involved.

Symptom

An example error connecting to the Content Store might be:

CM-CFG-5063 A Content Manager configuration error was detected while connecting to the content store.  

CM-SYS-5003 Content Manager is unable to connect to the content store. Verify that the database connection properties in the configuration tool are correct and that when you test the connection, the test is successful. 

Cause: The driver could not establish a secure connection to SQL Server as SQL Server cryptography require TLS1.2 interaction under such server environment or connection to any SQL Server database of version 2016 or higher.

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

 

[{"Business Unit":{"code":"BU048","label":"IBM Software"},"Product":{"code":"SSTSF6","label":"IBM Cognos Analytics"},"ARM Category":[{"code":"a8m50000000Cl3yAAC","label":"Installation and Configuration"}],"ARM Case Number":"","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"All Version(s)","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

More support for:
IBM Cognos Analytics

Component:
Installation and Configuration

Software version:
All Version(s)

Document number:
571589

Modified date:
01 May 2025

UID

swg22016796