Results 1 to 2 of 2
  1. #1
    Join Date
    Nov 2002
    Posts
    32

    Unanswered: Replication to a specific IP

    If we had two SQL 2000 servers each with 2 NIC's. For each server one network card was pointing to an internal network 172.16.x.xxx we use for production. The other NIC (say its 198.16.x.xxx) we wanted to use just for replication purposes between the two servers in an attempt to lighten the network traffic on the 172 network. My question is, can you set up 2 SQL servers to replicate between themselves on a specific IP or Named Pipe?

  2. #2
    Join Date
    Feb 2004
    Location
    earth
    Posts
    96

    Cool Re: Replication to a specific IP

    If both server is in different geographical area or on a WAN, you will face a big threat from anyone in the world who wrote a simple program to guess your user "sa" password or any user account. To post that on a WAN, its preferable to go through a firewall.

    There are 2 options:-
    1) get a 1gigabit network adapter card and a switch that support 1GB.
    2) make use of Client Utility Connection on both SQL server. Configured according to your Server Name with static IP address and specify the port that is use by both server. This will tell the replication agents to call the static ip.


    Originally posted by sdonovan
    If we had two SQL 2000 servers each with 2 NIC's. For each server one network card was pointing to an internal network 172.16.x.xxx we use for production. The other NIC (say its 198.16.x.xxx) we wanted to use just for replication purposes between the two servers in an attempt to lighten the network traffic on the 172 network. My question is, can you set up 2 SQL servers to replicate between themselves on a specific IP or Named Pipe?

Posting Permissions

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