Installation Guide › WebSphere Version › Installation Prerequisites › How to Install Prerequisite Components › WebSphere Application Server › Enable XA Transactions for Microsoft SQL Server

Enable XA Transactions for Microsoft SQL Server

If you are using WebSphere with Microsoft SQL Server, enable XA transactions on Microsoft SQL Server. CA Identity Manager needs an XA data source for the database transactions to work properly.

To enable XA Transactions for Microsoft SQL Server

1. Download the SQL Server JDBC Driver version 2.0 from Microsoft.

   Note: The download may first present an HTM file that is a license agreement for you to approve.

2. Run the program to install the JDBC driver.
3. Perform the following two procedures included in the Microsoft topic Understanding XA Transactions:
   • Running the MS DTC Service
   • Configuring the JDBC Distributed Transaction Components

   In performing these procedures, verify the following are true:

   • When you run the xa_install.sql script, make sure you get a script complete message. You can ignore the drop table errors, which appear the first time that you run the script.
   • When you add the user to the SqlJDBCXAUser role, add that user to the master database.