Last post Nov 07, 2016 02:49 PM by dlchase
Nov 07, 2016 02:22 PM|dlchase|LINK
We added a Windows 2016 server and SQL Server 2016 to our domain and tried testing our asp.net connection and got the error below. Where can we go to fix this?
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=13422; handshake=14402;
Nov 07, 2016 02:34 PM|codemovement.pk|LINK
It happened due to all of reason. Can you please check below mentioned check list.
Nov 07, 2016 02:38 PM|Siva Krishna Macha|LINK
Some of the reasons could be Firewall or port configuration issues
See this discussion http://stackoverflow.com/questions/22566795/sql-server-pre-login-handshake-acknowledgement-error
Default port is 1433.
For IPV4 or IPV6 configuration, you can refer these steps: http://stackoverflow.com/questions/15488922/connection-to-sql-server-works-sometimes/15488923#15488923
Nov 07, 2016 02:49 PM|dlchase|LINK
It was a firewall issue.