This started happening two days ago -

Posted on 2011-04-27
Last Modified: 2013-12-24
Diagnostics: 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.
The error occurred on line 297.

Web Server - Windows Server 2003
Running Cold Fusion

Sql Server - Windows Server 2003   Sql Server 2000

On LAN Gig NICS through Gig Switch
Question by:Jeff_Kingston
    LVL 6

    Expert Comment

    I have seen this many times.
    It is probably easiest to restart the ColdFusion service.
    That usually solves the issue.
    LVL 23

    Expert Comment

    hi, have u got this error solved? does any changes made to the Windows 2003 server on that day? apparently there are similar cases reported and it happen after SP2 is installed to the server. there are three possible ways of correcting the problem:

    1- in the Data Source setting, choose Advanced Setting. un-checking the option "Maintain connections across client requests". this option should make ColdFusion reestablish the connection of each query
    2- go to the properties of the GigNIC adapter and turn off TCP Offload
    3- uninstall SP2

    Author Comment

    OP Zaharin,

    Option 1, I'll have to discuss with contractor for web site

    Option 2, there are three(3) settings for TCP offload.  Should all three be set to OFF
                   Received TCP checksum
                   TCP Segmentation
                   Transmit TCP Checksum?

    I have to resize the partition before SP2 can be installed so option 3 is irrelevant.
    LVL 23

    Accepted Solution

    - if you did not install SP2 then option 2 is also irrelevant. this leave you with only option 1 from my suggestion.

    Author Comment

    Ok Thanks

    Author Closing Comment

    Turned out to be a bad cisco 2950

    Featured Post

    Threat Intelligence Starter Resources

    Integrating threat intelligence can be challenging, and not all companies are ready. These resources can help you build awareness and prepare for defense.

    Join & Write a Comment

    Everyone has problem when going to load data into Data warehouse (EDW). They all need to confirm that data quality is good but they don't no how to proceed. Microsoft has provided new task within SSIS 2008 called "Data Profiler Task". It solve th…
    The Delta outage: 650 cancelled flights, more than 1200 delayed flights, thousands of frustrated customers, tens of millions of dollars in damages – plus untold reputational damage to one of the world’s most trusted airlines. All due to a catastroph…
    Via a live example, show how to extract insert data into a SQL Server database table using the Import/Export option and Bulk Insert.
    Using examples as well as descriptions, and references to Books Online, show the documentation available for datatypes, explain the available data types and show how data can be passed into and out of variables.

    730 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    17 Experts available now in Live!

    Get 1:1 Help Now