April 16, 2008 at 10:35 am
After creating a publication and multiple subscriptions, a trigger to one of the publication articles, which required the snapshot to be regenerated in order to synchronize it with the subscribers. When attempting to start the snapshot agent, the following error is returned "SQLServerAgent is not currently running so it cannot be notified of this action." Error 22022. When I check Windows Services, the SQLServerAgent service for this database instance is running.
I restarted the SQL Server and Agent services for this instance and the issue persisted.
I then deleted all the subscriptions for the publication and the publication itself and then recreated it. Again the issue persists.
has anyone come across this before?
April 17, 2008 at 12:24 pm
Additional information:
sp_addmergepublication executes fine.
sp_addpublication_snapshot @publication executes fine but returns this message.
sp_startpublication_snapshot @publication execution fails with this message.
April 17, 2008 at 1:32 pm
The problem was that the SQL Server Agent was running on the publisher but not running on the distributor.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply