Posted by Erland Sommarskog on 04/06/07 20:27

(c-eric.geil@mci.com) writes:
> After a little more testing, here's some more info on this:
>
> Server A (non-working Win2K server) pulls from Server B (remote sql
> 2000 server)
> Server C (working Win2003 server) pulls from Server D (remote sql 2000
> server)
>
> When I switch server C to pull from server B, I get the 7391 error.
> Both B and D are sql 2000. I am unsure of the OS on B and D at this
> point. I do know that the databases are identical, as they are set up
> as part of a vendor software we use, and are the exact same version of
> the software.

Enter Component Services (under Adminstratve Tools in the Control Panel),
and under the Component Services node, right-click My Computer and select
Properties. Go to the MS DTC tab. I don't really know what you should
look for, but compare the working server with the non-working.



--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

[Back to original message]