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?