Results 1 to 2 of 2
  1. #1
    Join Date
    Sep 2007
    Posts
    12

    Unanswered: Replication over Internet

    Database = sql 2005 enterprise edition
    i have 2 database server connected to internet how can i replicate data between them over internet.

    i know how to replicate over local network
    i just wana know how will it work over internet
    would i need static ip
    or any thing else

    thanks

  2. #2
    Join Date
    Jan 2003
    Location
    Massachusetts
    Posts
    5,800
    Provided Answers: 11
    Ideally, these machines are not really exposed to the internet, but are restricted to talking to one another by VPN tunnels, or firewall rules.

    If the two machines are in different domains, you would need to set up SQL Authenticated user(s) to handle the distribution job. depending on whether this is a push or a pull subscription, will determine where the user needs to be created.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •