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

    How to fixe this Issue in Sql Server- connection timeout expired.

    Hi

    I have Installed Sql Server 2014 Successfully. But I am facing following error. But
    I am following this url

    But i canot Fixed this any one guide me.

    This is Error
    ========

    Connection Timeout Expired. The timeout period elapsed while attempting to consume the pre-login handshake acknowledgement. This could be because the pre-login handshake failed or the server was unable to respond back in time. The duration spent while attempting to connect to this server was - [Pre-Login] initialization=18106; handshake=14314;
    (Microsoft SQL Server, Error: -2)
  • #767312
    Hi,
    Enable the firewall settings on server. Make sure TCP port 1433 is open.
    Enable both Named Pipes and TCP/IP(IPv4 and IPv6) on the SQL Server Configuration Manager as follows:
    StartMenu-> AllProgram-> Microsoft Sql Server 2014-> Sql Server 2014 Configuration Manager-> Sql native Client 11.0 Configuration-> Client Protocols

  • #767314
    Are you trying to login using query analyser?
    Did you installed Express edition? or other editions?

    1. Check the authentication mode
    Open up SQL Server Management Studio and connect to your database server.
    Right Click The Database Server and click Properties.
    Set the Server Authentication to SQL Server and Windows Authentication Mode.
    2. Turn off firewall and check
    3. If it is express edition. Enable both Named Pipes and TCP/IP(IPv4 and IPv6)

    By Nathan
    Direction is important than speed


Sign In to post your comments