No transaction is active on MSCS

• thor.elpoderoso

  Old Hand

  Points: 328

  More actions

  November 17, 2022 at 6:23 pm

  #4114470

  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!

  • This topic was modified 2 years, 10 months ago by thor.elpoderoso.

• thor.elpoderoso

  Old Hand

  Points: 328

  More actions

  November 17, 2022 at 9:12 pm

  #4114534

  Hi

  I have followed these steps, but it still gives error

  https://social.msdn.microsoft.com/Forums/sqlserver/en-US/2ae98e8b-2e68-434a-b934-75519d05a5c0/msdtc-issue-on-sql-cluster?forum=sqldisasterrecovery