A transport-level error has occurred when Receiving Results from the server

Asked

Viewed 973 times

1

I have an app Asp.Net MVC 4 (with Entity Framework and SQL Server) that works normally on my application server, but now I had to work with redundancy and load balance with two new servers for the application (discarding the old one). On each of the servers I followed the basics installing all the necessary resources and configuring the application on IIS. The database is on a separate server and has not been changed.

After starting the first new server, I tested the application that worked perfectly, but when starting the second new server and starting the tests I received the following error:

A transport-level error has occurred when Receiving Results from the server. (Preview: Session Provider, error: 19 - Physical Connection is not usable)

Description: An unhandled Exception occurred During the Execution of the Current web request. Please review the stack trace for more information about the error and Where it originated in the code.

Exception Details: System.Data.Sqlclient.Sqlexception: A transport-level error has occurred when Receiving Results from the server. (Preview: Session Provider, error: 19 - Physical Connection is not usable)

I did some digging and found this article by Microsoft, where I am able to credit that the problem is related to connection pooling.

Some doubts arose:

1- Connection pooling is controlled by the ADO.Net of the Database server or by each of the application servers?

2- What are the possible causes of the problem?

3- How can I fix it? Any settings like 'Connection Lifetime' and 'Max Pool Size' in the Web.config? (What such settings do and why they are a possible solution?)

.net sql-server entity-framework web.config

  • Ever tried to recycle the Application Pool? How’s your database connection?

  • Yes, when you ask about how the connection is, whether it’s working or how I did it on the Web.config?

  • I was able to make it work by disabling Pooling, putting it in the connection string Pooling=false;

  • This problem of yours can be caused by a number of factors. Post what you did to resolve as response, which then add the others, to complement.

No answers

Browser other questions tagged .net sql-server entity-framework web.config

You are not signed in. Login or sign up in order to post.