Post reply

Linked server error

  • May 2, 2014 at 7:08 am

    #286454

    I get an error as below on SQL server 2008. The linked server tests successfully:

    Msg 7391, Level 16, State 2, Line 10

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

    Can someome please help me on this. I know there's a old post but that's does not work as well.

    Old post link:

    http://www.sqlservercentral.com/Forums/Topic1102122-146-1.aspx

  • May 2, 2014 at 7:59 am

    #1710344

    (Almost) everything you need to know about linked servers is listed here[/url]

    See if it helps.

    -- Gianluca Sartori

  • May 2, 2014 at 8:28 am

    #1710362

    (dup)

  • May 2, 2014 at 8:28 am

    #1710361

    Under Services, is the Distributed Transaction Coordinator running (Started), etc?

    If it is, are your settings configured correctly?

  • May 2, 2014 at 8:36 am

    #1710366

    Hi All

    thanks for the reply. The services is running. Currently my SQL is 10.50.400. May be this will help to figure out something.

    Thanks all again.

Viewing 5 posts - 1 through 4 (of 4 total)

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