NServiceBus, SQL Server, and DTC
This exception drove me nuts:
System.Transactions.TransactionException: The partner transaction manager has disabled its support for remote/network transactions. (Exception from HRESULT: 0x8004D025) ---> System.Runtime.InteropServices.COMException: The partner transaction manager has disabled its support for remote/network transactions. (Exception from HRESULT: 0x8004D025)
This blog post solved it and made my day. Thank you.
DTC was disabled on SQL Server machine, which caused messages sent via NServiceBus to fail when NSB service was trying to process them in transactional manner agains SQL Server. As blog post above says, Microsoft post explains how to address the issue.