Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

SQL Server Could not start Snapshot Agent Expand / Collapse
Author
Message
Posted Friday, September 14, 2012 12:15 PM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Tuesday, March 04, 2014 8:39 AM
Points: 202, Visits: 1,047


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,
Post #1359547
Posted Wednesday, September 19, 2012 10:29 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Tuesday, March 04, 2014 8:39 AM
Points: 202, Visits: 1,047
Hi ,

I had restarted the agent. It is working now.

Thank You,
Post #1361492
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse