troubleshooting Question

multihomed 2008 Web server with internal database

Avatar of DevMikeDallas
DevMikeDallas asked on
Microsoft SQL ServerWeb ServersNetwork Architecture
5 Comments1 Solution466 ViewsLast Modified:
I have a development web server multihomed with two gateways:
            ISP
            |
            ISP Modem
            IP x.x.x.0
            GW x.x.x.1
            |
Router A ------------------------------------Router B
IP x.x.x.2                  IP x.x.x.3
GW x.x.x.1                  GW x.x.x.1
NAT 192.168.1.1            NAT 192.168.65.1
|      |            |            
|      SERVER2 NIC2      NIC1
|      IP 192.168.1.101      IP 192.168.65.100
|      GW 192.168.1.1      GW 192.168.65.1
|      |            |
|      --------------------------------SERVER2
|                  Website2
|
SERVER1 NIC1
IP 192.168.1.136
GW 192.168.1.1
|
SERVER1
Website1/SQL/DC

What I am trying to sort out is the correct way to configure firewall and security in order to allow access to the SQL server instance on Server1 from the website2 on Server2.

Right now, my connections to the database from server2 do not work. I have enabled ports 1443, 1444 for only NIC2 and it still does not work.

Any ideas on a better database setup are appreciated. I will be putting a new DC in the place of Server1 so it can just be the SQL server. Website1 will be moved to Server2. My idea is to place the sql server on a third subnet with restricted access to IP addresses on the two subnets so that internal applications can access the database as well as the websites.
ASKER CERTIFIED SOLUTION
Hex255

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 1 Answer and 5 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 5 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros