Post reply

Another Linked Server Issue - Win 2003 Server

  • February 16, 2004 at 9:02 am

    #161625

    I have implemented linked servers between a Windows 2000 Server and 2003 server.  All things worked well.  I was able to perfrom datamanipulation inside of transactions by using XACT_ABORT.

    We replaced our 2000 server with 2003 server on a new box.  Now my link between the servers is not fully functional.  I can still perform updates between the servers, but not within a transaction.

    Both servers are running Windows 2003 Server Standard; SQL Server 2000 SP 3.  Use of XACT_ABORT no linger resolves the issue.

    The error message presented is as follows.

    Server: Msg 7391, Level 16, State 1, Line 5

    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::JoinTransaction returned 0x8004d00a].

  • February 16, 2004 at 1:07 pm

    #494235

    you want to check this


    * Noel

  • February 16, 2004 at 1:57 pm

    #494243

    Thanks.  That led me to the issue.  I need to use sp_dropserver to correctly rename the server because @@ServerName doesn't match the name of the server.

  • February 16, 2004 at 2:20 pm

    #494252

    It looks that we are in synch today


    * Noel

Viewing 4 posts - 1 through 4 (of 4 total)

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