1

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.

EDIT:

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.

9
  • Can you explain "The user connections are getting closed on waiting but mature connections" in more detail? – mrdenny Jun 10 '13 at 16:05
  • @mrdenny -Please see edit. – MAW74656 Jun 10 '13 at 22:02
  • 1
    There's nothing in SQL Server that just randomly starts killing idle connections. I've left connections open for days without issue doing nothing. Either there's a network glitch or there's a problem with the client application closing the connection when it isn't expecting it to be closed. – mrdenny Jun 10 '13 at 22:22
  • @MAW74656 SQL Server 2000 is out of support. Better to upgrade to new version 2008R2 or 2012 along with Windows OS as well. – Kin Shah Jun 11 '13 at 13:50
  • @Kin -I know that, but I have to get this working now, upgrade will have to wait. – MAW74656 Jun 13 '13 at 15:47
1

“I'm wondering if there is some odd setting that is killing older, not active connections?” – short answer is no.

This is probably network issue, or SQL Server being under big performance impact or DNS or something similar.

Is your application on the same machine as SQL Server ? Do you have any other issues? Can you run SQL Server from Enterprise manager w/o issues?

2
  • No, the application is a windows client Access application on our production floor. – MAW74656 Jun 13 '13 at 15:47
  • If SQL Server is under performance impacct, it could start rejecting transactions? What performance counters should I be watching to determine if this is the issue? – MAW74656 Jun 13 '13 at 18:45

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.