From: Eric Isaacs on
> 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.)

======================

See if this helps:
http://technet.microsoft.com/en-us/library/ms175496.aspx

-Eric Isaacs
From: Maninder on
try this:
Click START--> RUN--> cliconfg
In the SQL Server Client Network Utility ENABLE Named Pipes and TCP/
IP. Goto Alias TAB.
Click ADD and include the name of the SERVER to connect in the SERVER
ALIAS box only.
Click OK and OK.
Now try to make a connection and check if this Works.