Error with transactions between servers

Question

0.00/5 (No votes)

See more:

SQL-server-2000

, +

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 3:52am

Rene Bustos

Updated 11-Sep-12 11:37am

Kenneth Haugland

v2

Add a Solution

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

2 solutions

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

Posted 22-Aug-12 11:17am

Wendelius

Add a Solution

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

Rene Bustos · Accepted Answer · 2012-09-11T11:30:00

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

Posted 11-Sep-12 11:30am

Rene Bustos

Error with transactions between servers

2 solutions

Solution 1

Solution 2

Add your solution here

Preview 0

Error with transactions between servers

2 solutions

Solution 1

Solution 2

Add your solution here

Preview 0

Existing Members

...or Join us