>>>>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.
I'm going to investigate. The strange thing is that some pages (in particular, the Manage Users page) work without a problem.
If it's not broken, fix it until it is.
My Blog