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 > 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
Posted 22-Aug-12 4:52am
Updated 11-Sep-12 12:37pm
v2
Comments
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
thanks
Rate this: bad
 
good
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: 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

  Permalink  
Rate this: bad
 
good
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
  Permalink  

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