Error establishing socket. No buffer space available

[cherylnm]

I have a server problem that I cannot figure out. I found an old thread but no
one ever posted a solution, so thought I would see if anyone has any new info
(older no slution thread
[url]http://www.coldfusionmx.com.br/cfusion/webforums/forum/messageview.cfm?catid=6&t[/url]
hreadid=842682&enterthread=y)

We are running CFMX 6.1 (6,1,0,83762 ) on Windows 2003, Java Version 1.4.2
DB is SQL Server 2000 (several databases all hosted on shared server)

Specific error messages (was 1 initially then last time was 2):
1) [Macromedia][SQLServer JDBC Driver]Error establishing socket. No buffer
space available (maximum connections reached?): JVM_Bind

2) [Macromedia][SQLServer JDBC Driver]Error establishing socket to host and
port: 64.119.38.128:1433. Reason: No buffer space available (maximum
connections reached?): JVM_Bind

When the error happens, it is not serverwide. Some pages are still available
(maybe those that do not run queries? very difficult to check). CF mail stops
sending and just puts everything in the undeliverable folder. Our payment
processing tag reports a "failure in cryptographic library" and will not
process payments. I am able to access the DBs directly through SQL Enterprise
Manager and run queries.

This last time, I tried to just restart CF service by stopping it then
starting it, but the server said it could not restart the service. Restarting
the web server clears all the problems and things operate normally once the
server is rebooted (until the next time it strikes, which is every few days).

I am going to replace all of the RAM thinking that maybe it could somehow be a
hard ware issue, but that is mostly becasue I have run out of ideas. Any other
suggestions?

Thanks for any help :confused;

[ksmith]

This [url]http://software.groupbrowser.com/t226017.html[/url] indicates installing SP4 of ms sql 2000 resolved the issue.

[cherylnm]

Thanks Ken. I had read that one. Was hoping that would be an easy answer, but
checked with our host and the server is already running SP4 and have been:o(
THey said they are applying another new update on Friday night and will be
restarting the server, so perhaps that will help.

Another strange behavior that I determined is that, when the error occurs, it
does not disable all CF pages with database calls. Users are able to complete
our registration (set of about 3 pages), and some of those pages have select
areas that are populated with queries. But, of course, when they get to the
payment page and try to use our payment system, our cfx does not work, so the
only way they can pay is with PayPal. We have PayPal instant notification set
up, but then even that page will not respond/run. Restarting the full web
server fixes it all.

I replaced the RAM last night and also added antoher gig as a friend suggested
that it could be some bad RAM. We shall see. This is so frustrating.