MSDTC connection problem

Hello, I have a very annoying problem:
The Lan network comprises:
A) SQL Server 2005 Express Edition (WindowsXP Sp2)
B) SQL Server 2005 Standard Edition (Windows 2003 Server Sp2)
When I try to run distributed transaction from *A* to *B*, I receive
the error message:
"Transakcja zostaa ju jawnie lub niejawnie przekazana
lub przerwana"
(my translation is: Transaction has been explicitly or
implicitly interrupted or transfered)
When I try to run distributed transaction from *B* to *A*, I receive
the error message:
"No transaction is active."
The transaction is simple, similar to:
begin distributed tran
SELECT * FROM SerwerA.testowa.dbo.tabela;
commit
MSDTC is running on both computers, properly configured (network-aware),
there are no firewalls running, server names are resolvable (they're
placed in the hosts files). What could be the reason for such a
behaviour? I'd be grateful for any kind of help because I'm fighting
with this problem for a few days...
Regards,
Piotr
Piotr Porzucek wrote:
> Hello, I have a very annoying problem:
> The Lan network comprises:
> A) SQL Server 2005 Express Edition (WindowsXP Sp2)
> B) SQL Server 2005 Standard Edition (Windows 2003 Server Sp2)
> When I try to run distributed transaction from *A* to *B*, I receive
> the error message:
> "Transakcja zostaa ju jawnie lub niejawnie przekazana
> lub przerwana"
> (my translation is: Transaction has been explicitly or
> implicitly interrupted or transfered)
> When I try to run distributed transaction from *B* to *A*, I receive
> the error message:
> "No transaction is active."
> The transaction is simple, similar to:
> begin distributed tran
> SELECT * FROM SerwerA.testowa.dbo.tabela;
> commit
> MSDTC is running on both computers, properly configured (network-aware),
> there are no firewalls running, server names are resolvable (they're
> placed in the hosts files). What could be the reason for such a
> behaviour? I'd be grateful for any kind of help because I'm fighting
> with this problem for a few days...
> Regards,
> Piotr
Hi,
Try to take a look at this link - maybe that can lead you on right track.
http://support.microsoft.com/kb/817064/
Regards
Steen Schlter Persson
Database Administrator / System Administrator