To enable XA in Microsoft SQL Server 2005, you have to:
1. download Microsoft SQL Server 2005 JDBC Driver 1.2
2. copy the 'sqljdbc_xa.dll' to SQL Server's 'binn' folder
3. execute 'xa_install.sql' SQL script as user 'sa'
(visit Understanding XA Transactions for details)
