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

Snapshot agent never started Expand / Collapse
Author
Message
Posted Thursday, December 6, 2007 3:44 PM


Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Wednesday, May 21, 2014 3:22 PM
Points: 354, Visits: 915
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
Posted Thursday, December 6, 2007 9:59 PM
Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Today @ 6:08 AM
Points: 3,367, Visits: 1,072
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
Posted Friday, January 25, 2008 2:19 AM


Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Monday, July 21, 2014 11:32 AM
Points: 372, Visits: 414
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
Posted Monday, January 28, 2008 5:45 PM
SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Wednesday, August 27, 2014 2:46 AM
Points: 999, Visits: 13,480
What error message are you getting in the job history?
Post #448645
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse