Configuring access to multiple databases

If you have multiple database servers, the IBM® Cognos® ICM Windows Service.exe.config file allows multiple database sections to be configured. This allows you to access both Unicode and non-Unicode SQL models with a single service. By default, there is only one section in the configuration file, but others can be added. All models contained on each database server configured in the service configuration file are accessible from the login screen.

Procedure

Open the Cognos Incentive Compensation Management Windows Service configuration file.
Complete a <databaseServer> section for each of your servers.
Attention: Cognos Incentive Compensation Management cannot run without a service. It is not possible to enter database information in the IBM Cognos ICM.exe.config file in order to bypass the service and access the database directly.

The following example shows a configuration for a non-Unicode Microsoft SQL server model and a Unicode Microsoft SQL Server model to run on the same Cognos Incentive Compensation Management Windows Service.
```
<databaseServers>
	<databaseServer Name="NonUnicodeModel"
					Address="(local)"
					Type="SQLServer2008"
					User="sa"
					Password=""
					DiskPath="D:\"
					LogPath="D:\"
					TimeoutSeconds="90">
	</databaseServer>

	<databaseServer Name="UnicodeModel"
					Address="(local)"
					Type="SQLServer2008unicode"
					User="sa"
					Password=""
					DiskPath="D:\"
					LogPath="D:\"
					TimeoutSeconds="90">
	</databaseServer>
</databaseServers>
```