locked
When I try to connect, I get a pre-login handshake error RRS feed

  • Question

  • I have windows server 2012 in which I have installed a Sql Server 2016 express database. When I try to connect in the LAN of the server, I have no problems, but when I try to connect from outside, through an OpenVpn connection, I get this error, pre-login handshake error, in one of my computers, but in another computer doesn't happen this error.

    So I guess that the problem is not for configuration or connection reasons, because if one computer can connect and the other can't, I guess that the computer that can't connect has any kind of issue. Both computers has windows 10.

    I have notice that if in the server I change the "logon as" user account in the sql server service to local system user, the computer that has problems can connect. However, I would like to avoid this solution because I wouldn't like to use this user account for the service because if one computer can connect, I guess this is not the root problem, although changing the user account can solve the problem.

    I prefer try to know how could be the problem in the computer that can't connect and try to solve.

    Thanks so much.

    Saturday, November 12, 2016 7:47 PM

Answers

All replies

  • Did you try this:

    https://msdn.microsoft.com/en-us/library/aa952081.aspx?f=255&MSPPError=-2147217396

    Look for the handshake section.

    Saturday, November 12, 2016 10:15 PM
  • In addition, here are two more link you should read:

    https://social.technet.microsoft.com/wiki/contents/articles/2102.how-to-troubleshoot-connecting-to-the-sql-server-database-engine.aspx

    https://technet.microsoft.com/en-us/library/cc646023(v=sql.110).aspx

    If after you read the links you still have an issue, then please post the exact full message that you get in the error


    signature   Ronen Ariely
     [Personal Site]    [Blog]    [Facebook]    [Linkedin]

    • Marked as answer by ComptonAlvaro Wednesday, November 16, 2016 9:24 AM
    Sunday, November 13, 2016 7:16 PM
  • I have tried the solutions of the documents but I have not solve my problem yet.

    The messages error are:

    This first one if I use the IP address in this way: x.x.x.x\SqlExpress

    TITLE: Connect to Database Engine
    ------------------------------
    
    Cannot connect to x.x.x.x\SQLExpress.
    
    ------------------------------
    ADDITIONAL INFORMATION:
    
    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=13233; handshake=9240;  (Microsoft SQL Server, Error: -2)
    
    For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft%20SQL%20Server&EvtSrc=MSSQLServer&EvtID=-2&LinkId=20476
    
    ------------------------------
    
    Tiempo de espera de la operación de espera agotado
    
    ------------------------------
    BUTTONS:
    
    OK
    ------------------------------


    This second one if I use the server name, MyServer\SqlExress:

    TITLE: Connect to Server
    ------------------------------
    
    Cannot connect to MyServerName\SQLExpress.
    
    ------------------------------
    ADDITIONAL INFORMATION:
    
    A connection was successfully established with the server, but then an error occurred during the pre-login handshake. (provider: SSL Provider, error: 0 - Tiempo de espera de la operación de espera agotado.) (Microsoft SQL Server, Error: 258)
    
    For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft%20SQL%20Server&EvtSrc=MSSQLServer&EvtID=258&LinkId=20476
    
    ------------------------------
    
    Tiempo de espera de la operación de espera agotado
    
    ------------------------------
    BUTTONS:
    
    OK
    ------------------------------

    Thanks.

    Monday, November 14, 2016 4:07 PM
  • I have tried more tests and I think that is a problem of a connection. The computer that has problems connects thorugh a satellite connection with a 700ms ping and I think that it is so much to stablish the connection.

    However, the same computer that connects through a 3G connection (mobile connection) can connect.

    So I guess the problem is solved.

    Monday, November 14, 2016 4:57 PM
  • I glad to hear the issue was solve :-)

    Thanks for the update +5


    signature   Ronen Ariely
     [Personal Site]    [Blog]    [Facebook]    [Linkedin]

    Wednesday, November 16, 2016 10:48 AM