Wierd error | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Wierd error

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.

Check: http://support.microsoft.com/default.aspx?scid=kb;en-us;306212 Luis Martin
Search under the forums for similar posts earlier for their resolution, where Argyle mentioned useful analysis to recover the issue. Satya SKJ
This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
MSDTC and SQL on Windows 2003