locked
Connection time out RRS feed

  • Question

  • Hi Guys

    we have problem which is

    we have system connected to sql server 2008 it some times at 9:30 gives conniction time Out we checked and didn't find

    any jobs run at this time and some days it works perfectly and another days it gives time out error

    any ideas??

    Thanks in advance


    If a post answers your question, please click "Mark As Answer" on that post and "Mark as Helpful".
    • Edited by Osama Salem Wednesday, November 16, 2011 6:32 PM
    Wednesday, November 16, 2011 6:31 PM

Answers

  • Hi Osama Salem,

    >>‘some days it works perfectly and another days it gives time out error’

    The Timeout error message is a general issue, which commonly occurs when an instance of the SQL Server Database Engine is not running, or when there are some network problem or firewall issue.

    Based on your description, seems it might be a network problem or firewall issue. Please refer to the resolution in typical causes of this error and unusual errors sections.  More information, pleases reference this article about TroubleshootingTimeout Expired. Meanwhile please try to check your network traffic volume when connections fail.

    Moreover, SQL Server 2008 contains a new feature; the Connectivity Ring Buffer is designed to help troubleshoot connectivity problems. It can capture a record for each server-initiated connection closure, including each kill of a session or Login Failed event.

    More information, please refer to Connectivity troubleshooting in SQL Server 2008 with the Connectivity Ring Buffer

    Please post the SQL Server error logs and Windows event logs for further troubleshooting.


    Regards, Amber zhang
    • Proposed as answer by amber zhang Thursday, November 24, 2011 1:37 AM
    • Marked as answer by amber zhang Monday, November 28, 2011 2:51 AM
    Friday, November 18, 2011 6:40 AM