Re: Enlist Problem : Transaction Across Two database Server

Labhesh Shrimali - Bangalore
(LabheshShrimaliBangalore@xxxxxxxxxxxxxxxxxxxxxxxxx) writes:
I m using sql server 2000.
i have Two database server in network having same configuration

I have written one trigger which will update Second database and then
first database.

But this does not happen and i get error. as follow:

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. ]
3

What could be this problem?
Please help required urgent.

I think I've seen this myself, but I cannot recall that I was able to
resolve it.

What you could try is say before the statement that fires the trigger

BEGIN DISTRIBUTED TRANSACTION

You can also try adding

SET XACT_ABORT ON

Both are these are fairly wild guesses on my part, so I don't really
expect them to work.


By the way, which version (including service pack) of Windows and
SQL Server do you have on the two machines? Are any firewalls active?
Are the servers in the same domain?


--
Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx
.

Relevant Pages