Intermittent pre-login handshake error

• Sailorking

  Right there with Babe

  Points: 739

  More actions

  August 5, 2013 at 10:24 pm

  #297370

  Environment:

  SQL 2008 R2 Cluster

  Running fine for over 6 months

  Every once in a while I get some time-outs from our web apps with a SQLAsync Exception:

  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=1; handshake=15003;

  Anyone get this before? Again the server is listening on port 1433 and the connection strings are using TCP\IP. This is a intermittent error. I remember something like this that had to do with multiple instances and Named Pipes and TCP or the client is trying to connect via TCP\IP v6 first then 4 but I have checked all that and it seems fine.

  thanks in advance

• AJ@SQL

  SSC Eights!

  Points: 811

  More actions

  August 12, 2013 at 12:29 pm

  #1640668

  Have you looked into network traffic/ traces during the time of the issue?

• cossy.cosmas

  SSC Rookie

  Points: 43

  More actions

  January 29, 2014 at 3:17 am

  #1684209

  Hi,

  I'm seeing this too.

  Did you ever get to the bottom of it?

  I suspect that its either a network issue or a performance/bottleneck on the database server.

  Regards,

  Cossy