SQL 2000 SP4 on Server 2003 SP1 not dropping connections

From: "Brad Martin" <brad@xxxxxxxxxxxxx>
Date: Tue, 26 Dec 2006 18:24:00 -0700

We recently upgraded our SQL 2000 SP3 instance (running on Windows 2000) to SQL 2000 SP4 running on Windows Server 2003 SP1. The migration went fine but we are now experiencing a problem where connections are not dropping once the application is finished with it. The application is a COM+ app making an ODBC connection, which then never closes. We are running a job that cleans up the connections, but we can't seem to find the reason why SQL is keeping the connections open in the first place. Any ideas or suggestions?

Brad

.

Follow-Ups:
- Re: SQL 2000 SP4 on Server 2003 SP1 not dropping connections
  - From: Andrew J. Kelly

Prev by Date: Re: clustered index table updates question - please help
Next by Date: RE: Server: Msg 7391 unable to begin a distributed transaction
Previous by thread: Connection and /share file and printer/ option in Windows firewall
Next by thread: Re: SQL 2000 SP4 on Server 2003 SP1 not dropping connections
Index(es):
- Date
- Thread

Relevant Pages

Bizarre TIME_WAIT socket buildup problem
... I am experiencing a rather worrying ... connections to some ports (namely, ... a few hours ago I changed it to 5000 to no avail - all new connections ...
(freebsd-questions)
Re: IPTables Problem: I think I figured it out... [was IPTables Established connection Problem]
... >> So my server was dropping those connections. ... > Out of interest, and a slightly voodoo suggestion, does dropping your MTU ... I'm sure conntrack is not the problem here. ... If it is a very high traffic link you may want to add a filter to only ...
(comp.os.linux.security)
Re: [patch] voluntary-preempt-2.6.9-rc2-mm3-S5
... >>dropping new connections and doesn't have any adverse affects that ... S4 patch and it had the same change in it, but did not exhibit the same ... looking for obvious changes that might affect dropping tcp connections ...
(Linux-Kernel)
Re: [patch] voluntary-preempt-2.6.9-rc2-mm3-S5
... > only noticeable symptom is dropping ~30 percent of new telnet ... > I had no dropped connections with S4 even when loaded. ... dropping new connections and doesn't have any adverse affects that I've ... send the line "unsubscribe linux-kernel" in ...
(Linux-Kernel)
IPTables Problem: I think I figured it out... [was IPTables Established connection Problem]
... NICs which didn't help. ... I then turned on Logging on just about every line. ... So my server was dropping those connections. ...
(comp.os.linux.security)