Unanswered: Linked Server MSDTC Error with Windows Server 2003
I'm receiving the following error:
Server: Msg 7391, Level 16, State 1, Line 2
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].
The transaction active in this session has been committed or aborted by another session.
My configuration is Windows Server 2003 SP1 and SQL Server 2000 SE SP3a.
I was able to get the linked server statement to work if I select "No Authentication Required" under "Transaction Manager Communication" within MSTDC of Component Services. However the "No Authentication Required" scares me a bit.