問題描述

我正在嘗試使用 TransactionScope，但不斷收到以下異常.
如果重要的話，該應用程序運行在與數據庫不同的機器上.我使用的是 SQL Server 2005.

分布式事務管理器 (MSDTC) 的網絡訪問已被禁用.請在安全配置中為網絡訪問啟用 DTCMSDTC 使用組件服務管理工具.

using (TransactionScope tsTransScope = new TransactionScope()){//在這里做事tsTransScope.Complete();}

編輯

我根據反饋做了一些更改.現在我收到此錯誤:

調用 COM 組件時返回了錯誤 HRESULT E_FAIL."
與底層事務管理器的通信失敗."

解決方案我認為接受的答案解決了我遇到的最初問題.第二個錯誤似乎特定于實體框架.我會為此發布另一個問題.

以下是客戶端的屬性:
有這個有趣的建議:

另一個配置設置需要注意(雖然我認為這是一個不常見的情況)是RestrictRemoteClients 注冊表項.如果此鍵的值設置為 2(RPC_RESTRICT_REMOTE_CLIENT_HIGH) 然后MSDTC 網絡交易不會被能夠正常工作.MSDTC 支持只有 RPC_RESTRICT_REMOTE_CLIENT_NONE(0) 和RPC_RESTRICT_REMOTE_CLIENT_DEFAULT (1)值.看http://www.microsoft.com/technet/prodtechnol/winxppro/maintain/sp2netwk.mspx#XSLTsection128121120120有關更多信息限制遠程客戶端.

最后，雖然不是特定于您的問題，但使用 TransactionScope 類時需要注意的一個非常重要的事情是它的默認設置是使用 可序列化的事務隔離級別.Serializable 是限制性最強的隔離級別，坦率地說，它被選為默認級別令人驚訝.如果您不需要這種級別的鎖定，我強烈建議在實例化 TransactionScope 時將隔離級別設置為限制較少的選項 (ReadCommitted):

var scopeOptions = new TransactionOptions();scopeOptions.IsolationLevel = System.Transactions.IsolationLevel.ReadCommitted;scopeOptions.Timeout = TimeSpan.MaxValue;使用 (var scope = new TransactionScope(TransactionScopeOption.Required,范圍選項)){//你的代碼在這里}

I am trying to use TransactionScope, but keep getting the exception below.
The app is running on a different machine than the database, if that matters. I am using SQL Server 2005.

Network access for Distributed Transaction Manager (MSDTC) has been disabled. Please enable DTC for network access in the security configuration for MSDTC using the Component Services Administrative tool.

using (TransactionScope tsTransScope = new TransactionScope())
{
    //Do stuff here
    tsTransScope.Complete();
}

Edit

I made some changes based on the feedback. Now I'm getting this error:

"Error HRESULT E_FAIL has been returned from a call to a COM component."
"Communication with the underlying transaction manager has failed."

Solution I think the accepted answer fixed the initial issue I was getting. The 2nd error seems to be specific to Entity Framework. I'll post another question for it.

Here are the properties on the client:
Client http://www.portnine.com/data/images/Misc/client.jpg

Here are the properties on the server:
Server http://www.portnine.com/data/images/Misc/server.jpg

You need to enable network DTC access as described in this Microsoft TechNet Article. This change may have to be made on both the database and application servers. Often times DTC is already turned on a database server so I'd look at the application server first.

Here is a screen shot of what we use except for the "Allow Remote Administration" option:

I have not run into the HRESULT E_Fail issue you are now having but this article on XP SP2 and transactions had this interesting suggestion:

Another configuration setting that you need to be aware (although I consider it to be an uncommon scenario) is RestrictRemoteClients registry key. If the value of this key is set to 2 (RPC_RESTRICT_REMOTE_CLIENT_HIGH) then MSDTC network transactions will not be able to work properly. MSDTC supports only RPC_RESTRICT_REMOTE_CLIENT_NONE (0) and RPC_RESTRICT_REMOTE_CLIENT_DEFAULT (1) values. See http://www.microsoft.com/technet/prodtechnol/winxppro/maintain/sp2netwk.mspx#XSLTsection128121120120 for more info on RestrictRemoteClients.

Finally, while not specific to your issue a very important thing to note about using the TransactionScope class is that its default setting is to utilize a Transaction Isolation Level of Serializable. Serializable is the most restrictive of the isolation levels and frankly its surprising that it was chosen as the default. If you do not need this level of locking I would highly recommend setting the isolation level to a less restrictive option (ReadCommitted) when instantiating a TransactionScope:

var scopeOptions = new TransactionOptions();
scopeOptions.IsolationLevel = System.Transactions.IsolationLevel.ReadCommitted;
scopeOptions.Timeout = TimeSpan.MaxValue;

using (var scope = new TransactionScope(TransactionScopeOption.Required,
    scopeOptions))
{
    // your code here
}

這篇關于如何在 C# 中使用 TransactionScope?的文章就介紹到這了，希望我們推薦的答案對大家有所幫助，也希望大家多多支持html5模板網！