I had the same problem, but with a little diference: all my servers are in
a local network and none of them is conected by modem.
I dont know what was the correct origin of the problem, but I thought the
problem was a result of the installation sequence of "Windows NT Service
Pack 4" and "SQL Server 6.5 Service Pack 1". In the "problem server" I had
installed "Windows NT Service Pack 4" after "SQL Server 6.5 Service Pack 1"
and in all others servers I had installed the "SQL Server 6.5 Service Pack
1" before "Windows NT Service Pack 4".
To try to resolve the problem I had uninstalled the SQL Server 6.5, after
this I had installed the "Windows NT Service Pack 4" again and finaly I had
installed the "SQL Server Service Pack 1".
After this procedure, in the first try to run the Distributed Transaction
the error msg appeared again. I had reseted the DTC Log and the Distributed
Transaction had worked very well.
Besides the related problem I have seen that DTC never runs on first try
after the SQL Server installation, and always I have to reset the DTC Log.
Another problem is the follow:
When I turn off the server (PC, not the SQL) after I turn on it, the DTC
returns the same msg. To resolve this problem I have created the following
Stored Procedure in the Master Database:
CREATE PROCEDURE st_RestartaDTC AS
exec xp_cmdshell "net stop MSDTC"
exec xp_cmdshell "net start MSDTC"
and I execute the command "sp_makestartup st_RestartaDTC" that sets a
stored procedure for auto execution.
Im sorry for my english, but i dont speak english very well.
> Hello there.
> I used MS DTC with two servers(Server1, Server2)
> on different but fully trusted domains(Domain1, Domain2)
> with 56K leased line connection.
> On server1, I tried
> begin distributed transaction
> exec Server2.mydb.mysp
> commit transaction
> and got following message
> Msg 8524, Level 16, State 1
> The current transaction couldn't be exported to remote site.
> It has been rolled back.
> I tried only remote stored procedure
> with no begin distributed transaction ... commit transaction pair
> and it worked.
> I also tried with other two servers on same domain with LAN connection
> and it worked.
> I'm using MS SQL Server 6.5 and NT 3.51.
> Please, help me solve this problem.
> Thanks in advance.
> Young-Han Kim
> System Engineer
> Research & Development Division
> Tong Yang SHL Corporation
> Seoul, Korea
> Tel: +82-2-405-7868
> Fax: +82-2-402-6183
> *...imagine how little used calculus would have been
> if a court had decided that no one could study, use,
> or do research on it without paying a royalty to
> Newton's designated heirs.*
> - The Independent, October 5,