Hi

When I am trying to insert value in remote server (Linked Server) or trying
to run query with BEGIN TRAN & COMMIT from query analyzer I am getting
following error.

*********************************
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 can't enlist in the
specified transaction coordinator].

OLE DB error trace [OLE/DB provider 'SQLOLEDB'
ITransactionJoin::JoinTransaction returned 0x8004d00a]
***********************************************

But when I remove BEGIN TRAN & COOMIT insert statement or query works fine.

Can some one please help me with this?

Check the following:
1) Have you executed: SET XACT_ABORT ON
This is required for distributed transactions.
2) Is MSDTC service running?

Charles Kangai, MCT, MCDBA
Author of Learning Tree's 4-day course: "SQL Server 2005 Integration
Services" http://www.learningtree.com/courses/134.htm
Author of Learning Tree's 4-day course: "SQL Server Reporting Services"
http://www.learningtree.com/courses/523.htm
email alias: charles
email domain: kangai.demon.co.uk


"Raj" wrote:

Hi Charles,

Thanks for the reply.

Yes I have executed SET XACT_ABORT ON and my MSDTC is also running. Unable
to find out why its not working anyhelp will be highly appreciated.

cheers
Raj

"Charles Kangai" wrote: