Add a Controller Database Connection

You must set up a Controller database connection during the IBM® Cognos® Controller installation and configuration process.

Procedure

  1. From the Start menu, start Controller Configuration.
  2. In the Explorer window, click Database Connections, and then click File > New.
  3. In the Properties window, click the Database type box, and then use the drop-down arrow to select the database type.

    You can choose SQL Server.

  4. In the Name box, type a name for the database.

    Choose a name that is meaningful for IBM Cognos Controller users.

  5. In the Provider box, type the name of the database provider.

    To obtain the database provider information, see the SQL Server documentation.

  6. In the User ID and Password boxes, type the user name and password for the Controller database.
  7. In the Initial catalog box, type the Controller database name.
  8. In the Data source box, type the database server computer name.

    Tip: Do not use localhost.

  9. Click File > Save.
  10. In the Explorer window, expand Database Connections.
  11. Select the database that you want to upgrade.
  12. Click Actions > Run.
  13. If no Java™ is found, browse to and select the Java 8 JRE in the installdir\bin64\jre\8.0\ directory.
  14. Click Connect, and then Upgrade.

    The Database Conversion Utility upgrades the existing database.

  15. Click Close.
  16. Click Actions > Check.

    If the database connection validation fails, review the database connection properties and fix any errors.

  17. Click File > Save.