Home Forums SQL Server 2005 SS2K5 Replication Getting error when setting up subscription RE: Getting error when setting up subscription

  • June 10, 2008 at 12:26 pm

    #826886

    I am using getting the following error

    INSERT TempErrorDetailsParameters Exec DBServer.DBName.dbo.GetEmployees '03/01/2008','03/31/2008'

    OLE DB provider "SQLNCLI" for linked server "DBServer" returned message "No transaction is active.".

    Msg 7391, Level 16, State 2, Line 1

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

    I have set the MS DTC. It works but suddenly it stops working and throws the error.

    What to do now?

    Thanks.

    Gunjan.