Here is what I have....
A web server running Windows Server 2003 that I want to put in the DMZ with a Public IP address
A Mircrosoft SQL 2005 Server that is on the LAN with a private addres (10.0.0.x)
A web application on the webserver that accesses and stores data on the SQL server.
I would really like to have my webserver in the DMZ, which is easy to do. The only problem that I run into is that I need the web server to be able to communicate with the SQL server which it can't do by default in the DMZ. There are 2 ports that I know I need to open to the SQL server, but how will my webserver be able to even find the SQL server and will I have to add any special routes to the SonicWall?
Also, do I need to open any ports to allow for DNS or do I need to change the host file on the webserver to allow it to communicate with SQL by name and not just IP address?