Distributed Transaction Issue for Linked Server in SQL Server 2008


  • I am running  W2K8, with SQL Server 2008. I am trying to execute one SP from one box to insert records in the table which lies on another box.

    I am getting below error message.

    "OLE DB provider "SQLNCLI10" for linked server "ASTDB05C\DDCHGRP2" returned message "No transaction is active.".
    Msg 7391, Level 16, State 2, Line 5
    The operation could not be performed because OLE DB provider "SQLNCLI10" for linked server "ASTDB05C\DDCHGRP2" was unable to begin a distributed transaction."


    I have followed each guideline mentioned in;en-us;306212.

    Still I am getting above error. Firewall setting are also turned off for both the boxes.

    Please advice.



    miércoles, 06 de julio de 2011 4:35

Todas las respuestas