Re: Joining 192.168.1.* to 192.168.1.* with filtering for only MS SQL Server?



David wrote:

Hi all,

We have two networks:

a) 192.168.1.*

b) 192.168.2.*

We want to bridge them

I think you mean you want to *route* traffic.
Bridging is really quite different.

so that Microsoft SQL Server via TCP-IP can go
from a computer on a) to one on b). Ive been looking at etables and
iptables, and am not sure what would fullfill the purpose best.

iptables is easiest when using routing.

Has anyone done this, or have any suggestons. We dont want windows file
sharing, named pipes, DNS, DHCP to transerse between the bridges.

Then you definitely don't want bridging, as that connects the networks
completely.
You want selective routing, i.e. routing in combination with firewalling.

Can this be done, do we need to bring them into the same 192.168.* range,
for it to work?

Of course not - if you do that, you can neither route nor stop any traffic.
Or rather, you can stop traffic, and selectively bridge the networks, but it
will be more work to set up properly, and can have lots of unforeseen
consequences.

Each network is connected via a seperate network card to the gentoo linux
box, ideally via these it would be good to ssh into it.
If not I guess this can be done with a spare network card?

No need, as long as you can reach the Gentoo box from either of the two
connected networks.
Are the networks now connected and routed across the Gentoo box ?
If they are, your question is simply: how do I allow MS SQL traffic through,
but not anything else ?

If not, then you'd better stop and think about what kind of traffic you want
to route.
Which depends heavily on what other services you need to provide across the
router, and what kind you wish to prohibit.

A short rationale for why your network is set up the way it is would be a
really good place to start - do a little design work now, save yourself a
whole lot of worry later.

--
All your bits are belong to us.
.



Relevant Pages

  • Re: Bridging network interfaces on Windows 2000 Prof.
    ... > The main reason why i need bridging is that i want to join two remote ... > networks that are numbered in the very same way. ... Normally it has 3 subnets because there is one subnet to ... to run as a "bridge". ...
    (microsoft.public.win2000.networking)
  • Re: Bridging network interfaces on Windows 2000 Prof.
    ... > The main reason why i need bridging is that i want to join two remote ... > networks that are numbered in the very same way. ... Normally it has 3 subnets because there is one subnet to ... to run as a "bridge". ...
    (microsoft.public.win2000.networking)
  • Re: What does "bridge" mean?
    ... In this case the "bridge" your friend is referring to is not a wireless ... It sounds like he has a VPN or Tunnel set up between the ... This allows the two separate networks to act as though they ... Both end points can have the same subnet, ...
    (microsoft.public.win2000.networking)
  • Re: PPPoE and WiFi Router problem
    ... I will try removing the Bridge and un-installing the IPv6 tonight. ... >>under both the File and Printer Sharing and Client for Microsoft Networks, ...
    (microsoft.public.windowsxp.network_web)
  • Re: Networking with FreeBSD
    ... bridge or as a layer-3 IP router/firewall, unless and until you tell it to do so. ... firewall traffic both by subnet and by individual IPs. ... going through the firewall to reach your private internal networks. ...
    (freebsd-questions)