When I create a pull subscription from my main database, I go through all the steps and successfully create a the subscription.
However, when I drill down in the replication monitor on the publisher down to the database thats being published, the snapshot agent says it has succeded but has not generated a snapshot because no subscriptions needed initialization. Also, the distribution agent listed says it has never started. No matter what I do I cant get it to start.
I do believe the problem resides on the Pull subscription, as when I drop over to the remote database in Enterprise Manager and look at the pull subscription agent, it gives the following error:
The subscription to publication '(Null)' has expired or does not exist.
I have looked up this error, and the following article describes how to alleviate this problem for SQL 7.0 but I'm using SQL 2000, and I cannot figure out how to follow steps 2,3,4 as the distribution agent has never started yet anyway, and there is no obvious way to change the subscriber name.
http://support.microsoft.com/kb/q290054/
The script runs great, and returns an uppercase subscriber name, but I cannot figure out how to follow the next steps, any further detail would certainly be appreciated on steps 2,3,4.
>> Stay informed about: The subscription to publication Null has expired or does not