Error in updating SQL Server database from message handler using EF

1

Hi,
I am trying to save message into SQL server database using EF 6 from my message handler (subscriber). I am using MSMQ transport and SQL Server persistence. It is working if NSB components and database are in my local computer. But when using another database server to update data I am getting error

“The partner transaction manager has disabled its support for remote/network transactions. (Exception from HRESULT: 0x8004D025)”

I have setup the DTC on the remote DB server and then getting the error

Communication with the underlying transaction manager has failed.

I can update the database using using

(TransactionScope sc = new TransactionScope(TransactionScopeOption.Suppress))

How can I fix the DTC issue above? Is there any issue if I use that Transaction scope above to bypass the DTC?

Regards,
Maz

2

Hi Maz,

There seems to be a DTC communication issues across the network.

To identify the issue you can run DTCPing (

) on both machines.

.m