We are getting the below error intermittently in Coldfusion 2016 error handler where REST service is used.
I would like to know if this issue is due to network connectivity or SQL Server connectivity of max connection exceeded issue with ColdFusion REST Service.
Error Occured At : UserValidation REST Service
[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.
I am not a ColdFusion expert. I would like your help to identify the root cause of this issue. Please Help.