Snapshot agent never started

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » SS2K5 Replication » Snapshot agent never started

Snapshot agent never started

Rate Topic

Display Mode

Topic Options

Author

Message

Ed7

Posted Thursday, December 06, 2007 3:44 PM

Old Hand

Group: General Forum Members
Last Login: Monday, May 20, 2013 10:00 PM
Points: 347, Visits: 888

Hi Everyone,

I setup a trans replication with local distributor push between sql server 2005 (subscriber) and sql server 2000 (publisher and distributor).

The snapshot agent never started.

I tried to start and stop the snapshot agent but it did not help.

Please help and advise.

Best regards,
TJ

Post #430482

vyas

Posted Thursday, December 06, 2007 9:59 PM

Hall of Fame

Group: General Forum Members
Last Login: Thursday, May 16, 2013 4:02 AM
Points: 3,131, Visits: 1,056

The owner of the job (who is probably the user who created the job or who first set up replication) does not have the necessary permissions.

Post #430524

Prakash Heda

Posted Friday, January 25, 2008 2:19 AM

Old Hand

Group: General Forum Members
Last Login: Sunday, February 17, 2013 2:38 AM
Points: 369, Visits: 392

open ssms >> add sql 2000 server there >> open sql 200 server and open publisher /distributor / subscription properties there in security tab use proper sql authentication to to connect to all these sql servers....if once this is working do R&D for windows authentication by changing one by one...

remember all in ssms 2005 not sql 2000 enterprise manager

Prakash Heda
Lead DBA Team - www.sqlfeatures.com
Video sessions on Performance Tuning and SQL 2012 HA

Post #447354

Animal Magic

Posted Monday, January 28, 2008 5:45 PM

SSC Eights!

Group: General Forum Members
Last Login: Wednesday, May 22, 2013 9:08 AM
Points: 983, Visits: 13,350

What error message are you getting in the job history?

Post #448645

« Prev Topic | Next Topic »

Permissions