Getting error 'A transport-level error has occurred when receiving results from the server.'


When I am trying to Load page of my clients web application, which has shared connection string, I am getting the below error

A transport-level error has occurred when receiving results from the server. (provider: 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. (provider: Session Provider, error: 19 - Physical connection is not usable)

/transport-level-error-has-occurred-when-receiving-results-from-the-server-provider-Session-Provider-error.png

What's the issue?


Asked by:- bhanu
0
: 330 At:- 1/30/2018 11:57:10 AM
SQL sql-server transport-level error






2 Answers
profileImage Answered by:- jaiprakash

It looks like when fetching the results from server(share connection), database connection get's closed before it returns results to your web application, this can occur due to when you pickup the shared connection string and try to execute it's not able to reach the database or connection to sql server got interrrupted, if you are using Visual Studio, restart it or your local IIS and try again. If facing this issue on live website, simply resetting your application pool for your web site should recycle the connection pool should work.

If the above solution doesn't work, try restarting your SQL server(if using it locally) or if you are not using IIS end all of the debugger processes: WebDev.WebServer40.EXE which may solve your issue.

If you are still facing issue after trying all the above steps, please read moer about it here https://blogs.msdn.microsoft.com/spike/2009/04/16/a-transport-level-error-has-occurred-when-sending-the-request-to-the-server-provider-tcp-provider-error-0-an-existing-connection-was-forcibly-closed-by-the-remote-host/

2
At:- 1/31/2018 10:44:19 AM
Yes, I see my connection was interrupted from server, thanks for your answer 0
By : bhanu - at :- 2/7/2018 4:54:43 PM


profileImage Answered by:- pika

Try to restart your Visual Studio and SQL server, and check, I had similar issue once, restarting Visual Studio solved it.

1
At:- 2/12/2018 6:53:35 AM





Login/Register to answer
Or
Register directly by posting answer/details

Full Name *

Email *




By posting your answer you agree on privacy policy & terms of use