Post reply

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

  • 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

  • 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/[/url]

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply