Over the weekend, I just moved our production SQL Server 7.0 cluster to new SQL 2000 clustered environment. Everything looks good except one issue.
I have a stored procedure that opens a transaction, inserts some records into a linked server, and then closes the transaction. I am getting the following error:
Server: Msg 7391, Level 16, State 1, Line 3
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 have followed the steps in Q329332 to configure MS DTC to use Network DTC Access (I did this on the active node). I have also taken the MS DTC resource offline, and then back online.
In addtion, I have tested the code using the "BEGIN DISTRIBUTED TRANSACTION" syntax, but get the same error.
These steps did not resolve my issue. Does anyone have any input on what I may be missing?
Nodes are running W2K03 Server.
2/9/2004 - Just realized I posted this under the YUKON administration thread. Meant it to be under the SQL Administration thread. If there is an administrator who can move this to the appropriate forum, I would appreciate it.