The transaction manager has disabled its support for remote network transactions

Question

I m using SQL Server and ASP NET  I have the following function   Using js   daoFactory CreateJoinScope       Using tran   New Transactions TransactionScope                        tran Complete       End Using End Using   However  the exception  The transaction manager has disabled its support for remote network transactions   is thrown   Description of JoinScope   Public Class JoinScope     Implements IJoinScope     Implements IDisposable          End Class   I have worked this way in another application with the same environment without a problem  but here I have this problem  What could I do to fix the issue

User · Answer

Comment from answer   make sure you use the same open connection for all the database calls inside the transaction      Magnus   Our users are stored in a separate db from the data I was working with in the transactions   Opening the db connection to get the user was causing this error for me   Moving the other db connection and user lookup outside of the transaction scope fixed the error

User · Answer

I had the same error message  For me changing pooling False to  pooling true Max Pool Size 200 in the connection string fixed the problem

User · Answer

If you could not find Local DTC in the component services try to run this PowerShell script first    DTCSettings       NetworkDtcAccess                   Network DTC Access  NetworkDtcAccessClients            Allow Remote Clients          Client and Administration   NetworkDtcAccessAdmin              Allow Remote Administration   Client and Administration   NetworkDtcAccessTransactions                       Transaction Manager Communication    NetworkDtcAccessInbound            Allow Inbound   Transaction Manager Communication    NetworkDtcAccessOutbound           Allow Outbound  Transaction Manager Communication    XaTransactions                     Enable XA Transactions  LuTransactions                     Enable SNA LU 6 2 Transactions   foreach  setting in  DTCSettings    Set-ItemProperty -Path HKLM  Software Microsoft MSDTC Security -Name  setting -Value 1    Restart-Service msdtc   And it appears   Source  The partner transaction manager has disabled its support for remote network transactions

User · Answer

In case others have the same issue    I had a similar error happening  turned out I was wrapping several SQL statements in a transactions  where one of them executed on a linked server  Merge statement in an EXEC      AT Server statement   I resolved the issue by opening a separate connection to the linked server  encapsulating that statement in a try   catch then abort the transaction on the original connection in case the catch is tripped

User · Answer

I was having this issue with a linked server in SSMS while trying to create a stored procedure   On the linked server  I changed the server option  Enable Promotion on Distributed Transaction  to False   Screenshot of Server Options

User · Answer

I post the below solution here because after some searching this is where I landed  so other may too   I was trying to use EF 6 to call a stored procedure  but had a similar error because the stored procedure had a linked server being utilized   The operation could not be performed because OLE DB provider   for linked server   was unable to begin a distributed transaction  The partner transaction manager has disabled its support for remote network transactions   Jumping over to SQL Client did fix my issue  which also confirmed for me that it was an EF thing   EF model generated method based attempt   db SomeStoredProcedure      ExecuteSqlCommand based attempt   db Database ExecuteSqlCommand  exec  SomeDB   dbo   SomeStoredProcedure       With   var connectionString   db Database Connection ConnectionString  var connection   new System Data SqlClient SqlConnection connectionString       var cmd   connection CreateCommand    cmd CommandText    exec  SomeDB   dbo   SomeStoredProcedure     connection Open    var result   cmd ExecuteNonQuery      That code can be shortened  but I think that version is slightly more convenient for debugging and stepping through   I don t believe that Sql Client is necessarily a preferred choice  but I felt this was at least worth sharing if anyone else having similar problems gets landed here by google     The above Code is C   but the concept of trying to switch over to Sql Client still applies   At the very least it will be diagnostic to attempt to do so

User · Answer

Make sure that the  Distributed Transaction Coordinator  Service is running on both database and client  Also make sure you check  Network DTC Access    Allow Remote Client    Allow Inbound Outbound  and  Enable TIP    To enable Network DTC Access for MS DTC transactions   Open the Component Services snap-in   To open Component Services  click Start  In the search box  type dcomcnfg  and then press ENTER  Expand the console tree to locate the DTC  for example  Local DTC  for which you want to enable Network MS DTC Access  On the Action menu  click Properties  Click the Security tab and make the following changes  In Security Settings  select the Network DTC Access check box   In Transaction Manager Communication  select the Allow Inbound and Allow Outbound check boxes

User · Answer

I had a store procedure that call another  store Procedure in  linked server  when I execute it in ssms it was ok but when I call it in application By Entity Framework  I got this error  This article helped me and I used this script   EXEC sp serveroption  server    LinkedServer IP or Name   optname    remote proc transaction promotion    optvalue    false      for more detail look at this  Linked server   The partner transaction manager has disabled its support for remote network transactions

User · Answer

In my scenario  the exception was being thrown because I was trying to create a new connection instance within a TransactionScope on an already existing connection   Example   void someFunction         using  var db   new DBContext GetConnectionString                   using  var transaction   new TransactionScope TransactionScopeOption Required  new TransactionOptions   IsolationLevel   System Transactions IsolationLevel ReadUncommitted                           someOtherFunction       This function opens a new connection within this transaction  causing the exception                     void someOtherFunction         using  var db   new DBContext GetConnectionString                   db Whatever     lt - Exception

User · Answer

I was getting this issue intermittently  I had followed the instructions here and very similar ones elsewhere  All was configured correctly   This page  http   sysadminwebsite wordpress com 2012 05 29 9  helped me find the problem   Basically I had duplicate CID s for the MSDTC across both servers  HKEY CLASSES ROOT CID  See  http   msdn microsoft com en-us library aa561924 aspx section Ensure that MSDTC is assigned a unique CID value  I am working with virtual servers and our server team likes to use the same image for every server  It s a simple fix and we didn t need a restart  But the DTC service did need setting to Automatic startup and did need to be started after the re-install

[asp.net] The transaction manager has disabled its support for remote/network transactions

Examples related to asp.net

Examples related to vb.net

Examples related to transactionscope