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, 2013 at 16:05
  • @mrdenny -Please see edit.
    – MAW74656
    Jun 10, 2013 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, 2013 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, 2013 at 13:50
  • @Kin -I know that, but I have to get this working now, upgrade will have to wait.
    – MAW74656
    Jun 13, 2013 at 15:47

1 Answer 1

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, 2013 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, 2013 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.