DTCProxy is not running: java.net.ConnectException

Hi All,

I am new to SQL Server. We are facing the below issue on server(JBoss) startup. The DB is sql-server-2008 R2.

2015-06-09 23:48:18,443 WARN [com.arjuna.ats.jta.logging.loggerI18N] (main) [com.arjuna.ats.internal.jta.transaction.arjunacore.enliststarterror] [com.arjuna.ats.inter

nal.jta.transaction.arjunacore.enliststarterror] TransactionImple.enlistResource - XAResource.start returned: [com.arjuna.ats.jta.utils.unknownerrorcode] Unknown error

code:0 for < 131075, 27, 25, 49455510248484848484958575010010258535355551009910110058545755102484848484849585750100102585353555510099101100585498 >

2015-06-09 23:48:18,444 ERROR [STDERR] (main) javax.transaction.xa.XAException: DTCProxy is not running: java.net.ConnectException: Connection timed out

2015-06-09 23:48:18,445 ERROR [STDERR] (main) at com.inet.tds.b.a(Unknown Source)

2015-06-09 23:48:18,445 ERROR [STDERR] (main) at com.inet.tds.b.start(Unknown Source)

2015-06-09 23:48:18,445 ERROR [STDERR] (main) at com.inet.tds.e.start(Unknown Source)

2015-06-09 23:48:18,445 ERROR [STDERR] (main) at org.jboss.resource.adapter.jdbc.xa.XAManagedConnection.start(XAManagedConnection.java:213)

Please help.

None of those error messages are from SQL Server. However the "DTCProxy is not running:" message makes we wonder if you've started the Distributed Transaction Coordinator or not.

Thanks for your reply. How can I do it ? I am new to SQL Server, and do not have much idea about it. This error is coming on a Unix Box.

You need to see if the DTC is running on the SQL Server box. Ask the DBA.

Hi @gbritton, we are facing issue with DTC Proxy in Clustered DB environment. Is there any special configuration for DTC in clustered environment. Facing issue:- "DTCProxy is not running:"

I'm not aware of clustering issues. Regardless, can you confirm that the DTC is running on the Windows servers involved?