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

I ran into that error when I was running SQL Server Express because, by default, it has remote connections disabled. I had to enable TCP/IP connections. SQL Server 2005 Surface Area Configuration > Surface Area Configuration for Services and Connections. Then select the instance of SQL Server, Database Engin, Remote Connections. I changed mine to "Local and remote connections, using TCP/IP only". I guess if that doesn't work you could also enable "Using both TCP/IP and named pipes".

It could also be a bit simpler - your username/password doesn't have access to everything it needs on the server.