Friday, December 26, 2014

The timeout period elapsed while attempting to consume the pre-login handshake acknowledgement.

You might get the following error when trying to connect to an newly installed SQL Server 2014 instance.
The error says "The timeout period elapsed while attempting to consume the pre-login handshake acknowledgement."


This is because the server on which SQL server is installed, is denying the client connections to SQL Server.
To fix this error, allow connections to the SQL Server Port in the firewall.

6 comments:

  1. On SQL 2012 and Windows Server 2012 R2, I disabled all three firewalls and still get the error. Do you know of any other causes? Thanks.

    ReplyDelete
  2. Perhaps you should also a put a forum site on your blog to increase reader interaction.”,-.” https://royalcbd.com/faq/

    ReplyDelete