HowTo: Force the use of a certain IP address for Server-to_Server communication

From: Mike (MichaelLopez_at_inds.com)
Date: 07/20/04 

Date: Tue, 20 Jul 2004 11:31:52 -0400

Hello.

We have two SQL Server 2000 (SP3a) servers, running replication.

Each machine has two network cards.

Up to just now only the first card in each machine was being used
(192.168.1.*), which put. each machine on our entire internal network.
Therefore communication betweeen these two servers was accomplished by going
out to the network, through the hubs, patch panels, etc.

To speed up the transfer of replicated data I asked the network guys to set
up the second card in each machine to be on their own network (192.168.6.*)
, and plug a cable from one machine directly into the other via these second
cards.This way a direct connection between these two servers exist.

I changed the "hosts" files on both servers and added the IP/Name pair of
the other server in each, hoping that this will force the issue of each
machine seeing the other over this new, "private" network.

I don't know of any place (nor can I find any place) in Enterprise Manager
that I can specify an IP address, therefore I think this is all that I need
to do. Perhaps I need to reboot the servers in order to "free" the IP
addresses currently in use (?).

Any suggestions?

Thanks in advance,

Mike

Relevant Pages

  • Re: Dcidag errors
    ... Port blockage between servers ... Other sorts of networking issues (lack of connectivity between the points ... These errors are typically a result of a network connectivity issue of some ... > replicating this nc. ...
    (microsoft.public.windows.server.active_directory)
  • Re: Two networking cards
    ... Ray ... > subnet to the servers in the .44 subnet and visa versa. ... > It may be the dual port network card is routing packets, ... so for the local network. ...
    (microsoft.public.windows.server.networking)
  • Re: I need Job Blobb
    ... > Windows and Network administratation. ... > In a job I would like to administrate servers, ... > Title: ISP Network Administrator ... > o Building, installation, configuration and tuning ...
    (microsoft.public.cert.exam.mcse)
  • Re: I need Job Blobb
    ... > Windows and Network administratation. ... > In a job I would like to administrate servers, ... > Title: ISP Network Administrator ... > o Building, installation, configuration and tuning ...
    (microsoft.public.cert.exam.mcse)
  • 2 nics DMZ
    ... Netowork card #2 is hooked onto my DMZ 192.X with netowork load balancing. ... Since I can only have 1 gateway I used the network card #2 to ... static routes for the internal network #1. ... I have this configuration on 2 other web servers and they run fine with no ...
    (microsoft.public.windows.server.networking)
Loading