Lesson Learned #278: TCP Provider, error: 0 - The specified network name is no longer available

[Guest Jose_Manuel_Jurado]

In some situations, our applications at the moment of the connection could face this type of error message: "

 

Error 64: A connection was successfully established with the server, but then an error occurred during the pre-login handshake. (provider: TCP Provider, error: 0 - The specified network name is no longer available.) and/or following with for System.Data.SqlClient.SqlException "A connection was successfully established with the server, but then an error occurred during the pre-login handshake."

 

 

 

Following, I would like to share with you my experience in this type of issues.

 

 

 

Normally, this type of error message came from a TCP layer reset (either client or server) for multiple reasons and then fail immediately. In case that the situation is establishing the connection, my suggestion is treat this issue as transient issue and implement a connection retry-logic.

 

 

 

Enjoy!

 

Continue reading...