December 20, 2007 at 4:50 pm
hey guys, i'm having a problem replicating to 2000. Whenever i check the subscription database in SQL 2000 instance there are no publish articles present.
However when setting up subscription from SQL 2005, it shows the following warning:
- Starting the synchronization agent(s) (Warning)
Messages
Subscriptions for the following Subscribers cannot be initialized immediately because the snapshot is not available:
INSPIRON1520\SQL_2005, INSPIRON1520\SQL_TEST_LAB (New Subscription Wizard)-- 2000 instance
Appreciate any help offered
thx much
December 21, 2007 at 2:53 pm
This is transactional repl, right?
Did you run your snapshot agent?
ChrisB MCDBA
MSSQLConsulting.com
Chris Becker bcsdata.net
December 21, 2007 at 6:41 pm
if you are using local logins you need to use a trick...cause you cannot add sql 2005 as distributor to sql 2000 management studio, so to verify authentication settings are correct in SSMS 2005 add 2000 sql server instance and then go ahead and add distributir to it...here check the publisher properties and verify distributer authentication is correct
if this is fine then check replication monitor and open publisher there and see status of your subcription....you can start/debug it right there...if its failing goto the job properties and get the job name and then run this job manually and check job history to see exact error message...
if still issue...you need to provide lot more detail ....
Prakash Heda
Lead DBA Team - www.sqlfeatures.com
Video sessions on Performance Tuning and SQL 2012 HA
December 28, 2007 at 8:39 am
run snapshot, run logreader and then start the subscrption to start the snapshot to the subscriber
make sure you connect to every server from SSMS
December 30, 2007 at 7:18 am
K, thx for the help
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply