Friday, September 14, 2012 6:09 PM
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.
Friday, September 14, 2012 7:53 PM
- Check the sql server error & SQL agent log and share the error logged there.
- Check & share the configuration manager & services.msc for current state of SQL agent service.
- Try to run some other jobs & check it it run or not.
This posting is provided with no warranties and confers no rights.
Please remember to click Mark as Answerand Vote as Helpfulon posts that help you. This can be beneficial to other community members reading the thread.
Wednesday, September 19, 2012 4:31 PM
I had restarted the Sql server agent on the subscriber and it is now working.
- Marked As Answer by Shulei ChenModerator Thursday, September 20, 2012 1:28 AM