>>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.)
>
>What kind of authentication mode do you have set-up for SQL Server? Is it Windows authentication or SQL authentication (ex. you have a user and password embedded in the *.config file for the connection)? Also, are you running a "full" version of SQL Server, or something like SQL Express installed on your local development box?

AFAIK it's a full SQL Server version and we're using SQL Server authentication with userID and password. Locally I use a different web.config using Windows authentication.