dbTalk Databases Forums  

distributed transaction clusters

microsoft.public.sqlserver.clustering microsoft.public.sqlserver.clustering


Discuss distributed transaction clusters in the microsoft.public.sqlserver.clustering forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
alexgyf1
 
Posts: n/a

Default 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


Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.