unable to begin a distributed transaction
Posted on 2008-11-11
sql v2000 sp4, servers are linked, haven't had this problem before now --
simply trying to select from one server to the other (which is linked) --
select top 1 * from otherserver.database.dbo.view
fails with this:
Server: Msg 7391, Level 16, State 1, Line 1
The operation could not be performed because the OLE DB provider 'SQLOLEDB' was unable to begin a distributed transaction.
OLE DB error trace [OLE/DB Provider 'SQLOLEDB' ITransactionJoin::JoinTransaction returned 0x8004d00a].
[OLE/DB provider returned message: New transaction cannot enlist in the specified transaction coordinator. ]
very urgent, please advise