In particular, after the configuration, note that you must add your database user ('nuxeo' in this example) to proper role in order for him to execute XA statements:
USE master
EXEC sp_grantdbaccess 'nuxeo', 'nuxeo'
EXEC sp_addrolemember [SqlJDBCXAUser], 'nuxeo'
To support XA using the Microsoft JDBC driver, some setup has to be done in the SQL Server itself. It is NECESSARY to follow the Configuration Instructions listed at http://msdn.microsoft.com/en-us/library/aa342335(v=sql.105).aspx
In particular, after the configuration, note that you must add your database user ('nuxeo' in this example) to proper role in order for him to execute XA statements:
USE master
EXEC sp_grantdbaccess 'nuxeo', 'nuxeo'
EXEC sp_addrolemember [SqlJDBCXAUser] , 'nuxeo'
Some screenshots for the first part are visible at http://www.sqlserver-dba.com/2011/12/enable-xa-transactions-for-sql-server.html
Description
There are some changes needed to replace jtds with Microsoft's driver.