SQL Server Error: No Process is on the Other End of the Pipe

當登入SQL Server 2005時可能碰到錯誤： 'No Process is on the Other End of the Pipe'。解決方案：

（1）Open up SQL Server Suraface Area Configuration tool by clicking

Start > Microsoft SQL Server 2005 > Configuration Tools > SQL Server Suraface Area Configuration
（2）Click the Surface Area Configuration for Services and Connections link at the bottom of the window.
（3）In the View By Instance pane on the left, expand the node for the SQL Server that is giving you the error, and
click the Database Engine > Service > Remote Connections.
（4）In the setting for the Remote Connections, click the Local and Remote Connections option.
Now click the Using both TCP/IP and named pipes option and click OK.
You will be prompted to restart your Database Server for the changes to take effect. Do that.
Once you restart your Database Server, you should be able to login to the SQL Server database successfully !

 No Process is on the Other End of the Pipe

錯誤提示：

Named Pipes Provider: No process is on the other end of the pipe.

Microsoft SQL Native Client : Communication link failure.

Microsoft SQL Native Client : An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections.

典型原因和解決方案：

Cause	Resolution
The client is attempting to connect using named pipes, and the server is not configured to allow remote connections using named pipes.	Connect using TCP/IP, or use the Surface Area Configuration tool to enable remote connections using named pipes.
The client protocol order is attempting to connect with the named pipes protocol before trying the TCP protocol, and named pipes are not enabled on the server.	Using SQL Server Configuration Manager on the client computer, move TCP before named pipes in the protocol order list.

from:  http://theshiva.us/technicalblog/archive/2006/12/20/solution-fix-no-process-is-on-the-other-end-of-the-pipe-error-sql-server-2005.aspx
from:  http://technet.microsoft.com/en-us/library/ms175496.aspx