I'm finally installing in Production the IS 8.7 on a Win2008R2 box with metadata in Sql Server 2008. So far I didn't have any issues in lower environments with pretty much similar configuration.
Now, during the installation (silent or interactive) I get a "The SQL Server on xxxx was not configured for XA support.". We obviously followed the instructions for the configuration of DTC, JTA, XA etc as per lower environments.
Doing some cross check tests it seems that it is really the DB the one to look at.
The only difference in Production compared to DEV is that there is an underlining Windows cluster with two nodes; while in DEV there is only a DB Cluster. Btw, we configured DTC as well on the Nodes.
Error from the log is
Code: Select all
18-Feb-2013 15:47:36, SEVERE: com.ibm.is.install.check.SQLServerXASupportChecker
java.sql.SQLException: [IBM][SQLServer JDBC Driver][SQLServer]xa_open (0) returns -3
Any help appreciated.
thx Roberto