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

Enable XA Transactions

To enable XA transactions

1. Go to Start, Control Panel, Administrative Tools, Component Services.
2. Under Computers, navigate to the system where you want to enable XA transaction support.
3. Right click the system name, click Properties.
4. Under the MSDTC tab, click Security Configuration.
5. Select the check box for Enable XA Transactions.
6. Click Ok.
7. (Optional) If you have a database cluster, repeat Step 2 for every SQL server in the cluster.