Is the named pipes protocol enabled on the test server? Also, how many sqlserver connections are open? Do you need SqlServer Agent running on the test server?


>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.