Hello, I performed what I thought to be a successful installation of the XA Transactions capability on a SQLServer 2005 database. Here are the steps I performed:
1) Loaded the xa transctions dll (sqljdbc2.0_xa)
into the binn directory of SQLServer.
2) ran the install.sql script from SQLServer Management Suite (can see the
SQLJDBCXAUser role and schema after the install).