Post reply

Pull Subcription question

  • October 6, 2004 at 11:32 pm

    #86631

    Dear all,

    I have 2 SQL server runing in different subnet. One SQL server is configure as a publisher. When i tried to configure a pull subcription from another system, i only manage to register the publisher but  unable to see the replication object.

    Please advise any possibility that will cause this problem?

    Thanks in advance.

  • October 7, 2004 at 9:31 pm

    #525878

    This may be because the subscriber is not in the publication access list. 

    How is the subscriber connecting to the publisher ?  i.e. what SQL Server Login or Windows Account is it using.  This needs to be in the publication access list.  If not, you will not be permitted to subscribe.

    Running the servers on different subnets is no issue.  This is pretty common and if you can see the publisher from the subscriber (not from your PC/Workstation but from a session such as remote desktop on the subscriber)  then this will not stop you subscribing to publications.

  • October 10, 2004 at 6:28 pm

    #526067

    Hi Happycat,

    Thanks for the reply. i'm using SQL server login(as sysadmin) & yes, the login ID is added into publication access list. I able to connect to the publisher from another server, but unable to see any publication objects.

    Is there any specific port i need to open on router in order for this to work? Please advise.  

    Thanks in advance.

  • October 10, 2004 at 8:30 pm

    #526071

    Check whether the subscribing server is allowed to be a subscriber.  This is done on the publisher.  Probably easiest done by using the "Configure Publishing and Distribution Wizard".

     

  • October 11, 2004 at 3:35 am

    #526104

    Hi HappyCat59,

    Thanks for the help. Manage to make it work after added the subscribing server. Thanks.

     

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply