Home Forums SQL Server 2005 SQL Server 2005 General Discussion OLE DB provider "SQLNCLI" for linked server " " returned message "No transaction is active." RE: OLE DB provider "SQLNCLI" for linked server " " returned message "No transaction is active."

  • November 13, 2014 at 3:51 am

    #1758171

    Hi All,

    I got the below error while attempting to run a distributed transaction. The two servers are in different workgroup. We dont have a domain. Please let me know the solution.

    OLE DB provider "SQLNCLI11" for linked server "SERVERDNSNAME" returned message "No transaction is active.".

    Msg 7391, Level 16, State 2, Line 3

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

    ______________________________________________________________Every Problem has a Solution; Every Solution has a Problem: 🙂