Configure a FileNet database for SQL Server

You must enable XA transactions on every Microsoft SQL Server.

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

1. Download the Microsoft SQL Server JDBC Driver.

   Installation procedures for JDBC settings can vary by release. See the Microsoft website for full details.

2. Copy the sqljdbc_xa.dll from the JDBC install directory to the binn folder of the instance, although a pre-2.0 version of the driver also functions correctly from the tools\binn folder. For the 32-bit version of Microsoft SQL Server, use the sqljdbc_xa.dll file in the x86 folder. For the 64-bit version of Microsoft SQL Server, use the sqljdbc_xa.dll file in the x64 folder. For example, copy:

   • C:\Microsoft JDBC Driver 4.0 for SQL Server\sqljdbc_4.0\enu\xa\x86\sqljdbc_xa.dll into C:.(x86)\Microsoft SQL Server\110\Tools\Binn;

   • C:\Microsoft JDBC Driver 4.0 for SQL Server\sqljdbc_4.0\enu\xa\x64\sqljdbc_xa.dll into C:.Microsoft SQL Server\110\Tools\Binn

   Attention: Both the 32-bit and 64-bit DLLs need to be copied.

3. Log into 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 will participate in distributed transactions.

   Use SQL Server database credentials, not Windows credentials, to log in. Windows Integrated Logon to SQL Server is not supported with 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 each 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 :
   Security | Logins | FNGCDUser ( right-click FNGCDUSER | Properties | User Mapping tab | FNGCD and master databases | SQLJDBCXAUser

5. Add each database account that Content Platform Engine uses to access SQL Server for the FNOSUSER.
   Security | Logins | FNOSUSER | right-click FNOSUSER | Properties | User Mapping tab | FNOS and master database | SQLJDBCXAUser

   Click...

   Administrative Tools | Component Services | Computers | My Computer | Distributed Transation Coordinator Properties | Local DTC | right-click Local DTC | Properties | Security tab | enable XA transactions

   
   Parent topic:
   Create databases