April 21, 2011 at 2:34 pm
Am setting up replication between two servers, and am getting the following error.
Can any one help me with this?
Thanks
TITLE: New Subscription Wizard
------------------------------
SQL Server could not start the Snapshot Agent.
------------------------------
ADDITIONAL INFORMATION:
An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)
------------------------------
SQLServerAgent Error: Request to run job WKSP00005E29\SQL2008-XYZ-XYZ-1 (from User XYZ) refused because the job is already running from a request by User XYZ.
Changed database context to 'PackageID'. (Microsoft SQL Server, Error: 22022)
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=10.00.2766&EvtSrc=MSSQLServer&EvtID=22022&LinkId=20476
------------------------------
BUTTONS:
OK
------------------------------
April 25, 2011 at 8:14 am
When you configure replication, there is snapshot job configured between a publication and subscriber. Check in the in the list of jobs with name of the publication running snapshot , check the status of the job.
Error you are receiving because the snapshot for that publication is already running.
You can also run the sp_who2 active to check the status of the spids running on the sever.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply