External Web Server can't connect to Internal SQL Database...Please Help!

[cdburnerrrrr]

I have a hosted web server that has a website on it that needs to connect back to a database within our internal network.

We have a Cisco WRVS4400N Wireless Router with 2 VLANS. VLAN 1 goes to a Watchguard Firebox which is connected to our internal network. VLAN 2 goues to our classroom network.

Our database is on VLAN 1. I have opened port 1433 on the Watchguard to allow SQL traffic from our Web Server.

I can telnet from my workstation on VLAN 1 to the Web Server over port 1433, so I know the Web Server is not blocking anything.

When I try to telnet from the Web Server to our Public IP address over port 1433, it fails.

I believe I have the firewall on the Cisco WRVS4400N off, so it shouldn't be blocking any traffic, but for the life of me I can't get this to work.

I have been working on this for two days, and I NEED it to work.

This was working up until last week, then it quit working. I am the only person making changes to our network, and there were no changes made during that time.

Any help would be greatly appreciated.

Thanks,

Mark

[sbreuercc]

Hi,

you look from the wrong side to the traffic flow.

correct would be:

webserver -> router -> Firewall -> SQL Server listens on port 1433

So you have to permit tcp/1433 for incoming connections from the webserver to the sql box.

connections from an internal  client to tcp port 1433 on the websrv. will never occur.