(provider: Shared Memory Provider, error: 0 - No process is on the other end of the pipe.)

I am getting the following error when i try to connect to the my web site using froma different server.

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

i am using sql express and i attach the database through the connection string in the web config.

Any ideas

The error indicates the connection was eatablished but then closed for some reason, this can happen if the SQL2005 instance is out of the available connections when the instance is configured to use a nonzero maximum number of concurrent connections. Check the SQL ERRORLOGs for detailed information, which you can get by executing xp_readerrorlog in Management Studio. If you find something like "Could not connect because the maximum number of '5' user connections has already been reached.", you can execute such command:

sp_configure 'user connections',0