Distributed transaction with clustering server

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Yuval Peleg (yuval.peleg_at_nice.com)
Date: 11/23/04 

Date: Tue, 23 Nov 2004 08:05:49 -0800

I can't perform a distributed transaction between a remote
server to the central server.

I have 3 sql server 2000 enterprise edition. 2 of them are
installed on win2K server (LOCAL1, LOCAL2) and the other
(CENTRAL_SQL) is installed on clustering win2K server.
None of them is in domain.

Linked servers are defined well between them and I can
perform select statement from any server to any other
server.

I can also perform a distributed transaction between the
remote servers, from LOCAL1 to LOCAL2 and contrarily:
set xact_abort on
begin distributed tran
select count(*) from
LOCAL1.tempdb.INFORMATION_SCHEMA.TABLES
commit
set xact_abort off
MSDTC service starts up with local system account or other
administrators belonging account.

I can also ping the local servers from the central and
even manage them using the Active Directory.

When I perform a distributed transaction between a remote
server (LOCAL1 or LOCAL2) and the central server I get an
error:
Server: Msg 7391, Level 16, State 1, Line 5
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].

What am I doing wrong?

Thanks,
Yuval Peleg
DBA, Nice Systems

Relevant Pages