Configuring database server settings

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

1. Open the IBM ICM Windows Service.exe.config file.
2. In the databaseServers section, complete the following steps:
   1. Edit 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. Edit the User.

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

   3. Type the Password.

      This is the password that corresponds to the database user.

   4. Edit the Address.

      This address points to the location of the database. Use the following format for the address: 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, SERVER_NAME\INSTANCE_NAME, PORT_NUMBER).

   5. Edit the Type of database.

      To use SQL Server 2016, all configurations must be done as if using SQL Server 2014. For example, if the database you are using is SQL Server 2016, then type sqlserver2014 or sqlserver2014unicode.

   6. Edit the DiskPath.

      This is the location where databases are created and stored.

   7. Edit 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 Incentive Compensation Management can warn of a network or server issue. For models with long calculation times, you can increase this time to avoid a database timeout during calculation.