You are here: Re: unable to begin a distributed transaction (Msg 7391) « MsSQL Server « IT news, forums, messages
Re: unable to begin a distributed transaction (Msg 7391)

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

 

Navigation:

[Reply to this message]


Удаленная работа для программистов  •  Как заработать на Google AdSense  •  England, UK  •  статьи на английском  •  PHP MySQL CMS Apache Oscommerce  •  Online Business Knowledge Base  •  DVD MP3 AVI MP4 players codecs conversion help
Home  •  Search  •  Site Map  •  Set as Homepage  •  Add to Favourites

Copyright © 2005-2006 Powered by Custom PHP Programming

Сайт изготовлен в Студии Валентина Петручека
изготовление и поддержка веб-сайтов, разработка программного обеспечения, поисковая оптимизация