Replication Qn

[Tomi]

With SQl 2000 I had created a publication on srv1 and Iam is trying to do transactional
push subscription to srv2 .When I select push the subscription on srv1 , the srv2 is
not listed under enabled subscribers- how do I enable the subscriber on srv2 ?

Thanks in advance
Tomi

 

[mrdenny]

You need to configure the distributer to enable svr2 as a subscriber.

Denny
MCSA (2003) / MCDBA (SQL 2000)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com

 

[Tomi]

Thanks, I found it and got it working

Under replication item in Enterprise Manager , select subscribers right click and select configure publishing,subscribers and distribution.Select subscribers tab and click New to enable/add subscribers.You will be asked the subscriber type ,server name and authentication.
Tomi

 

[mrdenny]

no problem.

Denny
MCSA (2003) / MCDBA (SQL 2000)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com