Click here to Skip to main content
11,649,522 members (77,499 online)
Rate this: bad
good
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 Big Grin | :-D
Thanks
Guy
Regards form Mexico
Posted 22-Aug-12 3:52am
Edited 11-Sep-12 11:37am
v2
Comments
Christian Graus at 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 at 22-Aug-12 10:16am
   
Do you Know how can i set to a Reliable Connection?.
thanks in advance
Christian Graus at 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 at 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 Big Grin | :-D
and that´s all..
Regards Big Grin | :-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
0 OriginalGriff 354
1 F-ES Sitecore 344
2 Kornfeld Eliyahu Peter 319
3 CPallini 290
4 Maciej Los 269
0 OriginalGriff 1,577
1 Sergey Alexandrovich Kryukov 1,087
2 CPallini 1,015
3 DamithSL 996
4 jyo.net 994


Advertise | Privacy | Mobile
Web04 | 2.8.150804.4 | Last Updated 11 Sep 2012
Copyright © CodeProject, 1999-2015
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