This topic provides troubleshooting tips for accessing Microsoft SQL Server data sources.
If you are using version 2.0 of the Microsoft SQL Server JDBC Driver (other versions do not have the issue), you might experience a hang after a connection error occurs. The following test fix from Microsoft fixes this issue: http://support.microsoft.com/kb/977924
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 JDBC driver installation guide.