Hi everybody,
Our applicaiton is working properly in local environment. When I copy it to the test server and run it, some pages (not all of them) produce strange errors like this
===========================================================================================================
A connection was successfully established with the server, but then an error occurred during the login process. (provider: Shared Memory Provider, error: 0 - No process is on the other end of the pipe.)
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 connection was successfully established with the server, but then an error occurred during the login process. (provider: Shared Memory Provider, error: 0 - No process is on the other end of the pipe.)
Source Error:
Line 409: Command.CommandTimeout = 0;
Line 410:
Line 411: Command.Connection.Open(); // highlighted command
Line 412: Result = Command.ExecuteScalar();
Line 413: }
==================================================================================
I'm not sure how to debug them and what exactly do I need to do. We may try to put this into production and see if we would get the same errors. I haven't debugged this applicaiton from the test server before, was only doing local tests.
If it's not broken, fix it until it is.
My Blog