Post reply

Cross Domain Replication

  • September 17, 2007 at 12:05 pm

    #174806

    Hi,

     

    I am currently in the process of configuring a cross domain pull subscription. I have replication working at the moment using a publisher, a dedicated distributor and subscribers using pull subscriptions. I now need to add a subscriber (using pull subscrition again) who sits outside of my domain and would like to read some articles\get advice on the best way of doing this.

     

    Thanks

     

  • September 18, 2007 at 8:32 am

    #734318

    We've also currently been stopped at this step in our cross domain replication.

    Here is what i'm following as a guide:

    http://technet.microsoft.com/en-us/library/ms345214.aspx

    I am completely stumped as to how I create the subscription, since I need to connect to a server over the www.

    We set up a secure website and a merge publication to use web synchronization, but I have no idea how to connect to this server over the web.

    address of server is:

    https://servername.com/website/MyReplication/

    This is the location of the SQL Server Internet Server API (ISAPI) DLL.

    When I try to create a subscription on my local network to connect to this remote publication, it asks to connect to SERVER NAME, login, password (typical server connection info) -- but i'm completely baffled as to what the server name needs to be (format-wise)

    is it just https://servername ??

    How do I tell it to connect to a remote server, and even better, how can I make sure it is using the IIS configured publication we set up?

    Sorry to hijack, but hopefully this will encourage some discussion that will help us both

    Thanks in advance,

    Mike

     

  • September 18, 2007 at 8:42 am

    #734320

    You will need to be able to resolve the server name in order to connect via management studio, I used host entries to achieve this. Can you ping the destinatation server IP?

     The format should then be Servername\Instance.

  • September 18, 2007 at 8:52 am

    #734329

    Ah why didn't I think of this?!

    So you just added a host called "MyHost" in the hosts file?

    MyHost https://servername.com/ReplicationFolder

    Like so? Everything on the msft site leads to needing an SSL certificate to accomplish web synchronization. Are you attempting to bypass this using the hosts file? I'm not sure if this will work but i'm willing to try

    I tried the above and i'm still getting a connection error. I can connect to my website and view a test page using the same address, but i'm not able to connect my subscription through Mgmt Studio...

    Are there any specific network configuration requirements to allow remote connections? I have all the network protocols enabled.

    Thanks again!

     

    edit:

    I CAN'T ping this machine over the http://www... i'm guessing I need to open the SQL ports to allow www access? we purposely made this a bit stiffer, security wise, as we did not want an internet facing box leaving common sql ports open. I will have to get the network admin to open ports on the firewall if this is the case. I believe we currently only allow traffic over 443 and RDP. RDP will be disabled once this configuration is working.

  • September 18, 2007 at 9:03 am

    #734333

    This article will probably be of more use to you http://msdn2.microsoft.com/en-us/library/ms151255.aspx

    My setup does not involve replication via the web so am not 100% sure of the config, sorry. I am replicating to another server outside of my domain. For anyone else attempting to do this I found this article helpful

    http://jstawski.com/archive/2007/03/06/pull-merge-replication-security-with-sql-server-2005.aspx

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

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