Configuring Hibernate to use SQL Server 2008

[Rida Abrahams]

Hi,

I am in the process of migrating databases from SQL Server 2005 to SQL Server 2008.
I am currently using Hibernate 3.2 connecting to SQL Server 2005 using a JDBC 3 driver for SQL Server.
Whilst attempting to connect to SQL Server 2008 though, I get the following error:

Caused by: javax.transaction.SystemException: XAResource start association error:XAER_RMERR
	at com.ibm.ws.Transaction.JTA.RegisteredResources.startRes(RegisteredResources.java:1154)
	at com.ibm.ws.Transaction.JTA.RegisteredResources.enlistResource(RegisteredResources.java:525)
	at com.ibm.ws.Transaction.JTA.TransactionImpl.enlistResource(TransactionImpl.java:3219)
	at com.ibm.ws.Transaction.JTA.TranManagerSet.enlist(TranManagerSet.java:396)
	at com.ibm.ejs.j2c.XATransactionWrapper.enlist(XATransactionWrapper.java:693)
	... 83 more
Caused by: javax.transaction.xa.XAException: Failed to initialize the stored procedure xp_sqljdbc_xa_init. The status is: -3. Error: "*** SQLJDBC_XA DTC_ERROR Context: FInitializeTransactionManager, state=1, StatusCode:-3 (0xFFFFFFFD) ***"
	at com.microsoft.sqlserver.jdbc.SQLServerXAResource.DTC_XA_Interface(SQLServerXAResource.java:417)
	at com.microsoft.sqlserver.jdbc.SQLServerXAResource.start(SQLServerXAResource.java:674)
	at com.ibm.ws.rsadapter.spi.WSRdbXaResourceImpl.start(WSRdbXaResourceImpl.java:1324)
	at com.ibm.ejs.j2c.XATransactionWrapper.start(XATransactionWrapper.java:1467)
	at com.ibm.ws.Transaction.JTA.JTAResourceBase.start(JTAResourceBase.java:141)
	at com.ibm.ws.Transaction.JTA.RegisteredResources.startRes(RegisteredResources.java:1103)

I am unsure as to whether I have the correct version of Hibernate to connect to SQL Server 2008.
Does anyone have an idea as to which version of Hibernate is needed to connect to SQL Server 2008?

Thanks.