We are having a problem with MS Windows Server 2000 and SQL Server 2000. I will give a brief description, and see whether someone can shed some light on it.
For some reason our Win 2000 Web server tries to connect to MS SQL 2000 database server but the Timeout Expired error occurs. It tends to be when SQL Server 2000 is using more than 1 GB of memory. Stopping and restarting the SQL Server and SQL Server Agent Services fixes the problem.
Some of you may say, it must be a memory issue, but we've recently upgraded the PC from 512 MB to 2.5 GB ram. Has anyone come across this problem and found a fix, we've checked MSDN and just about everywhere else and I figured I would ask here as most of you are familiar or experts in this environment.
Some people have recommended upgrading to Win Server 2003 with high spec machine and 4 GB, but that is not an option at the moment.
Server Specs are:
Mirrored 50 GIG SCSI HD's
Windows 2000 Server SP4
Thanks in advance