• I just found out that on the remote server, the MSDTC setting is on "Mutual Authentication Required"; it should be on "No Authentication Required".

    I will change it and restart the MSDTC and SQL services, and see if that fixes the issue:

    begin distributed transaction

    select * from LinkedSrvrName.dbName.dbo.tblName

    rollback tran

    Error:

    OLE DB provider "SQLNCLI10" for linked server "LinkedSrvrName" returned message "No transaction is active.".

    Msg 7391, Level 16, State 2, Line 4

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

    __________________________________________________________________________________
    SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
    Persisting SQL Server Index-Usage Statistics with MERGE[/url]
    Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]