No transaction is active on MSCS

Thor El Poderoso 51 Reputation points
2022-11-17T18:30:25.31+00:00

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?

Thanks!

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
    2022-11-17T21:12:32.447+00:00
    0 comments No comments

  2. PandaPan-MSFT 1,911 Reputation points
    2022-11-18T02:08:47.223+00:00

    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?
    https://learn.microsoft.com/en-us/sql/connect/oledb/download-oledb-driver-for-sql-server?view=sql-server-ver16

    0 comments No comments