FileNet P8 Content Federation Services, Version 5.2.1   Database:  SQL          

Creating a Microsoft SQL Server database and user account

In a Microsoft SQL Server environment, the database administrator creates the database, table space, and user account.

Procedure

To create a database, table space, and user account for content federation:

  1. Configure the JDBC Distributed Transaction Components by completing the following steps on every SQL Server to be used as a Federator database:
    1. Download the Microsoft SQL Server JDBC driver that is specified on the IBM® FileNet® P8 system requirements web page.
    2. Copy the sqljdbc_xa.dll file from the JDBC installation directory to the C:\Program Files\Microsoft SQL Server\MSSQL$instance name\Bin directory. If you use a 32-bit processor, use the sqljdbc_xa.dll file in the x86 folder. If you use a 64-bit processor, use the sqljdbc_xa.dll file in the x64 folder.
    3. Log on as a database administrator and run the xa_install.sql database script on every SQL Server instance that participates in distributed transactions. This script installs the sqljdbc_xa.dll file as an extended stored procedure and creates the SqlJDBCXAUser role in the Master database.
  2. Create a Microsoft SQL Server database. Set an initial size of at least 200 MB.
  3. Create a database user account. This account is referred to as the cfs_db_user.
    1. Specify that the account uses SQL Server Authentication when it connects to the database.
    2. Select the Federator database as the default database for this account.
    3. Assign the following database roles to this account:
      • public
      • db_owner
  4. Add the account to the Microsoft SQL Server master database and grant it the public and SqlJDBCXAUser roles. This action grants permissions to the account to participate in distributed transactions with the JDBC driver.
  5. Enable XA Transactions by completing the following steps on every SQL Server that has a Federator database:
    1. From Control Panel, open Administrative Tools, and then open Component Services.
    2. Expand Component Services, right-click My Computer, and then select Properties.
    3. Click the MSDTC tab, and then click Security Configuration.
    4. Select the Enable XA Transactions check box and click OK. The MS DTC service is restarted.
    5. Click OK to close the Properties window and close Component Services.
    6. Stop and restart SQL Server.
    Important: Use SQL Server database credentials, not Windows credentials, to log on. Windows Integrated Logon to SQL Server is not supported.


Last updated: October 2015
cfsin017.htm

© Copyright IBM Corporation 2015.