locked
Replication : No agent status information is available. RRS feed

  • Question

  • Hi All,

    Regarding Replication, iam getting this error while create the Merge Replication (No agent status information is available.) at Subcriber.

    Kindly help me to find out the exact rootcause.

    any idea will be appreciable.

    Thanks in advance....

    Regards

    Rajesh Kumar Tuta

    rajeshtuta@live.com

     

     

     

    Tuesday, December 20, 2011 6:42 AM

Answers

  • You are having a problem with merge replication.  I am suspecting a permissions issue somewhere along the line.

    Best thing to do is to run the merge agent from the console and see where it is failing and what error messages are being generated.

    Open up replication monitor, expand your publication, right click on the problem subscription, select view details, Action, Merge Agent Properties, click on Steps, Run Agent, Click on Edit, and then copy the string you see in the command window. On your publisher open up a command prompt and go to

    c:\Program Files\Microsoft SQL Server\100\COM and then type replmerg.exe and then paste the command that you obtained from above. Then click enter to run this. Post back the last 20 or so lines from the command window here.


    looking for a book on SQL Server 2008 Administration? http://www.amazon.com/Microsoft-Server-2008-Management-Administration/dp/067233044X looking for a book on SQL Server 2008 Full-Text Search? http://www.amazon.com/Pro-Full-Text-Search-Server-2008/dp/1430215941
    • Proposed as answer by Peja Tao Thursday, December 22, 2011 7:01 AM
    • Marked as answer by Peja Tao Tuesday, December 27, 2011 8:52 AM
    Tuesday, December 20, 2011 2:24 PM
    Answerer

All replies