Currently my customers running a Windows 2003 server with 2005 SQL and a Active Server.We just put a 20 meg Fiber service into the Office. The issue we are having is it will still take 1-3 mins to load a web page. The DHCP on the router has been placed inactive for a block of IP and the Server has been allowed to do the DHCP for the LAN. Each workstation has been give a Static IP address's using the Default Gateway of the router, and the DNS of the Server.
I am aware that this is the biggest issue, my problem is the Vendor who is in control of the SQL is fighting any and all changes to this set-up.
My proposal was to turn DHCP off of the Server and allow the new Cisco router to have control over the LAN. Then Set Static IP address's on each work station and MAP the drives to the Server, pointing them to the program that is currently being used for there SQL application.
The Vendor has informed me this will not work due to the Active Directory on the Server.
I really need others inputs on a work around as my Customer is very frustrated that she is unable to make use of the 20 meg Fiber Service she is paying for.
Software/Hardware used: Dell Server with Windows 2003 (OS) 2005 SQL, with Active Directory