2 NICs on webserver 1 external and one interneal - Access to SQL database from PCs on internal to this server is slow and often times out
Posted on 2007-10-16
We have an internal network for LAN applications & an external network for our webserver (which hosts a few simple websites & our web based helpdesk system with an SQL back end)
The internal network connects to the internet via a Sonicwall firewall connected to a router
The external network connects to the internet via a Watchgourd firewall connected to the same router.
All networking on both network are fine, except we recently needed to acess the SQL helpdesk database from the internal network as we have a Windows interface which is faster for us, compared to the web interface.
To acheive this we put a 2nd nIc in the SQL Web server on the external network and gave the 2nd nic IP/SM entries for the internal network - thus this server has a link to the internal network
I did not specify a gateway or DNS on this 2nd nic.
From the internal network I can now map to the drives on this server and ping it with no errors.
I also setup and ODBC link to the web server with the SQL database so my helpdsk windows application works.
However, performance with the helpdesk is sometimes ok, other times sluggish and sometime we get errors that relates to a loss of connection to the SQL database. Each time this happens mapped drives are ok and pings are fine.
If I use the windows application on a laptop connected on the external network directly I get no issues, so it points to a network problem.
Any ideas and have we setup the dual card correctly on the web server.
By the way the 2nd nic is new and we have tested it since in case that was faulty.
No errors in the server event logs but there are errors in the PC log when this issue occurs - it specifies timeout errors.
Any help is appreciated.