"Charles Kangai" wrote:

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