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.) (.Net SqlClient Data Provider)

A new error I have seen while trying to connect to SQL 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.) (.Net SqlClient Data Provider)

This error can occur any time, any where you click in studio. The place of occurrence will also be not consistent. Some of the places I have seen the error is,

1. Trying to connect to SQL server.
2. Right click on a DB.
3. Executing a query. 

So, it was like some thing was messy.  Restarted SQL server, SQL browser services and even the Server. Nothing really helped. :(

SOLUTION: Simple as it always will be.

1. Connect to SQL server via studio.
2. Right click on SQL instance --> Properties --> Connections --> "Set the Maximum number of concurrent connections to '0' ". 
3. Save the change. 
4. Restart the SQL server if possible.

Cheers !!
Krishna.