Configuring SQL Server 2008 for XA transactions

You need to run MS DTC service and configure the JDBC distributed transaction components for the SQL server.

Before you begin

The JDBC driver was downloaded and extracted from this website: http://msdn.microsoft.com/en-us/data/aa937724.aspx.

Procedure

Assuming that you installed the MS SQL Server 2008 JDBC driver 3.0 at JDBC_DRIVER_INSTALL_DIR, open the JDBC_DRIVER_INSTALL_DIR\help\html\574e326f-0520-4003-bdf1-62d92c3db457.htm file. Follow the instructions in Understanding XA Transactions for these sections.
  1. Running the MS DTC Service
  2. Configuring the JDBC Distributed Transaction Components
Note: You do not have to complete the section titled Configuring the User-Defined Roles. Identity Manager creates the necessary ID and associate with the SqlJDBCXAUser role for you.