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 1.2 from Microsoft.

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

2. Open the default help in the downloaded SQL Server Driver package.
3. Search for the XA transactions in the help.
4. In the Understanding XA Transactions, perform the following procedures:
   • 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, that user needs to be in the master database.