sql server connect: Hello,
We have been running a web application in Windows Server 2003 and SQL
Server 2000 both located on different machines. It was working fine
until a week ago. There were some security patches that were installed
from Microsoft site. After that we get SQL Server does not exist/Access
denied error on the web page and Windows server 2003 has some error
logs mentioning 'An operation on a socket could not be performed
because the system lacked sufficient buffer space or because a queue
was full.'. We restarted the webserver and things worked fine. It
happened again after a while. We tried rolling back the updates on the
server and that did not fix this either. Can anybody tell us any ways
and means of fixing this or encountered similar problems like this. Iam
going to do a stress test on the application to make sure its not the
application fault. I know that the application does not have any weird
issues.
I will appreciate any comments.
Thanks,
Murali.

There is one article about

http://support.microsoft.com/default.aspx?scid=kb;en-us;328306&Product=sql

Kuido


[quoted text, click to view]


--
Message posted via SQLMonster.com

Please post answer here if you find it...seems that this is a very
common issue, and noone can answer it! ARRRGGGH!

[quoted text, click to view]
fix the problem. NOt sure.

Search no further....

http://support.microsoft.com/default.aspx?scid=kb;en-us;328476

Note, this answer took forever to find so I'm posting everywhere...

This issue was caused in our case due to a number of open SQL
Connections (Connection Pooling). Connection Pool exceeded 5000
connections due to a lot of for and while loops opening series of
connections and not being closed. The garbage collector is not that
efficient as it takes its own sweet time to show up. Unfortunately we
bought the source code from a third party vendor and had to fight and
fix this issue. A good tool to identify if it is a connection issue is
to use a web stress tool.
Thanks for all your help.
Murali.
(Lesson Learnt: Never Buy Third party tools if the application can be
home grown).

Thanks for posting back the info!

-Sue

On Mon, 13 Mar 2006 13:19:31 -0800, Murali
[quoted text, click to view]