Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 10938
  • Last Modified:

the pre-login handshake

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
VBdotnet2005
Asked:
VBdotnet2005
  • 3
  • 3
1 Solution
 
GaryCommented:
Is it just sporadic or all the time?
Is port 1443 open on the servers firewall?
Is IPv6 enabled
0
 
VBdotnet2005Author Commented:
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
 
GaryCommented:
Start > Control Panel > Network and Sharing Center.
Click Local Area Connection
In the new window click Properties
Check IPv6 is checked
0
Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

 
VBdotnet2005Author Commented:
Yes, it is checked.
0
 
GaryCommented:
Is there anything else bogging the server down?
Are you running long queries?
Is the DB getting locked?
0
 
VBdotnet2005Author Commented:
It is ok now. Our admin took care of it.
0
 
käµfm³d 👽Commented:
Any chance you can share what the resolution was?
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

  • 3
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now