Creating the ActiveMatrix Administrator Database Using SQL Server
Create a SQL Server database, configure it, and create a database user to access it.
- Procedure
- 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.
- 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
- 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® Service Grid Administrator Server Wizard.
- Ensure that the database is set to use case insensitive (CI) collation.
- Make sure that the database is available.