The MSDTC transaction manager was unable to push the transaction using AmbientTransaction
<p>I have a BizTalk solution that would call a stored procedure that will query and update table. Apparently I'm encountering this error each time I test my solution in a load balanced servers.</p>

<blockquote>
  <p>The adapter failed to transmit message going to send port SQLAdapter_Sendport" with URL "mssql://server//StoredProc?". It will be retransmitted after the retry interval specified for this Send Port.   </p>
  
  <p><strong>Details</strong>: System.Transactions.TransactionManagerCommunicationException: Communication with the underlying transaction manager has failed.</p>
  
  <p>System.Runtime.InteropServices.COMException: The MSDTC transaction manager was unable to push the transaction to the destination transaction manager due to communication problems. Possible causes are: a firewall is present and it doesn't have an exception for the MSDTC process, the two machines cannot find each other by their NetBIOS names, or the support for network transactions is not enabled for one of the two transaction managers.</p>
  
  <p>Exception from HRESULT: 0x8004D02A)<br>
  at System.Transactions.Oletx.ITransactionShim.Export(UInt32 whereaboutsSize, Byte[] whereabouts, Int32&amp; cookieIndex, UInt32&amp; cookieSize, CoTaskMemHandle&amp; cookieBuffer)<br>
  at System.Transactions.TransactionInterop.GetExportCookie(Transaction transaction, Byte[] whereabouts)<br>
  --- End of inner exception stack trace ---</p>
</blockquote>

<p>I've read some articles that I should set the DTC properties as below. These I've already set in both BizTalk and SQL Servers.</p>

<p><a href="https://i.stack.imgur.com/JwuX2.jpg" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/JwuX2.jpg" alt="enter image description here"></a></p>

<p>Also the DTC must be added in the Windows Firewall.</p>

<p><a href="https://i.stack.imgur.com/e9rAx.jpg" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/e9rAx.jpg" alt="enter image description here"></a></p>

<p>And lastly if the useAmbientTransaction in the Send Port properties is set to True I keep encountering the said error above.</p>

<p><a href="https://i.stack.imgur.com/VR7qs.jpg" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/VR7qs.jpg" alt="enter image description here"></a></p>

<p>But if I set the useAmbientTransaction to False the message is succeeding in SQL.</p>

<p>I've read in some article that Microsoft doesn't recommend setting the useAmbientTransaction to False especially if there's Update and Delete involve in the stored procedure. But my solution uses delete and update in the stored procedure that's why I need to set it the useAmbientTransaction to True. But if I do that I keep encountering the error "MSDTC transaction manager was unable to push the transaction to the destination..."</p>

<p>Please suggest any possible solution for this.</p>