Error in updating SQL Server database from message handler using EF


(Mazharul Islam) #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


(Mauro Servienti) #2

Hi Maz,

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

To identify the issue you can run DTCPing (
https://support.microsoft.com/en-us/help/918331/how-to-troubleshoot-connectivity-issues-in-ms-dtc-by-using-the-dtcping
) on both machines.

.m