Create a database

Use the following checklist to help you create a database in Microsoft SQL Server.

  • Ensure that the collation sequence is case-insensitive.

    In a custom installation, you choose a collation, which includes character sets and sort order, during the SQL Server setup. In a typical installation, the installation uses the locale identified by the installation program for the collation. You cannot change this setting later.

  • For Microsoft SQL Server, grant EXECUTE permission to the user account that accesses the database.

    Under Security for the new database, create a schema and assign a name to it.

    Under Security for the new database, create a user with the following settings:

    • For Login name, specify the new login that you created for the user account.
    • For Default schema, specify the new schema.
    • For Owned Schemas, select the new schema.
    • For Role Members, select db_datareader, db_datawriter, and db_ddladmin.

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.
  2. Create the database.
    This database is used when you configure the Cognos Controller components in Configure Cognos Controller.