服务器之间的交易出错 [英] Error with transactions between servers

问题描述

伙计们.
我对服务器之间的事务有疑问
问题是这样的:

当我通过WebService发送交易时. (已启用Web服务以进行事务处理)，在客户端抛出错误....但是当我去检查Log Server的服务器端时，我发现了这种类型的错误:

与事务管理器的连接已丢失.(来自HRESULT的异常:0x8004D01C)"

我的 IIS 和 SQL SERVER 2000 ，每个都位于不同的服务器中: IIS> 192.168.1.8 和SQL SERVER 2000:192.168.1.7

我仅具有用于测试目的的其他服务器192.168.1.102，但是在此服务器中，我同时拥有这两个服务器(IIS和SQL)，并且在此服务器中，该应用程序运行正常.

如果您需要更多信息，请告诉我:D
谢谢
盖伊
关于墨西哥的问候

hi Guys.
i have a problem with Trasactions Between servers
the problem is this:

When i send a transaction over a WebService. (the Web Service has been enabled to procces transactions) at the client Side, throwme an error.... but when i go to check at the Server Side in the Log Server i found this Type of Error:

"A connection with the transaction manager was lost. (Exception from HRESULT: 0x8004D01C)"

My IIS And SQL SERVER 2000 , each one is in different Servers: IIS > 192.168.1.8 AND SQL SERVER 2000: 192.168.1.7

i Have Other Server only for TEST purposes 192.168.1.102, but in this Server i have both of them (IIS AND SQL together) and in this Server the App Works perfectly.

If You need more information , just tell me :D
Thanks
Guy
Regards form Mexico

推荐答案

正如Christian Graus所说，最可能的原因是您的连接不稳定.基本上原因可能在任何地方，但您可以检查以下几件事

• 检查孤立的连接: http://support.microsoft.com/kb/137983? sd = RMVP& fr = 1 [ ^ ]
• 使用某些网络分析工具，检查可能的连接丢失或其他网络问题.您还可以从Windows性能监视器监视基本信息
• ，确保SQL Server的优先级正常，这意味着您尚未将boost SQL Server优先级-option设置为on

As Christian Graus said, the likeliest reason is that your connection is unstable. Basically the reason could be anywhere, but here''s few things you could check

• check for orphaned connections: http://support.microsoft.com/kb/137983?sd=RMVP&fr=1[^]
• using some network analysis tools, check possible connection losses or other network problems. You can also monitor basic information from the Windows Performance Monitor
• ensure that the priority of the SQL Server is normal, meaning that you haven''t set the boost SQL Server priority -option on

问题出在DTC上
如果您有类似的问题，请执行此操作

前往服务....
然后搜索:DTC服务并将其打开.
重新启动服务器:D
就是这样.
问候:D
来自墨西哥

the problem Was a DTC
if you have a simillar problem do this

Go to services....
then search for: DTC service and Turn it On.
restart your server :D
and that´s all..
Regards :D
FROM Mexico

这篇关于服务器之间的交易出错的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！