title: OLE DB provider "SQLNCLI11" for linked server "Servername" returned message "No transaction is active."
body: <p>I have a database which is on another server. I created the linked server in my mssql and inserting data on a live database by firing the trigger whenever I insert data in my local database.
  I also set configurations in MSDTC from component service and restart server and client many times</p>
  
  <p>But still getting this error </p>
  
  <blockquote>
    <p>OLE DB provider "SQLNCLI11" for linked server "Servername" returned message >"No transaction is active.</p>
  </blockquote>
  
  <pre><code>    USE HWMS
  GO
  SET ANSI_NULLS ON
  SET QUOTED_IDENTIFIER ON
  GO
  
  CREATE TRIGGER dbo.AshCollInsert    // trigger name
     ON  hwms.dbo.AshCollection       // local db table
     AFTER INSERT AS 
  BEGIN
      -- SET NOCOUNT ON added to prevent extra result sets from
      -- interfering with SELECT statements.
      SET NOCOUNT ON;
  
      -- Just INSERT everything from the [inserted] pseudotable into
      --the target table
      INSERT INTO [ServerName].[HWMS].dbo.AshCollection2     // server db table 
                (id, UserId, IncinatorId,In_Weight,IncineratorCollectTime,Barcode,flex,flag)
          SELECT id, UserId, IncinatorId,In_Weight,IncineratorCollectTime,Barcode,flex,flag
          FROM   inserted;
  
  END
  GO
  </code></pre>