ColdFusion 8: Database Connection Reset Error

Posted by Gavin on Stack Overflow See other posts from Stack Overflow or by Gavin
Published on 2010-05-17T20:51:37Z Indexed on 2010/05/18 10:00 UTC
Read the original article Hit count: 439

Filed under:
|
|
|

I have been getting these intermittent ColdFusion Database connection reset errors and was wondering if anyone had experience with this and had a particular solution that worked?

Here is the error:

Error Executing Database Query.[Macromedia][SQLServer JDBC Driver]A problem occurred when attempting to contact the server (Server returned: Connection reset). Please ensure that the server parameters passed to the driver are correct and that the server is running. Also ensure that the maximum number of connections have not been exceeded for this server.

This doesn't happen with any particular query, the code breaks in different queries every time, returning a SQLState error 08s01. These query's logic are fine, no logic errors etc. I checked the network logs and there were no database server connection refusals at the time of the error. Once the first error occurs, it keeps happening for no more than a minute or so at random times of the day, every few days. I've googled this thing and so far anyone that has had this issue was only on CF6 or 7, which the fixes coldFusion put out are only for CF6 or 7.

Server configuration wise:

  • The ColdFusion server is version 8
  • The database server is SQL Server 2005 Standard
  • The database connections allowed setting is set to unlimited on both SQL Server and ColdFusion

Any help would be greatly appreciated, Thanks!

© Stack Overflow or respective owner

Related posts about coldfusion

Related posts about sql-server-2005