Solved

sql server replication log reader agent

Posted on 2010-11-12
4
1,213 Views
Last Modified: 2012-05-10
I am trying to restart a stopped log reader agent for sql server replication. The agent is reporting "Could not retrieve agent status. (Object reference not set to an instance of an object. (Replication.Utilities))" even though the publication shows up in sql server management studio and I am able to run the snapshot agent. Not sure what to do to get this going again.

The replication is one with updatable subscribers. The publisher is SQL Server 2005 and the two subscribers are SQL Server 2008 R2.
0
Comment
Question by:dale_abrams
  • 3
4 Comments
 

Expert Comment

by:karlmc15
ID: 34124770
hi
this bug from Microsoft, download hotfix from them:

http://support.microsoft.com/kb/935922/

FIX: Error message when you install Microsoft Dynamics CRM:"Setup failed to validate specified Reporting Services Report Server" or "Setup requires SQL Server Reporting Services 2005 Hotfix for role creation on SQL Reporting Service SP2 Workgroup edition"
0
 
LVL 1

Author Comment

by:dale_abrams
ID: 34125006
Hello karlmc15,
That article doesnt seem to address my problem. I am having issues with replication and have not installed any reporting servers as the article addresses.
0
 
LVL 1

Accepted Solution

by:
dale_abrams earned 0 total points
ID: 34847722
I ended up hiring an outside vendor to take care of the issue. Not sure what the resolution is, but the problem is fixed.
0
 
LVL 1

Author Closing Comment

by:dale_abrams
ID: 34882069
The single attempt at helping was not related to my issue.
0

Featured Post

Creating Instructional Tutorials  

For Any Use & On Any Platform

Contextual Guidance at the moment of need helps your employees/users adopt software o& achieve even the most complex tasks instantly. Boost knowledge retention, software adoption & employee engagement with easy solution.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Why is this different from all of the other step by step guides?  Because I make a living as a DBA and not as a writer and I lived through this experience. Defining the name: When I talk to people they say different names on this subject stuff l…
For both online and offline retail, the cross-channel business is the most recent pattern in the B2C trade space.
Via a live example, show how to setup several different housekeeping processes for a SQL Server.
Using examples as well as descriptions, and references to Books Online, show the documentation available for datatypes, explain the available data types and show how data can be passed into and out of variables.

726 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question