Solved

the pre-login handshake

Posted on 2014-03-24
7
9,777 Views
Last Modified: 2014-09-22
I have been getting this same error a few times. All my code does is calling a store procedure and have it returns somedata.  Any thoughts on this error?

System.Data.SqlClient.SqlException (0x80131904): 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=16360; handshake=6680;  ---> System.ComponentModel.Win32Exception (0x80004005): The wait operation timed out
   at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
0
Comment
Question by:VBdotnet2005
  • 3
  • 3
7 Comments
 
LVL 58

Expert Comment

by:Gary
ID: 39950776
Is it just sporadic or all the time?
Is port 1443 open on the servers firewall?
Is IPv6 enabled
0
 

Author Comment

by:VBdotnet2005
ID: 39950788
Is it just sporadic or all the time?   -  this is sporadic
Is port 1443 open on the servers firewall?  - yes
Is IPv6 enabled   - How do I check this?
0
 
LVL 58

Accepted Solution

by:
Gary earned 500 total points
ID: 39950822
Start > Control Panel > Network and Sharing Center.
Click Local Area Connection
In the new window click Properties
Check IPv6 is checked
0
ScreenConnect 6.0 Free Trial

Discover new time-saving features in one game-changing release, ScreenConnect 6.0, based on partner feedback. New features include a redesigned UI, app configurations and chat acknowledgement to improve customer engagement!

 

Author Comment

by:VBdotnet2005
ID: 39950863
Yes, it is checked.
0
 
LVL 58

Expert Comment

by:Gary
ID: 39950880
Is there anything else bogging the server down?
Are you running long queries?
Is the DB getting locked?
0
 

Author Comment

by:VBdotnet2005
ID: 39995052
It is ok now. Our admin took care of it.
0
 
LVL 75

Expert Comment

by:käµfm³d 👽
ID: 40337829
Any chance you can share what the resolution was?
0

Featured Post

NAS Cloud Backup Strategies

This article explains backup scenarios when using network storage. We review the so-called “3-2-1 strategy” and summarize the methods you can use to send NAS data to the cloud

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Problem Hi all,    While many today have fast Internet connection, there are many still who do not, or are connecting through devices with a slower connect, so light web pages and fast load times are still popular.    If your ASP.NET page …
If you need to start windows update installation remotely or as a scheduled task you will find this very helpful.
Email security requires an ever evolving service that stays up to date with counter-evolving threats. The Email Laundry perform Research and Development to ensure their email security service evolves faster than cyber criminals. We apply our Threat…
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…

809 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question