Configuring a FileNet database for SQL Server

You must enable XA transactions on every Microsoft SQL Server.

About this task

You must enable XA transactions on every Microsoft SQL Server that has a Content Platform Engine database. To enable XA transactions for Content Platform Engine databases:

Procedure

  1. Download the Microsoft SQL Server JDBC Driver.
    Note: Installation procedures for JDBC settings can vary by release. See the Microsoft website for full details.
  2. Copy sqljdbc_xa.dll from the JDBC installation directory to the install_dir\Binn directory.
    For example, 
    C:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\Binn

    install_dir is the directory where you installed Microsoft SQL Server.

  3. Log in to the SQL Server Management Studio as the sa administrator or as a user with equivalent permissions and execute the database script xa_install.sql on the master database on every SQL Server instance that participates in distributed transactions.
    Note: Use SQL Server database credentials, not Windows credentials, to log in. Windows Integrated Logon to SQL Server is not supported by IBM FileNet P8. This script installs sqljdbc_xa.dll as an extended stored procedure and creates the SqlJDBCXAUser role in the Master database.
    1. Click New Query.
    2. Copy the content of C:\Microsoft JDBC Driver 4.0 for SQL Server\sqljdbc_4.0\enu\xa\xa_install.sql into the query window.
    3. Click Execute to run the scripts.
  4. Add the database account that Content Platform Engine uses to access SQL Server to the SqlJDBCXAUser role. This action grants permissions to those accounts to participate in distributed transactions with the JDBC driver as follows:
    1. Click Security > Logins > FNGCDUser, and then right-click FNGCDUSER and choose Properties.
    2. Select the User Mapping tab in the open window.
    3. Select FNGCD and master databases.
    4. Select SQLJDBCXAUser in the list.
  5. Add the database account that Content Platform Engine uses to access SQL Server for the FNOSUSER.
    1. Click Security > Logins > FNOSUSER, and then right-click FNOSUSER and choose Properties.
    2. Select the User Mapping tab in the open window.
    3. Select FNOS and master database.
    4. Select SQLJDBCXAUser in the list.
  6. Click Administrative Tools > Component Services > Computers > My Computer > Distributed Transation Coordinator Properties > Local DTC, and then right-click Local DTC and select Properties. On the Security tab, select enable XA transactions.