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.".
Log InLog in to view more of this document
Was this topic helpful?
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