Lesson Learned #304: TCP Provider, error: 35 - An internal exception was caught

[Guest Jose_Manuel_Jurado]

In the last months our customers reported several connectivity issues with the error message: provider: TCP Provider, error: 35 - An internal exception was caught that is part, for example, this previous error message, for example, A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections."

 

 

 

There can be many reasons.. is it prefixed with during pre-login handshake. So, in this situation, it is important to implement our retry-logic also, you could find a very interested article from our product team SqlClient troubleshooting guide - ADO.NET Provider for SQL Server with several solutions and approaches.

 

 

 

Additional information:

 

 

 

• Issue: TCP Provider, error: 35 - An internal exception was caught" when connecting to Managed Instances · Issue #20192 · microsoft/azuredatastudio (github.com)
  
• Github repository: GitHub - dotnet/SqlClient: Microsoft.Data.SqlClient provides database connectivity to SQL Server for .NET applications.
  

 

 

 

Enjoy!

 

Continue reading...