XA deployment/recovery errors or warnings for an XA datasource pool using Microsoft SQL Server in JBoss EAP

Issue

• Encountering errors/warnings similar to those below during deployment or XA recovery (on the Periodic Recovery thread). Example:

    ... javax.transaction.xa.XAException: com.microsoft.sqlserver.jdbc.SQLServerException: Failed to create the XA control connection. Error: "Could not find stored procedure 'master..xp_sqljdbc_xa_init_ex'.", XAException.XAER_RMERR

• Or this warn:

    ... WARN  [com.arjuna.ats.jta] (Periodic Recovery) ARJUNA016027: Local  XARecoveryModule.xaRecovery got XA exception   XAException.XAER_RMERR: javax.transaction.xa.XAException: com.microsoft.sqlserver.jdbc.SQLServerException: Could not find stored procedure   'master..xp_sqljdbc_xa_recover'.
    at  com.microsoft.sqlserver.jdbc.SQLServerXAResource.DTC_XA_Interface(SQLServerXAResource.java:647)

• When adding a Microsoft MSSQL Server database, the following error is appearing in the log:

    com.microsoft.sqlserver.jdbc.SQLServerException: Could not find stored procedure 'master..xp_sqljdbc_xa_start'