No transaction is active on MSCS

Thor El Poderoso 51 Reputation points

I have a SQL 2019 STD on MSCS and when I execute a query against a SQL 2019 STD without cluster through a linkserver it shows me the following error:

OLE DB provider "MSOLEDBSQL" for linked server "SQL02" returned message "No transaction is active.".

Msg 7391, Level 16, State 2, Line 7

The operation could not be performed because OLE DB provider "MSOLEDBSQL" for linked server "SQL02" was unable to begin a distributed transaction.

I have set the DTC but it still gives error.

I have read that maybe I need "Windows Cluster MSDTC" at the MSCS level?


SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,325 questions
0 comments No comments
{count} votes

2 answers

Sort by: Most helpful
  1. Thor El Poderoso 51 Reputation points
    0 comments No comments

  2. PandaPan-MSFT 1,911 Reputation points

    Hi @Thor El Poderoso ,
    I set my ag on the VM, so I checked your link and I think the step is ok with me. But may I ask did you try downloading the latest version of OLE DB?

    0 comments No comments