Post reply

linked server problem

  • November 30, 2006 at 5:32 pm

    #170511

    I use 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? I got an error message like following:

    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.

    Please help. Thanks.

  • December 4, 2006 at 8:00 am

    This was removed by the editor as SPAM

  • December 31, 2009 at 12:37 pm

    #1098000

    The "Distributed Transaction Coordinator" should be located under Windows services. Is it not there on that server?

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply