Configuring the BPM Database Server Using SQL Server
Create a SQL Server instance, configure it, and restart it.
- Procedure
- Create a SQL Server instance that will be used to hold the ActiveMatrix BPM database.
Note: The ActiveMatrix BPM database (for each BPM system) and ActiveMatrix Administrator database can, if desired, use the same SQL Server instance.
- Configure the SQL Server instance to use mixed (Windows and SQL Server) authentication.
- Enable the TCP/IP network protocol for the SQL Server instance.
For example:
- In SQL Server Configuration Manager, expand SQL Server Network Configuration.
- Click Protocols for instance_name where instance_name is the name of the SQL Server instance.
- Right-click TCP/IP and click Enable.
- Enable support for XA transactions.
To do this:
- Download and install the Microsoft SQL Server JDBC Driver. For more information about supported versions, see JDBC Drivers.
- Copy the extended stored procedure dll (sqljdbc_xa.dll) from the location where you installed the Microsoft SQL Server JDBC Driver to the SQL Server instance's
Binn folder.
For example, copy the dll to:
C:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\Binn
- Run SQL Server Management Studio as an administrator of the SQL Server instance.
- From the location where you installed the Microsoft SQL Server JDBC Driver, run the
sqljdbc_n.n\enu\xa\xa_install.sql script against the
master database, where
n.n is the version number of the Microsoft SQL Server JDBC Driver you are using.
Note: The first time you run this you may see errors about failing to drop procedures. These errors may be ignored as the procedures do not exist yet.
- Click .
- Double-click Component Services.
- Right-click Properties. and select
- Click Security. Select Enable XA transactions.
- Restart the SQL Server instance.