惯性聚合 高效追踪和阅读你感兴趣的博客、新闻、科技资讯
阅读原文 在惯性聚合中打开

推荐订阅源

爱范儿
爱范儿
博客园 - 【当耐特】
量子位
Engineering at Meta
Engineering at Meta
博客园_首页
大猫的无限游戏
大猫的无限游戏
IT之家
IT之家
V
Visual Studio Blog
小众软件
小众软件
阮一峰的网络日志
阮一峰的网络日志
美团技术团队
Jina AI
Jina AI
The Cloudflare Blog
T
Tailwind CSS Blog
让小产品的独立变现更简单 - ezindie.com
让小产品的独立变现更简单 - ezindie.com
雷峰网
雷峰网
奇客Solidot–传递最新科技情报
奇客Solidot–传递最新科技情报
宝玉的分享
宝玉的分享
WordPress大学
WordPress大学
有赞技术团队
有赞技术团队
酷 壳 – CoolShell
酷 壳 – CoolShell
Last Week in AI
Last Week in AI
人人都是产品经理
人人都是产品经理
博客园 - 聂微东

博客园 - shcity

Parse string to JSON object Parse date in js blockUI doesn't close when download file in asp.net define namespace in JS Dense_Rank(), Row_Number(), Rank() in sql server reading and writing variable through lock in SSIS script task Fix the issue that cannot open SSIS in BIDS three ways creating custom helpers to show RadioButtonList in MVC using JavaScriptSerializer to serialize object to json using ISerializable to control serialization and deserialization ViewStateAutoManager ReportingService formatting Build my own DataTable split a string into an array through comma div with separated html template - shcity 正则表达式替换日期 半透明的div对话框 foreach 的自动转化类型 在Ajax1.0中调用页面CS文件中的方法
Troubleshooting on TransactionScope
shcity · 2013-08-10 · via 博客园 - shcity

We often met several kinds of errors when using TransactionScope in our applications and some settings are not proper.

Here are some tips on how to resolve these issues.

My scenario is, web application is running on server A, and database used by the web app is running on server B, both servers have firewalls enabled. 

First when try to access the web app, I get below exception: 

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. 

The error message is obvious, so on server A, I come to Administrative Tools ->Component Services ->right-clicking on My Computer- >Properties->MSDTC, setting it as below: 

 

When I try to access web app again, I get a similar exception shown below: 

The partner transaction manager has disabled its support for remote/network transactions. (Exception from HRESULT: 0x8004D025) 

This time, I made the same setting with previous step on server B on which the SQL Server is running. 

Again, I get another error when access the web application, 

Communication with the underlying transaction manager has failed. 

When I searched on internet, I realized that because I have firewalls running on both servers, and the MSDTCs need get through them. So I configured the firewalls so that MSDTCs will not be blocked by the firewalls. My firewalls are coming with the windows operating system, so I added the msdtc.exe to the Exceptions tab of the windows Firewall window. 

When I access the App, I get the same error as described previously. 

It’s really frustrating, after some investigations, I modified the hosts file under C:\WINDOWS\system32\drivers\etc on database server by adding 192.168.1.121 test-server in it, the IP is the web server’s IP and test-server is the name of the web-server. 

This time, everything works fine, problem is resolved.