Connecting to an MS SQL database in Compatible mode

Connect the Tivoli® Common Reporting to an MS SQL database.

Before you begin

User role image Perform this task with the support of a database administrator.

Make sure that you installed an MS SQL database client on the computer where Cognos-based Tivoli Common Reporting engine is installed.

To configure the database, connect the database to a client, and activate the optional cross-database functionality.

Connect the MS SQL client to the database server by running the MS SQL Management Studio Express, configuring the local net service name configuration, and restarting your system.
Important: Note the name of the connection you have created as it is used in one of the following steps.
Create a database connection for Cognos® as follows:
1. Log in to the relevant reporting interface in your environment. Logging in to the reporting interface.
2. Select Launch > Administration.
3. In the Configuration tab, click to add a data source.
4. Follow the New Data Source wizard as required noting the following steps:
  - On the second panel, choose an MSSQL Server database as Type and clear the Configure JDBC connection option.
  - On the third panel, specify the name of the connection that you noted before as the Server name, and in the Signon section specify a new User ID and Password.

You have now connected your Tivoli Common Reporting to an MS SQL database.