Starting Transaction in Linked Server (When MSDTC installed).

We are using linked servers(Server1 & server2). MSDTC is installed.

When i try fire a query inside a transaction it gives an error.

Qry is :
BEGIN TRANSACTION
SELECT * FROM JDEDB.JDE_PRODUCTION.PRODDTA.F0911z1
COMMIT TRAN GO



Following Error Message :
"Server: Msg 7391, Level 16, State 1, Line 2
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::Jo
inTransaction returned 0x8004d00a]. "

thanx in advance

Hi
Try
BEGIN DISTRIBUTED TRAN
.......

COMMIT TRAN
"vignesh" <vignesh@discussions.microsoft.com> wrote in message
news:B682D4A6-0866-42E4-A8C3- 7C2036C59D0B@microso
ft.com...
> We are using linked servers(Server1 & server2). MSDTC is installed.
>
> When i try fire a query inside a transaction it gives an error.
>
> Qry is :
> BEGIN TRANSACTION
> SELECT * FROM JDEDB.JDE_PRODUCTION.PRODDTA.F0911z1
> COMMIT TRAN GO
>
>
>
> Following Error Message :
> "Server: Msg 7391, Level 16, State 1, Line 2
> 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::Jo
inTransaction returned 0x8004d00a]. "
>
> thanx in advance

Not working , Getting the same error.

"Uri Dimant" wrote:

> Hi
> Try
> BEGIN DISTRIBUTED TRAN
> ........
>
> COMMIT TRAN
> "vignesh" <vignesh@discussions.microsoft.com> wrote in message
> news:B682D4A6-0866-42E4-A8C3- 7C2036C59D0B@microso
ft.com... 
> 'SQLOLEDB' 
>
>
>

Well,does MSDTC  service run ?


"vignesh" <vignesh@discussions.microsoft.com> wrote in message
news:F6EDFEA9-0E0D-4D3E-9888- 427D7DB29CB8@microso
ft.com...
> Not working , Getting the same error.
>
> "Uri Dimant" wrote:
> 
the 

Yes it is running. modified the query as

BEGIN distributed TRANSACTION
SELECT * FROM JDEDB.JDE_PRODUCTION.PRODDTA.F0911z1
COMMIT TRAN GO


"Uri Dimant" wrote:

> Well,does MSDTC  service run ?
>
>
> "vignesh" <vignesh@discussions.microsoft.com> wrote in message
> news:F6EDFEA9-0E0D-4D3E-9888- 427D7DB29CB8@microso
ft.com... 
> the 
>
>
>