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?

Answer 1

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

1. Open the Component Services snap-in.

   To open Component Services, click Start. In the search box, type dcomcnfg, and then press ENTER.

2. Expand the console tree to locate the DTC (for example, Local DTC) for which you want to enable Network MS DTC Access.

3. On the Action menu, click Properties.

4. 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.