Error Executing Database Query.[Macromedia][SQLServer JDBC Driver]A problem occurred when attempting to contact the server (Server returned: Software caused connection abort: recv failed). 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. The specific sequence of files included or processed is: D:\Apps\sitemap.cfm, line: 31
We are getting the above error in coldfusion. Can anyone please help us in fixing the above issue?
The environment used are as follows:
SQL Server 2005.
Wow this very thing happen to me today at a site. CFAdmin datasource verify OK however could not CFQUERY db. SQL db could not be turned offline. I restarted SQL Server and everything worked again. Kicking myself a bit - I should have checked thru SQL query what was locking.