Click here to Skip to main content
12,758,918 members (33,771 online)
Rate this:
Please Sign up or sign in to vote.
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 > AND SQL SERVER 2000:

i Have Other Server only for TEST purposes, 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
Regards form Mexico
Posted 22-Aug-12 4:52am
Updated 11-Sep-12 12:37pm
Christian Graus 22-Aug-12 10:05am
Looks like a transaction requires a steady connection between the servers, and the connection between your servers is unreliable, or it just plain won't work across two servers.
Rene Bustos 22-Aug-12 10:16am
Do you Know how can i set to a Reliable Connection?.
thanks in advance
Christian Graus 22-Aug-12 10:19am
I don't think there is an 'unreliable connection' setting. It's just the nature of your network ( assuming that is the issue )
Rene Bustos 22-Aug-12 10:21am
yes.. i mean.. over the servers :D
Rate this: bad
Please Sign up or sign in to vote.

Solution 1

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:[^]

  • 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

Rate this: bad
Please Sign up or sign in to vote.

Solution 2

HI, 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

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

    Print Answers RSS
Top Experts
Last 24hrsThis month

Advertise | Privacy | Mobile
Web02 | 2.8.170217.1 | Last Updated 11 Sep 2012
Copyright © CodeProject, 1999-2017
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100