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.
An exception occured while executing a Transact-SQL statement or batch.
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.
Can you please help me in fixing the Issue.