I'm having problems executing stored procedures with references to linked servers. Whenever I try to do that I get this:
Server: Msg 7391, Level 16, State 1, Procedure wf_maalgruppe_create, Line 8
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].
I've tried a couple of things like using static ports instead of dynamic ports, checking the DTC settings and using a different service SQL provider - all to no avail.
Is there anybody who can help with this very irritating problem?