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

• jamessdba

  SSCrazy

  Points: 2256

  More actions

  May 11, 2016 at 7:05 am

  #327059

  Hi experts

  while debug code getting error

  Distributed Transaction like the one below across the linked servers would fail immediately.

  begin distributed tran

  Select * from linkedServer.DBName.dbo.TableName

  commit tran

  Error message Appear

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

  please suggest to fix this issue

• johnwalker10

  SSCrazy Eights

  Points: 9124

  More actions

  May 11, 2016 at 10:50 pm

  #1878434

  Take a look at this article hope this will help you out: http://blog.sqlauthority.com/2015/10/03/sql-server-linked-server-creation-error-ole-db-provider-sqlncli11-for-linked-server-returned-message-invalid-authorization-specification/%5B/url%5D