SQL Server Connnection errors: "No process is on the other end of the pipe" or "An existing connection was forcibly closed by the remot

This is a typical error during the connection attempt to a SQL Server 2005 instance, this morning I was faced with similar issue at workplace. Initially I was confused why it is specifying the error: NO process is on the other end of pipe, which gives the thought about using Named-pipes protocol for that SQL instance. To ensure the TCP/IP and/or Named-pipes are enabled I have gone through SQL Server Surface Area Configuration tool as below: Start &gt; Microsoft SQL Server 2005 &gt; Configuration...(<a href="http://sqlserver-qa.net/blogs/tools/archive/2010/07/05/sql-server-connnection-errors-no-process-is-on-the-other-end-of-the-pipe-or-an-existing-connection-was-forcibly-closed-by-the-remote-host.aspx">read more</a>)<img src="http://sqlserver-qa.net/aggbug.aspx?PostID=9212" width="1" height="1">