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:
- Configure the JDBC Distributed Transaction Components by completing the following steps on
every SQL Server to be used as a Federator database:
- Download the Microsoft SQL Server JDBC driver that is specified on the
IBM®
FileNet® P8 system requirements web page.
- 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.
- 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.
- Create a Microsoft SQL Server database.
Set an initial size of at least 200 MB.
- Create a database user account. This account is referred to as the cfs_db_user.
- Specify that the account uses SQL Server Authentication when
it connects to the database.
- Select the Federator database as the default database for this account.
- Assign the following database roles to this account:
- 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.
- Enable XA Transactions by completing the following steps on every SQL Server that has a Federator database:
- From Control Panel, open Administrative Tools, and then open Component Services.
- Expand Component Services, right-click My Computer, and then select
Properties.
- Click the MSDTC tab, and then click Security
Configuration.
- Select the Enable XA Transactions check box and click
OK. The MS DTC service is restarted.
- Click OK to close the Properties window and close
Component Services.
- 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.