Skip to main content
Planview Customer Success Center

Connection test fails for Cognos Content Store

Symptoms
The connection test for the the Cognos content store fails, although other programs can connect to the SQL server, such as ODBC configuration.
 
Error/Warning Messages:
There is no error message on the Cognos machine.
On the SQL server, there are entries in the windows event log saying that only encrypted connections are allowed to this SQL server.
 
Reason
Cognos cannot connect because the SQL server is locked down and requires encrypted connections.


Resolution
On the SQL server machine, in SQL Server Configuration Manager on the protocols section, set "Force Encryption" to No.