Sample Header Ad - 728x90

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