Creating and configuring SQL Server databases

If you want to create IBM® Business Process Manager databases on SQL Server, you must also configure XA transactions and create the required users and schemas.

  • Configuring XA transactions for SQL Server
    You must configure XA transactions after the Microsoft SQL Server database is installed and before you start the server. The SQL Server JDBC driver provides support for Java Platform, Enterprise Edition/JDBC 2.0 optional distributed transactions. JDBC connections obtained from the SQLServerXADataSource class can participate in standard distributed transaction processing environments such as Java Platform, Enterprise Edition (Java EE) application servers.
  • Creating SQL Server databases
    You can create the required databases for IBM Business Process Manager either before or after you create the profiles and the deployment environment.
  • Creating users and schemas for SQL Server databases
    You must create the users and schemas after creating the SQL Server databases.
Parent topic: Configuring the profiles and network deployment environment using multiple tools