sqlserver 2005 replication un-trusted domains

Posted on 2007-07-23
Last Modified: 2011-09-20
I'm trying to implement replication using two pcs which are not on the same domain and the domains are not trusted.  currently pc A is given access to pc B on the firewall.

So I'm wondering how I go about setting this up.  I would like to have the publication save the files from pc A to pc B, but that doesn't seem to work.

Question by:Fraser_Admin
    LVL 3

    Accepted Solution

    If you have SQL Server 2005 Enterprise Edition you can use "Web Replication" to replicate over port 443.

    If you do not have access to Enterprise Edition you have to open port  1433 (for sql server) and 21 (for ftp) to drive the traffic. This is not safe if you have to go over a public network, so it is better to set up a manual system to move the replication files over the non trusted part of the network (via sftp or something.)

    Author Comment

    No i only have workgroup edition.  is there some good sample document to give step by step how to set this up?
    LVL 3

    Expert Comment


    Author Comment

    this document appears to be for 2000.  i'm using 2005.

    i'm creating the publication and i would like to save the files to the other server.  so i setup ftp replication.  there are no errors when i setup that info, and on the tab for where to put the files, i put in folder and there are no problems there.  but when i invoke the agent it says that it can't copy the files.  no other error.  i put port 21??  no clue if that is what i'm suppose to be using or not.

    Author Comment

    the problems i was having was due to permissions and ports not being opened.

    Featured Post

    6 Surprising Benefits of Threat Intelligence

    All sorts of threat intelligence is available on the web. Intelligence you can learn from, and use to anticipate and prepare for future attacks.

    Join & Write a Comment

    In this article we will get to know that how can we recover deleted data if it happens accidently. We really can recover deleted rows if we know the time when data is deleted by using the transaction log.
    The Delta outage: 650 cancelled flights, more than 1200 delayed flights, thousands of frustrated customers, tens of millions of dollars in damages – plus untold reputational damage to one of the world’s most trusted airlines. All due to a catastroph…
    Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…
    This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.

    755 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    22 Experts available now in Live!

    Get 1:1 Help Now