procedure problem

I tried to run a procedure SQL2005 and it gives me the following error:

Msg 7391, Level 16, State 2, Procedure  EAI_ADM_STUDENT_ins_
upd_trg, Line 804

The operation could not be performed because OLE DB provider "SQLNCLI" for
linked server "10.2.0.119" was unable to begin a distributed transaction.

Can anyone please tell me how to fix? Thanks.

Have you enabled remote connection on SQL Server 2005?
Do you have ping to the server?


"-000MJ" <mj@yahoo.com> wrote in message
 news:%23J%234$4qEHHA
.2328@TK2MSFTNGP02.phx.gbl...
>I tried to run a procedure SQL2005 and it gives me the following error:
>
> Msg 7391, Level 16, State 2, Procedure  EAI_ADM_STUDENT_ins_
upd_trg, Line
> 804
>
> The operation could not be performed because OLE DB provider "SQLNCLI" for
> linked server "10.2.0.119" was unable to begin a distributed transaction.
>
> Can anyone please tell me how to fix? Thanks.
>
>

I did try to do the manual update query on a table in my server using script
to the linked server and it works. But it only not works in this procedure.
Strange!

"Uri Dimant" <urid@iscar.co.il> wrote in message
news:OfQ%235drEHHA.5028@TK2MSFTNGP03.phx.gbl...
> Have you enabled remote connection on SQL Server 2005?
> Do you have ping to the server?
>
>
> "-000MJ" <mj@yahoo.com> wrote in message
>  news:%23J%234$4qEHHA
.2328@TK2MSFTNGP02.phx.gbl... 
>
>

How do you call stored procedure? from an appliaction?




"-000MJ" <mj@yahoo.com> wrote in message
news:O6jlWHsEHHA.3660@TK2MSFTNGP06.phx.gbl...
>I did try to do the manual update query on a table in my server using
>script to the linked server and it works. But it only not works in this
>procedure. Strange!
>
> "Uri Dimant" <urid@iscar.co.il> wrote in message
> news:OfQ%235drEHHA.5028@TK2MSFTNGP03.phx.gbl... 
>
>

Hi

Did you explicitly start a distributed transaction in the stored procedure?

John

"-000MJ" wrote:

> I did try to do the manual update query on a table in my server using scri
pt
> to the linked server and it works. But it only not works in this procedure
.
> Strange!
>
> "Uri Dimant" <urid@iscar.co.il> wrote in message
> news:OfQ%235drEHHA.5028@TK2MSFTNGP03.phx.gbl... 
>
>
>

I have used this:

set xact_abort on

begin distributed tran

Is this what you mean?



"John Bell" < jbellnewsposts@hotma
il.com> wrote in message
news:D17738A3-6BCB-48BC-A9DE- 8992E52AEAF8@microso
ft.com...
> Hi
>
> Did you explicitly start a distributed transaction in the stored
> procedure?
>
> John
>
> "-000MJ" wrote:
> 

I am really stuck on this problem. Can anyone please help? Thanks.

"-000MJ" <mj@yahoo.com> wrote in message
news:uNoWeD3EHHA.3396@TK2MSFTNGP02.phx.gbl...
>I have used this:
>
> set xact_abort on
>
> begin distributed tran
>
> Is this what you mean?
>
>
>
> "John Bell" < jbellnewsposts@hotma
il.com> wrote in message
> news:D17738A3-6BCB-48BC-A9DE- 8992E52AEAF8@microso
ft.com... 
>
>

Actually let me elaborate more. This procedure is a trigger which I update a
linked server and this is working very good in SQL 2000. But after I migrate
the database to SQL 2005. The trigger is not working with linked server any
more. I remember I need to start the distributed transaction coordinator in
service manager. But I couldn't find anything similar to this in SQL 2005.
Is it somewhere I need to start? Please help. Thanks.


"-000MJ" <mj@yahoo.com> wrote in message
news:uNoWeD3EHHA.3396@TK2MSFTNGP02.phx.gbl...
>I have used this:
>
> set xact_abort on
>
> begin distributed tran
>
> Is this what you mean?
>
>
>
> "John Bell" < jbellnewsposts@hotma
il.com> wrote in message
> news:D17738A3-6BCB-48BC-A9DE- 8992E52AEAF8@microso
ft.com... 
>
>

Can anyone please help?


"-000MJ" <mj@yahoo.com> wrote in message
news:O44nqqEFHHA.4432@TK2MSFTNGP03.phx.gbl...
> Actually let me elaborate more. This procedure is a trigger which I update
> a linked server and this is working very good in SQL 2000. But after I
> migrate the database to SQL 2005. The trigger is not working with linked
> server any more. I remember I need to start the distributed transaction
> coordinator in service manager. But I couldn't find anything similar to
> this in SQL 2005. Is it somewhere I need to start? Please help. Thanks.
>
>
> "-000MJ" <mj@yahoo.com> wrote in message
> news:uNoWeD3EHHA.3396@TK2MSFTNGP02.phx.gbl... 
>
>

Hi

Check out http://msdn2.microsoft.com/en-us/library/ms143698.aspx

John

"-000MJ" wrote:

> Actually let me elaborate more. This procedure is a trigger which I update
 a
> linked server and this is working very good in SQL 2000. But after I migra
te
> the database to SQL 2005. The trigger is not working with linked server an
y
> more. I remember I need to start the distributed transaction coordinator i
n
> service manager. But I couldn't find anything similar to this in SQL 2005.
> Is it somewhere I need to start? Please help. Thanks.
>
>
> "-000MJ" <mj@yahoo.com> wrote in message
> news:uNoWeD3EHHA.3396@TK2MSFTNGP02.phx.gbl... 
>
>
>