Previous Topic: Run Setup UtilityNext Topic: Configure Security Module


Set up Database Module

Set up the database so that the CA Service Catalog users and the catalog system can function correctly.

Follow these steps:

  1. Select the database to connect from the Database Type drop-down list.
    Select Vendor

    Specifies the database software vendor.

    Deploy MDB Database

  2. Verify or complete the fields in the Database Connectivity section:
    Hostname

    Specifies the computer name of the Microsoft SQL Server (SQL Server).

    Default: localhost

    Port

    Specifies the TCP Port number of the database server.

    Default: 1433

    Installation User Username and User Password

    Specifies the user name and password of the SQL Server database administrator (DBA). The setup utility uses these credentials to set up the CA Service Catalog database.

    Default Username: sa

    Instance Name

    Defines the SQL Server instance name for the MDB. For example, myinstance. You can specify either a primary instance or a named instance.

  3. Specify the name of the CA Service Catalog database, In the Database Settings section, typically MDB.
    Database Name

    Specifies the name of the CA Service Catalog database.

    Default Database Name: mdb

    To install the CA Service Catalog database schema into an existing database, specify the name of that database.

    Follow these guidelines:

    • If you plan to integrate CA Service Catalog with any other CA product that uses the MDB, specify mdb as the database name.
    • If you want CA Service Catalog to run on its own database, you can specify a different database name other than mdb. To integrate with other CA products in the future, use the setup utility to change your custom database name to mdb.
    • For an upgrade, use the same database name as you used for the previous release. Most likely, this name is mdb.
  4. Specify the Application User Settings.
    Username and Password fields

    Specifies the user name and password for accessing this database.

    The user name and password are created in the database. CA Service Catalog uses this user name and password to connect to the database.

    Important! Record the passwords for reference in the Installation Worksheet.

  5. Click Save.
  6. Click OK when prompted to confirm the deployment of the database on host.
  7. Click OK when prompted to restart the database service for changes to take effect.

    A confirmation message appears. The database setup takes several minutes to complete.

    The CA Service Catalog database setup is complete.