How can I resolve this issue  “Timeout expired. The timeout period elapsed prior to completion of the operating or the server is not responding (Microsoft SQL server)?”

Posted on 2011-05-03
Last Modified: 2012-06-21
How can I resolve this issue “Timeout expired. The timeout period elapsed prior to completion of the operating or the server is not responding (Microsoft SQL server)?” (See the screenshot).

A user has Microsoft SQL server 2005 Server Configuration Manager and is trying to run a SQL query using Windows authentication.

He always receives this error message and is not able to query the SQL server (MSSQL).

I have noticed that the screen where the user enters his domain name\username does not allow him to enter his Window password.

The user’s OS is Windows 7 64 bit.

The SQL server is installed on Windows Server 2003 R2 64 bit.

Could this issue be caused by a DNS or other name resolution problem on the internal Server 2003 R2 Active Directory network?

What needs to be done to fix this issue so that the user can logon to and query the SQL database?
Question by:Knowledgeable
    LVL 59

    Accepted Solution


    Firstly, if you are using Windows Authentication, it is a digest and so you cannot enter a password.  It uses what the user is currently logged in as and that user must have proper permissions within SQL.

    Secondly, SQL Server Configuration Manager is not used for querying.  The user must use SQL Management Studio (SSMS).  In order for the user to do so remotely, though, you must use the Configuration Manager to enable remote connections.  Ensure that you have done so and that the domain user has been granted proper permissions to the instance to which s/he is connecting.

    On that note, ensure that the user is typing in the correct SERVERNAME\INSTANCENAME combination in the connection window.

    If it is a DNS problem, you can try by IP address.

    Hope that helps or at least gets you started.

    LVL 29

    Assisted Solution

    by:Paul Jackson
    increase the remote login timeout :
    LVL 21

    Assisted Solution

    by:Alpesh Patel
    Please make sure port is open and server is not loaded with processes.

    Author Comment

    How can I "make sure port is open and server is not loaded with processes?"
    LVL 59

    Assisted Solution

    by:Kevin Cross
    @Knowledgeable, it is same as what you would do for my suggestion: http:#a35518016
    Under SQL Server Configuration Manager on the SQL server, you have to enable remote connections and define acceptable protocols.  When TCP/IP is enabled, you can configure it to a specific port.  Default is 1433.

    While on the box, you can check the health of the server.  

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Enabling OSINT in Activity Based Intelligence

    Activity based intelligence (ABI) requires access to all available sources of data. Recorded Future allows analysts to observe structured data on the open, deep, and dark web.

    Suggested Solutions

    'Between' is such a common word we rarely think about it but in SQL it has a very specific definition we should be aware of. While most database vendors will have their own unique phrases to describe it (see references at end) the concept in common …
    In this article we will get to know that how can we recover deleted data if it happens accidently. We really can recover deleted rows if we know the time when data is deleted by using the transaction log.
    To add imagery to an HTML email signature, you have two options available to you. You can either add a logo/image by embedding it directly into the signature or hosting it externally and linking to it. The vast majority of email clients display l…
    Migrating to Microsoft Office 365 is becoming increasingly popular for organizations both large and small. If you have made the leap to Microsoft’s cloud platform, you know that you will need to create a corporate email signature for your Office 365…

    779 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

    16 Experts available now in Live!

    Get 1:1 Help Now