SQL Server Performance

Sql Server 2005 Timeout Issue

Discussion in 'SQL Server 2005 General DBA Questions' started by travistan, Mar 27, 2008.

  1. travistan New Member

    Hi
    When I try to connect Sql Server 2005 from my PC to server , the error occur
    "Timeout Expired. The timeout period elapsed prior to completino of the operation or the server is not responding. (Microsoft Sql Server)"
    Someout I already enable allow TCP/IP and Name Piped. Any idea on this ?
    Thanks,
  2. ghemant Moderator

    Their could be many reasons for timeout error, can you check what you have configured in your SQL Server for timeout!!
    Also check what is connection timeout option you have define in your connection string, and if you are accesing it from SSMS go to Tools->options->Query Execution->General and change the timeout value to desired
  3. satya Moderator

Share This Page