SQL Server Performance

Wierd error

Discussion in 'General DBA Questions' started by korzon, Apr 1, 2004.

  1. korzon New Member

    I run the following SQL statement using query analyzer on a windows 2003 server with sql 2000 SP3 installed:
    --------- Begin paste code ----------
    update assigns set mirsStatus=
    (select Status from MIRS.EGGEDTRIDB.dbo.assignments mirs where Assigns.AssignId = mirs.assignId)
    where assigns.fromdate > getdate()-2
    --------- End paste code ------------

    I receive the following error:

    ----------- Begin paste code ------------
    Server: Msg 7391, Level 16, State 1, Line 1
    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].
    ----------- End paste code

    "MIRS" the server I a connecting to is running windows 2000 with SQL 2000 SP3 and is not part of the domain. It is located in the DMZ and there is a firewall between the two.

    However, The firewall has been configured correctly and is not blocking any traffic between the two servers. In addition, a few strange errors have started to occur that have something to do with DTC and the windows 2003 server in recent days. However those are problems that we are unable to duplicate and therefore I don't have too much details considering those.

    any help is appreciated, we pretty much ran out of ideas (And we didn't have many to begin with).

    Thank you.
  2. Luis Martin Moderator

  3. satya Moderator

    Search under the forums for similar posts earlier for their resolution, where Argyle mentioned useful analysis to recover the issue.

    Satya SKJ
    Moderator
    http://www.SQL-Server-Performance.Com/forum
    This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
  4. Argyle New Member

Share This Page