DTC Error Between Local Development Machine and SQL Server

0

I am working with a piece of code that was developed at a time when our development environment was setup differently. It appears the code hasn't been actively developed since then and is no longer working in development.

Specifically, it is using two different DBContexts (to different databases on the same server) within a TransactionScope and triggering DTC to take over the transaction and then failing as soon as the second context attempts to make a query with the following error:

The MSDTC transaction manager was unable to pull the transaction from the source 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. (Exception from HRESULT: 0x8004D02B)

This is between my local machine (Win10) and a machine on a different network and domain running SQL Server (Server 2012). The deployed application within the same network as the sql server works fine.

Things I have tried from google searches and other stack overflow:

  • The machines can ping through just their name (specifically added entries to the HOSTS files)
  • DTC is enabled on both machines and allow network transactions
  • CID values are different
  • DTCPing - this working correctly between the machines
  • DTCTester - this is failing with the following error: SQLSTATE=24000,Native error=0,msg=[Microsoft][ODBC SQL Server Driver]Invalid cursor state
  • Windows Firewall is disable
  • Exception for DTC in Firewall
  • There is no network firewall between the two machines
  • Added Registry keys for EnableAuthEpResolution and RestrictRemoteClients.
  • Nothing in the event log
  • DTC trace file just says the transaction was aborted

I'm rather at a loss for the next steps of resolving this issue.

sql-server
entity-framework
transactions
msdtc
asked on Stack Overflow Jan 24, 2018 by DJL

0 Answers

Nobody has answered this question yet.


User contributions licensed under CC BY-SA 3.0