dale_abrams
asked on
sql server replication log reader agent
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.
The replication is one with updatable subscribers. The publisher is SQL Server 2005 and the two subscribers are SQL Server 2008 R2.
ASKER
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.
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.
ASKER CERTIFIED SOLUTION
membership
Create a free account to see this answer
Signing up is free and takes 30 seconds. No credit card required.
ASKER
The single attempt at helping was not related to my issue.
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"