Cognos 10.2.2 [Content Manager database connection]

[kabularasa]

Hi folks,

So the password expired for the cognos username and I changed it. Now the IBM Cognos -service is not starting and
I'm receiving following error:

[Content Manager database connection]
[ ERROR ] The database connection failed.
[ ERROR ] 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.

I've checked the tcp/ip -port and its correct. Only the password change affected this.

Any help is sought after and appreciated

[Kiran P]

Hi,

Is that the same user you are using for content manager datastore connection as well? If so, go to IBM Configuration > Content Manager. Test your content store and make sure test is successful. You may need to check the credentials being used to connect.

Thanks,
Kiran

[kabularasa]

Yes, It's the same one, I receive following error when testing:

[Content Manager database connection]
[ ERROR ] The database connection failed.
[ ERROR ] 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.

Do I have to reset someking of store in order to cognos to update the new password?

[Kiran P]

Yes, It's the same one, I receive following error when testing:

[Content Manager database connection]
[ ERROR ] The database connection failed.
[ ERROR ] 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.

Do I have to reset someking of store in order to cognos to update the new password?

Hi

You need to update the content store binding credentials with the new password in cognos configuration.

And also make sure the database mentioned for content store in the configuration is in fact accessible with the credentials you are using. For this you can try connecting to the data base from SQL server mgmt studio if you are using SQL server or a similar tool for other databases.

Thanks
Kiran

[RubenvdLinden]

Which database platform are we talking about?

If you reset an expired Oracle password, make sure you also UNLOCK the user. Resetting the password is not enough!

ALTER USER <username> IDENTIFIED BY <password> ACCOUNT UNLOCK;

[kabularasa]

I Changed the credentials in the content store, do I need to reset them from elsewhere aswell and how it's done?

Environment:

SQL Server 2008 R2

[RubenvdLinden]

On the Cognos server, start Cognos Configuration, go to Data Access > Content Manager > [Your content store database].
Change your credentials.