sql server replication: Unable to Add *any* Subscribers -- sql server replication

Unable to Add *any* Subscribers

MStanbrook
8/20/2004 7:39:02 AM

sql server replication:

I've got a connection to a remote MSSQL 2000 box, Called "BOXA" via
EnterpriseManager and the "sa" account.

BOXA is currently set up as a distributor, as well as the destination for a
PUSH replication from another box (BOXB). This replication works fine.

I've set up a new publication on BOXA which will be "pulled" by BOXB,
however I am unable to add BOXB as a registered subscriber on BOXA.

On BOXA, if I right-click on "Replication Monitor", select Distributor
Properties, there are *no tabs" for "Publication Databases" or "Subscribers".

Any suggestions?

TIA.
--

Re: Unable to Add *any* Subscribers

Andre Alicea
8/23/2004 10:33:09 AM

1. Highlight your distributor box (BoxA) inside of Enterprise Manager. Go
to Tools -> Replication -> Configure Publishing, Subscribers, and
Distribution......

2. The Publisher and Distributor Properties dialog box will appear. There
should be a tab there for Subscribers.

3. Click the Subscribers tab and click the 'New...' button to add BoxB as a
Subscriber.

This should allow you to continue.

-Andre

[quoted text, click to view]