事务管理器已禁用对远程/网络事务的支持 [英] The transaction manager has disabled its support for remote/network transactions

问题描述

我正在使用 SQL Server 和 ASP.NET.我有以下功能:

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 following exception is thrown:

事务管理器已禁用对远程/网络事务的支持.

The transaction manager has disabled its support for remote/network transactions.

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?

推荐答案

确保分布式事务协调器"服务是在数据库和客户端上运行.还要确保选中网络 DTC 访问"、允许远程客户端"、允许入站/出站"和启用 TIP".

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

为 MS DTC 事务启用网络 DTC 访问

To enable Network DTC Access for MS DTC transactions

1. 打开组件服务管理单元.

1. Open the Component Services snap-in.

要打开组件服务，请单击开始".在搜索框中，键入 dcomcnfg，然后按 Enter.

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

展开控制台树以找到要为其启用网络 MS DTC 访问的 DTC(例如，本地 DTC).

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.

单击安全"选项卡并进行以下更改:在安全设置"中，选中网络 DTC 访问"复选框.

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.

这篇关于事务管理器已禁用对远程/网络事务的支持的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！