Skip to main content
D
DBA_Grp
Participant
September 14, 2012
Question

Cold fusion

  • September 14, 2012
  • 1 reply
  • 1263 views

can any one give me a clear view or idea why this occurs & how can we fix this  ?

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. <br>The error occurred on line 37.

This topic has been closed for replies.

1 reply

D
Community Expert
Dave WattsCommunity Expert
Community Expert
September 14, 2012

This could happen for many reasons. You might try limiting the number of allowed connections in your CF datasource settings to start - try setting it to something like 20 and see if the problem goes away.

Dave Watts, CTO, Fig Leaf Software

http://www.figleaf.com/

http://training.figleaf.com/

Dave Watts, Eidolon LLC
Charlie Arehart
Community Expert
Charlie ArehartCommunity Expert
Community Expert
September 15, 2012

Yep, and perhaps do other things to test the connection from the CF server to the DB server. For instance, do you have any client for the DB, running on the server (such as MySQL workbench or SQL Server Management Studio)? Can you connect on them? And if you don’t have them on the CF server, how about at least from some other server? You want to make sure the problem is not really specific to CF first.

Some other questions:

- is the DB server on the same machine or another?

- do any other DSNs work that are pointing to the same DB?

Finally, look in the CF logs to see if perhaps there is more detail than you see shown in your note.

/charlie

/Charlie (troubleshooter, carehart. org)
D
DBA_GrpAuthor
Participant
September 17, 2012

TO make it more clear of the situation-

2 different Server for each set up below.

we have ColdFusion 9 in app server box

Sql server 2005 sp2 in DBS.

This below error occurs like weekly once and automatically get fixed after a few min around max 10 min .

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. <br>The error occurred on line 37.

The strange thing is that we do have trace open in that point of time & as well as we do check each and every sql logs and event logs but found nothing Strange in it.

I Guess this is nothing to do with Sql server DBS as i Guess it is with the thread of Cold fusion or some thing in the CF Server which create the issue or this is a bug on CF 9.

Terms & ConditionsAccessibility statement
Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices