You must Sign In to post a response.
  • Category: SQL Server

    Timeout Expired error while opening SQL

    Hi,

    I am getting an error very often when i try to open SQL Server from hosting server. After entering the Username and password i get an error" cannot connect to server", Addl Information - Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding. (Microsoft SQL Server).

    Please give an idea how to overcome this issue.

    Thanks in advance.
    Shyam
  • #758089
    There are many reason behind timeout expired error, so of them are listed below
    The "Timeout expired" error commonly occurs when an instance of the SQL Server Database Engine is not running, when the server name was typed incorrectly, or when there are network problems or firewalls.
    if you have exact error then please share with us, there are many different error and possibilities are listed in below link
    https://technet.microsoft.com/en-us/library/ms190181(v=sql.105).aspx
    hope it helps

    Thanks
    Koolprasd2003
    Editor, DotNetSpider MVM
    Microsoft MVP 2014 [ASP.NET/IIS]

  • #758099
    Hello Shyam,

    There are many reason behind timeout expired error.
    The Timeout expired error commonly occurs when an instance of the SQL Server Database Engine is not running, when the server name was typed incorrectly, or when there are network problems.

    This timeout setting value is configurable through the DWORD value SQLQueryTimeout at HKEY_CURRENT_USER\Software\Microsoft\Microsoft SQL Server\90\Tools\Shell\DataProject.

    Regards,
    Nirav Lalan
    DNS Gold Member
    "Failure is the path of least persistence"

  • #758119
    Hi,

    Kinldy go through the below mentioned Links. It may help u..

    1.http://blogs.msdn.com/b/ialonso/archive/2007/12/04/sql-execution-error-timeout-expired-the-timeout-period-elapsed-while-opening-view-from-ssms.aspx

    2.http://stackoverflow.com/questions/8886753/sql-server-still-getting-the-error-of-timeout-expired-the-timeout-period-elaps

    3.http://stackoverflow.com/questions/11242288/timeout-on-open-view-in-sql-server-management-studio

  • #758237
    Hi Shyam,

    This is most commonly faced by most of us in the beginning, all you have to do is check is the server name you enter is correct , username and password combinations are correct and please make sure the server you are trying to connect is active and its UP.

    Regards,
    J.Sunil Jas
    www.thisisdotnet.blogspot.com


  • Sign In to post your comments