Cognos Content Database

Hi All,
I am installing a Cognos 8.2 and i am facing an issue..... I had chosen to install the cognos content database alongwith the base installation.
This has created a base database which when i test i get this error message:
Content Manager failed to connect to the content store. The connection string is 'jdbc:derby://localhost:1527/cm'.
I also tried to create a database on the derby shell interface......... using the
connect 'jdbc:derby://localhost:1527/databasename;create=tr ue;user=username;password=password';
but i get an error related to the JAVA.SECURITY.PRIVILEGEDACTIONEXCEPTION: Error opening socket to server XYZ on port 1527 with message : NULL
How can i connect to the content database that comes alongwith the cognos base server installation? also how shall i create a new database for the cognos under such errors?
Thanks and Regards,
Arjun

Popular White Paper On This Topic

On the right side of the screen in this forum, there should be a box titled "Reference Material for This Group". In that box, about 3rd from the bottom is an article titled "Should I "Install Content Store Database" when installing 8.2?" That should tell you what happened, and point you to the document you'll need to use to undo what you did.
Remember - the reason I wrote the article was - oh, never mind - you'll figure it out...

Hi Arjun
The first time you install it, the cognos content database service is not set up yet.
So just start the services using Cognos Configurator, no need to click test.
Then it will show you that it registers "Cognos Content Database" Service and starts it.
When this service is up and running, you can click test if you want, it will pass the test.

To eliminate any potential issues, just re-install cognos using either the built
in db or your own.
The install does not take that long and you could save yourself untold hours
fixing things.
Also, i would strongly recommend using a version other than 8.2 if you are
installing anyway.? 8.3 is good, 8.4 is even better.? Install the latest, again
it will save you many hours.

Copyright 1998-2015 Ziff Davis, LLC (Toolbox.com). All rights reserved. All product names are trademarks of their respective companies. Toolbox.com is not
affiliated with or endorsed by any company listed at this site.