Summary
This article discusses how to reset the Content Store database used by Flexera Analytics (Report Designer ), which is based on IBM Cognos technology.
Discussion
The following steps can recreate or reset an initial Content Store database.
- Invoke IBM Cognos Configuration by running the "<Report Designer installed directory>\c10\bin\fnhccfg.bat"
- Stop the IBM Cognos service
- Run SQL Server Management Studio
- Drop the ContentStore database
- Recreate the ContentStore database
- Grant the service account used by IBM Cognos db_owner rights to the ContentStore database
- Back in the IBM Cognos Configuration UI, start the IBM Cognos service