Troubleshooting
Problem
Administrator installs Controller. Administrator launches "Cognos Configuration" and creates a connection to the ContentStore (Content Manager) database. Administrator tests the connection, but this fails (timeout error). However, when the administrator launches "Controller Configuration" and creates a database connection (from the same application server to the same database) this connection works OK (even using the same id and password). Why does the connection work OK for the Controller "application" database, but not for the Cognos BI "ContentStore" database?
Symptom
When testing database connection:
- IBM Cognos Configuration is performing the following tasks:
TICK Generating cryptographic information
! Testing Content Manager database connection.
[Close] [Details]
[ ERROR ] The database connection failed.
[ ERROR ] Content Manager is unable to access the content store. Verify your database connection parameters, and then contact your database administrator for assistance.
When starting the Cognos BI service:
- CM-CFG-5063 A Content Manager configuration error was detected while connecting to the content store.
CM-SYS-5003 Content Manager is unable to access the content store. Verify your database connection parameters and then contact your database administrator.
Message inside the file 'cogserver.log' (by default C:\Program Files\cognos\c8\logs\cogserver.log)
Failed Logon:com.jnetdirect.jsql.JSQLException: TCP/IP connection failed to host:SERVERNAME java.net.ConnectException: Connection timed out: connect url:jdbc:JSQLConnect://SERVERNAME:1433/Content_Store_Database
[{"Product":{"code":"SS9S6B","label":"IBM Cognos Controller"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Component":"Controller","Platform":[{"code":"PF033","label":"Windows"}],"Version":"8.3","Edition":"","Line of Business":{"code":"LOB76","label":"Data Platform"}},{"Product":{"code":"SSMRTZ","label":"IBM Cognos Controller 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.
Historical Number
1039690
Was this topic helpful?
Document Information
Modified date:
08 May 2025
UID
swg21347881