Preparing the SQL Server database server

During the profile creation or augmentation process, you can configure the Common database that is used by selected components, or you can postpone the database configuration by producing scripts that must be run manually by you or your database administrator (DBA). The other required databases are configured during network deployment.

Before you begin

Before creating a profile, you must install Microsoft SQL Server on the server that hosts the database.

Restriction: The Process Server database (BPMDB) and the Performance Data Warehouse database (PDWDB) must NOT be case-sensitive. Other databases can be case-sensitive. If you are using the SQL files to create the database for Business Process Choreographer, the SQL files create case-sensitive names for the databases.

When you create your database schemas, you must have a user ID with enough authority to create your tables. After the tables are created, the applications must have enough authority to select, insert, update, and delete information in the tables.

The following table shows the database privileges that are required to access the data store.

Table 1.
Database management system	Minimum privilege required to use the data store tables	Additional privilege required to create the data store tables
Microsoft SQL Server	Configure the SQL Server for SQL Server so that authentication can be based on an SQL server login ID and password. The user ID can own the tables or be a member of a group that has sufficient authority to issue TRUNCATE TABLE statements.	The user ID requires the CREATE TABLE statement privilege.

Isolation level specifies the transaction locking behavior. You should set the isolation level to READ_COMMITTED. You can check the isolation level of the Process Server database, the Performance Data Warehouse and the Common database with the following SQL command: SELECT name, is_read_committed_on FROM sys.database. You can set the isolation level with the following SQL command: ALTER DATABASE <database> SET READ_COMMITTED ON.