This article provides troubleshooting tips for accessing Microsoft SQL Server data sources.
ERROR CODE: 20001 SQL STATE: HY000 java.sql.SQLException: [Microsoft][SQLServer JDBC Driver] [SQLServer]xa_open (0) returns -3 at com.microsoft.jdbc.base.BaseExceptions.createException(Unknown Source) ... at com.microsoft.jdbcx.sqlserver.SQLServerDataSource.getXAConnection (Unknown Source) ...
This error can occur because the stored procedures for the Java Transaction API (JTA) feature are not installed on the Microsoft® SQL Server.
To resolve the problem, repeat the installation for the stored procedures for the JTA feature, according to the DataDirect Connect for JDBC driver installation guide.
If you are using a Microsoft SQLSERVER database on Windows Server 2003, and you move a cluster of SQL servers from one node to another node, or shut down the cluster, the
setting in Windows Component Services might be reset to disabled. When this happens, a JAVAX.TRANSACTION.XA.XAEXCEPTION with Error: XP_SQLJDBC_XA_INIT might occur because the JDBC driver is no longer enabled for XA transactions.