I have a SQL Server 2000 running on Windows 2003 Server that is giving me intermittent connection failures.
The user connections are getting closed on waiting but mature connections. Meaning when users are connected to an application that is running on this server, the programs start up fine. The problem usually shows up after the connection has been sitting for a bit. I'm wondering if there is some odd setting that is killing older, not active connections?
What could be causing this? What can I check to further troubleshoot this.
Is it possible that my problems are caused by running SQL Server 2000 personal edition, where the old server that died and was replaced was on Standard? I have no way to verify the old version, but is this possible?
EDIT: Well I upgraded the edition to SQL 2000 Standard, and there is nothing different in the behavior of the server. So that wasn't it.