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

Look for the following entry in the SQL Server errorlog:

Attempting to initialize Distributed Transaction Coordinator.

Is there an error after it?

If so, have you run comclust on both nodes of the cluster to make MSDTC
cluster aware?

I not run it on both nodes and then take SQL Server off line and back on
line. Then try your query.

Rand
This posting is provided "as is" with no warranties and confers no rights.

There is a masage before it:
"Using dynamic lock allocation. [2500] Lock Blocks, [5000] Lock Owner
Blocks."

I run comclust on both nodes.

Thanks,
Yuval Peleg

*** Sent via Developersdex http://www.developersdex.com ***