Re: 2 differnet domains, 1 SQL server under 1 firewall and DSL connection...help

From: Jeff Cochran (jeff.nospam_at_zina.com)
Date: 09/18/04


Date: Sat, 18 Sep 2004 14:44:08 GMT

On 16 Sep 2004 11:16:22 -0700, contactgc@hotmail.com (Garett) wrote:

>Hope I get this off as clear as possible:
>
>* Moving 1 company( A COMPANY) network(25 users, 1 win2k server) to
>location where B company is(15 users). At LOCATION B, both A and B
>have separate win2k servers w/differnet IP addresses, diff subnets,
>different domains. At location B, there is 1 firewall out to the net
>via DSL.
>Also, there is a SQL server w/ accounting data on it where BOTH
>companies have to pull from.
>
>GOAL:
>
>To have each company under their own SERVER(and domain) and IP, both
>go out through the 1 firewall, and have both companies(domains) attach
>and pull data from the single SQL accounting server(which can be a
>memeber of either domain), and they are both in the same server room
>location using the same firewall and switch.
>
>What do I need to do to make both domains work under 1 firewall?

Either firewall that can accept multiple LAN addresses, or a router
between the two domain networks and the firewall.

>HOw can I allow both domains to attach to the SQL server and grab data
>off it?

Use SQL Authorization and you're out of any domain login issues, or if
you use Windows authentication you'll need to set up trusts.

By the way, there's no reason that two separate logical networks can't
use the same physical network. All your systems can be on the same
cabling and switches and still separated.

You can also drop everything into the same logical network, easing
your routing to the internet, and use domain security to separate
them.

Jeff



Relevant Pages

  • Exchange2000,symantec OR ISA advice
    ... Behind the firewall you have a choice. ... deploy an ISA. ... In any case your smtp server that does content and virus ... separate server. ...
    (microsoft.public.exchange.admin)
  • Re: Securing Fedora Core 4
    ... > firewall, gateway, file & print. ... The public web server should definitely be a separate box, ... firewall rules or access lists which distinguish between "internal" ...
    (Focus-Linux)
  • Re: Error number: 0x8024402C on Win 2K Server
    ... Not knowing you setup...does each server have its own separate ... firewall or do they all go to just one firewall. ... then compare your fifth server firewall settings to the others. ... >I receive error 0x8024402C on Windows 2000 Server doing Windows Updade. ...
    (microsoft.public.windowsupdate)
  • Re: CEICW fails at firewall config
    ... Do you or do you not have ISA 2000 or ISA 2004 installed on the SBS server? ... Do you have 2 NICs in the SBS? ... CEICW fails on firewall configuration every time. ... >>> Call to Creating the protected networks access rule returned ok. ...
    (microsoft.public.windows.server.sbs)
  • Re: Recycler security issues on IIS server
    ... > latest upates to the server. ... > like to see the server put behind our firewall, ... other software, install all patches, IISlockdown, URLscan, use the correct ... the procedures you follow may vary depending on your security needs. ...
    (microsoft.public.inetserver.iis.security)