MSDTC Doesn't Work问题分析
来源:互联网 发布:淘宝复制别人的标题 编辑:程序博客网 时间:2024/05/18 02:24
SP中调用分布式事务时发生异常,异常信息如下:
OLE DB provider "SQLNCLI" for linked server " " returned message "No transaction is active.".
The operation could not be performed because OLE DB provider "SQLNCLI" for linked server " " was unable to begin a distributed transaction.
初步问题排查:
SQL SERVER 1433端口开放,MSDTC端口135开放
采用MS Dtcping工具双向测试结果:
无法连接到另外一台服务器上的MSDTC.错误信息:1753(There are no more endpoints available from the endpoint mapper.)
RPC test failed一般来说除了固定的135端口外,MSDTC还需要开启的端口为5000-5020,具体可以到SERVER注册表下HKEY_LOCAL_MACHINE/SOFTWARE/Microsoft/Rpc/Internet/下查找开放的端口范围,默认一般为:5000-5020之间,见截图。
防火墙上端口开启问题解决。
SERVER端MSDTC设置如下图所示:
0 0
- MSDTC Doesn't Work问题分析
- 【问题收录】[ubuntu]startx doesn't work
- MSTest doesn’t work
- set_terminate doesn't work
- vi doesn't work
- Why dynamic_cast doesn't work ?
- File@CompanionFile doesn't work
- Ant task doesn't work in Eclipse
- RequestContext.getRequestChannelId() seems doesn't work
- BitmapImage.UriSource binding doesn't work ...
- ubuntu 11.10 brightness doesn't work
- adb logcat filter doesn't work
- My Backspace Key doesn't work!
- My Backspace Key doesn't work!
- Liferay color-scheme doesn't work
- Wince USB keyboard doesn't work
- ROOT: Why TStyle::SetStatFontSize() doesn't work?
- 貌似csdn文章搜索doesn't work
- HashMap的实现原理
- node.js 使用 imagemagick
- OCP-1Z0-053-V13.02-264题
- ExtJs的Ext.grid.GridPanel不能选择复制表格中的内容解决方案
- 微博背后的那些算法
- MSDTC Doesn't Work问题分析
- 两个月的焦点
- C++ 成长之路
- Let the Balloon Rise
- Recover Binary Search Tree
- 如何集中注意力
- OCP-1Z0-053-200题-30题-264
- Deep learning:四十(龙星计划2013深度学习课程小总结)
- jQuery Mobile 1.2更新一览 更好的表单调整机制