Configuring the database server settings

You must edit the <databaseServers> block in the IBM® Cognos® Incentive Compensation Management Windows Service configuration file to correspond with your database server. By default, the file is set up for connection to a Microsoft SQL Server 2008 database.

Procedure

  1. Open the IBM Cognos ICM Windows Service.exe.config file.
  2. In the databaseServers section, do the following tasks:
    1. Modify the database server Name.

      This can be an arbitrary name, such as Super Server, and is intended to identify and distinguish the database server. If your database is a Microsoft SQL Server 2000 named instance, or if you are using a Microsoft SQL Server 2005 database, the value for the DB Server field must use the following format: SERVER_NAME\INSTANCE_NAME.

    2. Modify the User.

      This is the same as the database user. For Microsoft SQL Servers, Cognos Incentive Compensation Management requires SQL Authentication or Windows Authentication in order to connect. Therefore, you must connect using a local database user. If you are using Windows Authentication, both the user and password values should remain blank.

    3. Type the Password.

      This is the password that corresponds to the database user.

    4. Modify the Address.

      This address points to the location of the database. The Address should use the following format: SERVER_NAME\INSTANCE_NAME. If SQL Server is not using the default port 1433, you must add the port number to the server address field (for example, SEVER_NAME\INSTANCE_NAME, PORT_NUMBER).

    5. Modify the Type of database.
    6. Modify the DiskPath.

      This is the location where databases are created and stored.

    7. Modify the LogPath.

      This is the location where the log file is created and stored.

    8. Modify the TimeoutSeconds.

      This is the number of seconds before a timeout occurs. The database timeout default is 90 seconds. This is the minimum amount of time that clients must wait before Cognos Incentive Compensation Management can warn of a network or server issue. For models with very long calculation times, this time may be increased to avoid a database timeout during calculation.

Parent topic: Edit the IBM Cognos Incentive Compensation Management Service configuration file