Installation Guides › Policy Server Installation Guide › XA on MS SQL 2005 › How to Enable XA on MS SQL 2005

How to Enable XA on MS SQL 2005

When using WebSphere with Microsoft SQL 2005, enable XA transactions. Because WebSphere does not exclude data sources from Global transactions, we must perform transaction management that spans across databases. Also, when a workflow process initiates transactions, the call comes from an Enterprise Java Bean, therefore all data sources that interact with this call must be participants of the transaction.

To enable XA, perform the following steps on the SQL Server system:

1. Confirm that the Distributed Transaction Coordinator service is running.
2. Install the stored procedures for the Java Transaction API (JTA).
3. Create a new registry-named value.
4. Enable XA transactions.