Connecting to a remote sql server for merge replication (push) in SQL Server 2005 Replication

Discussion in 'microsoft.public.sqlserver.replication' started by pete970t, Jun 26, 2007.

  1. pete970t

    pete970t Guest

    I am trying to setup a merge (push) replication to a server/database
    in a
    remote network. I created the publication and connected to the remote
    network using VPN but cannot register nor see the remote sql server.
    In sql
    server 2000, I was able to register the server in my Enterprise
    Manager
    (after creating an alias) and then created the push subscription. I
    connect
    to the remote network server using VPN. How do I go about doing this
    in SQL
    Server 2005? The publisher is a WorkGroup edition while the subscriber
    is
    standard edition. Authentication is set to both win and sql and
    verified
    the user and password used to attempt registration. Any help will be
    greatly appreciated.
     
    pete970t, Jun 26, 2007
    #1
    1. Advertisements

  2. Create an alias on the publisher to the subscriber. Use client network
    utility to do this, and for the server name use its fully qualified domain
    name. Try to ping both servers from each other.

    You may have to use anonymous subscribers to get this to work if you can't
    map an unc drive between the two.

    --
    Looking for a SQL Server replication book?
    http://www.nwsu.com/0974973602.html

    Looking for a FAQ on Indexing Services/SQL FTS
    http://www.indexserverfaq.com
     
    Hilary Cotter, Jul 2, 2007
    #2
    1. Advertisements

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments (here). After that, you can post your question and our members will help you out.