When Trying to Replicate I got an issue with the Snapshot Agent.
Please be kind enough to help me I am developing a system using SQL server Mobile for a Construction Site. This is for my final Project in Bachelors Degree.
Please reffer the Error that I got. bellow.
Creating Publication
- Creating Publication 'SQLMobile' (Success)
· SQL Server created publication 'SQLMobile'.
- Adding article 3 of 3 (Success)
· Article 'FlightData' was added.
· Article 'MembershipData' was added.
· Article 'sysdiagrams' was added.
- Starting the Snapshot Agent (Warning)
Messages
SQL Server could not start the Snapshot Agent.(New Publication Wizard)
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=9.00.1399.06&EvtSrc=Microsoft.SqlServer.Management.UI.PubWizardErrorSR&EvtID=CantStartSnapshotAgent&LinkId=20476
ADDITIONAL INFORMATION:
An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)
SQLServerAgent is not currently running so it cannot be notified of this action.
Changed database context to 'SQLMobile'. (Microsoft SQL Server, Error: 22022)
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=09.00.1399&EvtSrc=MSSQLServer&EvtID=22022&LinkId=20476
Thanks
Mark.
The error is:
- Starting the Snapshot Agent (Warning)
Messages
SQL Server could not start the Snapshot Agent. (New Publication Wizard)
You need to see why the snapshot agent could not be started. You can start by drilling down into the history of the snapshot agent in Replication Monitor, you can also query the distribution database for table MSsnapshot_history.
No comments:
Post a Comment