A problem occurred when attempting to contact the server (Server returned: Connection reset).

[suhuynh]

[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.

My environment is CF16 with 2 servers connected through a public facing IP load balancer.  The SQL db is on a cluster. CF admin all datasource is pointed to an IP server. It has been working for quite a long time. Suddlenly last Thursday, we got a network issue. Network issue resolved. We are  kept getting this connection error. I rebooted 2 CF servers, telnet to DB server are ok. DBA stated he did the fell over to other node of the cluster. instead of bouncing the DB server.

Are there anyone encounter this kind error and kindly guide me to solve this issue.

[BKBK]

It is most likely a database problem. Did you recently update the Java on which CF2016 is running? If so, from which version to which version? And did you update the SQL Server JDBC driver to a version that suits the new Java?

[suhuynh · Accepted solution]

Thanks for your time to response. I checked we have the version of Java match with the CF2016 guide. Someone in our network team did some update to the firewall rule and found that update had some bugs. Finally they rolled back and we got no more connections errors.

[BKBK]

Thanks for the information.