Cognos database considerations for Microsoft SQL Server

IBM® Cognos® Business Intelligence uses the COGNOSCS (IBM Cognos BI content store) database for configuration and report specification information, and uses the MONITOR database for actual reporting data.

Important: The IBM Cognos BI database requires collation that is not case-sensitive, while the IBM Business Monitor database requires a case-sensitive collation. If the default collation is changed for the IBM Cognos BI database, the collation must NOT be case-sensitive.

The IBM Cognos BI service creates tables in the IBM Cognos BI content store database the first time it is started. Because the database user provided for accessing the content store database must have privilege to create tables in the database, it is recommended that you create a new database user for the content store database only.

The COGNOSCS database must be used only for IBM Business Monitor data. You must not add data directly to the COGNOSCS database, or use the database with other databases to create reports against such data (combined or not with data created in IBM Business Monitor).