# javax.transaction.xa.XAException during Bonita 7.9.2 Tomcat + SQL server 2014 installation
**URL:** https://community.ofelia.com/t/javax-transaction-xa-xaexception-during-bonita-7-9-2-tomcat-sql-server-2014-installation/9888
**Category:** Q&A
**Created:** [26 November 2019 16:40 UTC](https://community.ofelia.com/t/javax-transaction-xa-xaexception-during-bonita-7-9-2-tomcat-sql-server-2014-installation/9888 "2019-11-26T16:40:04Z")
**Posts on this page:** 2
**Page:** 1
### Author:  [@mcastril\_1399231](https://community.ofelia.com/u/mcastril_1399231)
#### Post date: [26 November 2019 16:40 UTC](https://community.ofelia.com/t/javax-transaction-xa-xaexception-during-bonita-7-9-2-tomcat-sql-server-2014-installation/9888/1 "2019-11-26T16:40:04Z")
Hi,
I’m trying to install Bonita 7.9.2 Tomcat bundle pointing to a Sql server 2017 instance. start-bonita.bat ran without errors, but when i try to open Bonita portal, i’m getting this exception:
com.arjuna.ats.jta ARJUNA016061: TransactionImple.enlistResource - XAResource.start returned: XAException.XAER\_RMERR for \< formatId=131077, gtrid\_length=29, bqual\_length=36, tx\_uid=0:ffff0a0a2202:d8fc:5ddd416e:c, node\_name=1, branch\_uid=0:ffff0a0a2202:d8fc:5ddd416e:4d, subordinatenodename=null, eis\_name=0 \>
javax.transaction.xa.XAException: com.microsoft.sqlserver.jdbc.SQLServerException: Failed to create the XA control connection. Error: “The connection is closed.”
at com.microsoft.sqlserver.jdbc.SQLServerXAResource.DTC\_XA\_Interface(SQLServerXAResource.java:738)
at com.microsoft.sqlserver.jdbc.SQLServerXAResource.start(SQLServerXAResource.java:772)
at com.arjuna.ats.internal.jta.transaction.arjunacore.TransactionImple.enlistResource(TransactionImple.java:662).
I’m aware that i skipped “XA Transactions” part as decribed in [https://documentation.bonitasoft.com/bonita/7.9/database-configuration](https://documentation.bonitasoft.com/bonita/7.9/database-configuration).
My question is: is there any workaround to not make “XA transactions” configuration in my server or is this mandatory in order to Bonita runs.
Thanks in advance.
---
### Author:  [@system](https://community.ofelia.com/u/system)
#### Post date: [27 November 2019 08:33 UTC](https://community.ofelia.com/t/javax-transaction-xa-xaexception-during-bonita-7-9-2-tomcat-sql-server-2014-installation/9888/2 "2019-11-27T08:33:35Z")
XA transaction is mandatory for Bonita Engine to run properly and there is no workaround to avoid this requirement. XA transactions are used by Bonita Engine to make sure that data are coherent and to be able to restart from a clean state in case of an unplanned server shutdown.
Maybe you can add in a comment why you choose not to configure SQL Server to support XA transactions?