locked
Linked server : The partner transaction manager has disabled its support for remote/network transactions. RRS feed

  • Question

  • Hi,

    I have two SQL Servers Server A and Server B. ServerA has SQL Server 2008 and ServerB has SQL Server 2005.

    I need to fetch data from server B to server A and insert it into a table on server A.

    For this purpose, I have created a stored proc on server B and for calling that SP I have added server B as linked server on server A.

    When I execute this SP from server A using server B, it returns data without any issue.
    However when I try to insert this data to a local table on server A, I am getting following error:

    OLE DB provider "SQLNCLI10" for linked server "ServerB" returned message "The partner transaction manager has disabled its support for remote/network transactions.".
    Msg 7391, Level 16, State 2, Line 12
    The operation could not be performed because OLE DB provider "SQLNCLI10" for linked server "ServerB" was unable to begin a distributed transaction.

    Note that I have not started any transaction in both the calling and called procs. I am not getting why it is trying to begin a distributed transaction. And how to resolve this issue.

    I am using linked server for the first time. Please help.

    Thanks,
    Garima
    Tuesday, May 3, 2011 9:02 AM

Answers

  • Hi All,

    Thanks for your responses.

    I have been able to resolve the issue after executing the following command on server A:

    EXEC sp_serveroption @server = 'ServerB',@optname = 'remote proc transaction promotion', @optvalue = 'false' ;

    • Marked as answer by iGary Tuesday, May 3, 2011 11:20 AM
    Tuesday, May 3, 2011 11:19 AM

All replies