Creating the ActiveMatrix Administrator Database Using SQL Server

Create a SQL Server database, configure it, and create a database user to access it.

Procedure

  1. Create an empty database which will be used to hold the ActiveMatrix Administrator database tables - for example, amx.
    Note: The ActiveMatrix BPM database (for each BPM system) and ActiveMatrix Administrator database can, if desired, use the same SQL Server database instance.
  2. Enable snapshot isolation by setting the ALLOW_SNAPSHOT_ISOLATION ON database option.

    For example, use the following statements:

    ALTER DATABASE DatabaseName

    SET READ_COMMITTED_SNAPSHOT ON

  3. Create a database user (or identify an existing one) for the system to use to connect to the ActiveMatrix Administrator database - for example, amx_db_user. This user:
    • must be a member of the db_owner role for this database
    • must have this database assigned as their default database.

    You will specify this user in the Username field of the Administrator Server Configuration: Database Details screen when you run the Create TIBCO ActiveMatrix BPM Server Wizard or Create TIBCO ActiveMatrix Administrator Server Wizard.

  4. Ensure that the database is set to use case insensitive (CI) collation.
  5. Make sure that the database is available.