distributed transaction clusters -
05-28-2004
, 12:23 PM
Hi,
I have a two clusters win2k advanced server(sp3) with
sql2k(sp3) in different networks, different domains. When
I try to run a distibuted transaction from serverA to
ServerB, I receive a folowing error message:
Server: Msg 7391, Level 16, State 1, Procedure Line 39
The operation could not be performed because the OLE DB
provider 'SQLOLEDB' was unable to begin a distributed
transaction.
[OLE/DB provider returned message: New transaction cannot
enlist in the specified transaction coordinator. ]
OLE DB error trace [OLE/DB Provider 'SQLOLEDB'
ITransactionJoin::JoinTransaction returned 0x8004d00a].
I tested the distribued transaction from other sql server
(no-clustered) (ServerC) in the same domain that serverA
to ServerB and to ServerA, and it works well
This is the sample code that implement the distributed
transaction, running from sql query analyzer:
set xact_abort on
begin tran
update ServerB.pubs.dbo.discounts set discount = 1
commit tran
alexgyf1 |