Create an IBM Cognos Controller Database for Microsoft SQL Server

If you are installing IBM® Cognos® Controller for the first time, you must create an empty Controller database. This is because IBM Cognos Controller requires a configured Controller database to run.

Procedure

  1. If you performed a typical installation of Microsoft SQL Server, after you install you must change the authentication mode to SQL Server and Windows.

    For more information, see the related knowledge base article on the Microsoft Web site.

  2. Create the database.

    Ensure that the database collation sequence is case insensitive, and is the same for both the server and the Controller database.

  3. Determine which user account Controller Web Services Server will use to access the database.
  4. Grant create table privileges for the database to the user account.

    Ensure that the user account is a member of the db_owner role.