Product:

Cognos Analytics 11.1.7

Microsoft SQL server 2019

Issue:

Try to connect to content store database from CA11 installation, in Cognos Configuration give you a error message.

Solution:

Error message:

Content Manager failed to connect to the content store. The connection string is “jdbc:sqlserver://192.168.1.77:1433;databaseName=ca11update;applicationName=IBM_C11_CM”. The error encountered is: “Login failed for user ‘cognos’. ClientConnectionId:

Then you have enter the wrong password.

Error message:

Content Manager failed to connect to the content store. The connection string is “jdbc:sqlserver://192.168.1.77:1433;databaseName=ca11update;applicationName=IBM_C11_CM”. The error encountered is: “Cannot open database “ca11update” requested by the login. The login failed. ClientConnectionId

Then you have enter the wrong name of the database.

 

More information:

https://www.ibm.com/support/pages/content-manager-failed-start-because-it-could-not-load-driver-commicrosoftsqlserverjdbcsqlserverdriver-when-starting-ibm-cognos-service

https://community.flexera.com/t5/FlexNet-Manager-Knowledge-Base/Analytics-Cognos-connection-to-SQL-server-fails-when-server-is/ta-p/113351

https://www.ibm.com/support/pages/cm-sys-5003-content-manager-not-configured-listen-tcpip-when-starting-cognos-bi-service