SQL Server Could not start Snapshot Agent

• sql2k8

  Hall of Fame

  Points: 3455

  More actions

  September 14, 2012 at 12:15 pm

  #262005

  Hi ,

  I am trying to setup the Transactional Replication using pull subscription between server A and Server B.

  Server A and Server B are using SQL Server 2008 r2 enterprise edition 64 bit (RTM) on windows server 2008 r2 enterprise edition 64 bit SP1.

  Untill yesterday they are working.Yesterday the replication failed. So i am trying to setup the replication again and I could not establish the replication because the Snapshot agent was not running.

  Below is the error message which I was getting on the server A.

  SQL Server could not start the Snapshot Agent.

  Additional Information:

  An exception occured while executing a Transact-SQL statement or batch.

  (Microsoft.SqlServer.ConnectionInfo)

  SQL ServerAgent is not currently running so it cannot be modified of this action.

  Changed database context to 'Test'.(Microsoft SQL Server,Error 22022)

  The SQL Server Agent service is up and running. I checked in both the SQL Server Configuration Manager and Services also.

  I checked the Below Link through Google but it applies to SQL Server 2000.

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

  Can you please help me in fixing the Issue.

  Thank You,

• sql2k8

  Hall of Fame

  Points: 3455

  More actions

  September 19, 2012 at 10:29 am

  #1539684

  Hi ,

  I had restarted the agent. It is working now.

  Thank You,