Search

Monday, July 22, 2013

A connection was successfully established with the server, but then an error occurred during the pre-login handshake.

Today when I was connecting my SQL server from some client system, connection established successfully with the server. However, then an error occurred during the pre-login handshake. Following is the detailed error i am receiving. 

(provider: SSL Provider, error: 0 - The wait operation timed out.)
A connection was successfully established with the server, but then an error occurred during the pre-login handshake.


Then I check that TCP/IP protocol is not enabled for clients. Without TCP/IP protocol you can not access the sql server from other clients. Following is the method to enable the protocol.

Go to the Start-->Programs-->SQL Server--> Configuration Tools-->SQL Configuration Manager.

Expand the SQL Network Configuration and click on the PROTOCOLS node

Right click on TCP/IP and open up the PROPERTIES panel

Select the IP ADDRESS tab

Make sure the values for the IP ADDRESS fields are correct and match the system it is running on. If its not the same then provide the valid ip through which you want to access sql server from client machine.

Restart the service, and I I can connect to SQL Server from client.

19 comments:

  1. i did all what you suggested above, but the issue is still persisting.

    ReplyDelete
  2. I have same problem, but my sql server is working fine, at any moment just stop working with LAN connections and same error is displaying. I can solve this restarting the sql service , but want to know how to prevent this error. Because im having this situation on production servers.

    ReplyDelete
    Replies
    1. Please check below link for solution:
      https://msdn.microsoft.com/en-us/library/aa952081.aspx

      Delete
  3. Make sure you have TLS 1.0 enabled as SQL server requires that SSL version to connect. If you want to connect using the latest TLS 1.2 protocol, you may need to install an update from Microsoft and then disable TLS 1.0 as per your choice. Here's the step by step instructions of doing this:
    https://www.itechtics.com/connection-successfully-established-error-occured-pre-login-handshake/

    ReplyDelete
  4. Connection is blocked by Firewall , Allow from Firewall

    ReplyDelete