none
Distributed Transaction Issue for Linked Server in SQL Server 2008

    Pregunta

  • 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 http://support.microsoft.com/default.aspx?scid=kb;en-us;306212.

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

    Please advice.

     

    Regards,

    Milind
    Mil's
    miércoles, 06 de julio de 2011 4:35

Todas las respuestas