Popular White Paper On This Topic

1? Restore the SQL Server database that is your content store from a good backup.
2? Create a new database and import your last entire content store export that you took.

I hope you performed an entire content store export every night on a schedule.

If the above do not apply then you need to backup your content store database, perform an internal consistency check within Cognos Administration to see if you can sort out the corruption.
Failing all those then you need to send the backup to IBM Support and hope they can do something with it for you.

Thanks Andy,
This problem happened with my personal Lappy. Glad that our enterprise content store is perfect and I already assigned the roles and responsibilites to others. They are able to access the studios.

Coming to my scenario, I gave some users (NTLM) as SYS ADMIN, DIECTORY ADMIN and all the rest administrators but couldn't access any of the studios and administration. So, I deleted that NTLM from the Cognos Configuration and I created a new one but still the same issue. I do not have any tables except repository tables. So I could have created new database but its not feasible so I wanted to know the procedure to do it. I am using Oracle DB.

I had a discussion with my Server team and they informed me that Windows 2000 can be upgraded to Windows 2003 and we do not need to uninstall the application or do a format.
So, if the Software is compatible then it will work in Windows 2003. My only challenge is, if they are not compatible then I do not have option to rollback.

Please note, deleting namespace from Cognos configuration will not deleting
all related settings relative to this namespace. I believe those setting go
by id not names you see in configuration. If you add back namespace with
same name, it will be massed up with deleted one. You better to keep old
one but disable it.

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.