What configurations do I need to fix the "unable to begin a distributed transaction" error when trying to run a remote procedure?
2
votes
2
answers
11760
views
This is the error message I'm receiving:
> Msg 7391, Level 16, State 2, Procedure spStoredProc, Line 62 [Batch Start Line 1]
> The operation could not be performed because OLE DB provider "SQLNCLI11" for linked server "MyLinkedServer" was unable to begin a distributed transaction.
As a test my stored procedure query is just
SELECT 1 AS A
and works locally on the server but doesn't work when I call it remotely on a linked server.
Asked by J.D.
(40893 rep)
Feb 24, 2020, 11:07 PM
Last activity: Dec 3, 2022, 12:05 PM
Last activity: Dec 3, 2022, 12:05 PM