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

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

-> http://www.microsoft.com/products/ee/transform.aspx?ProdName=Microsoft+SQL+Server&EvtSrc=MSSQLServer&EvtID=233

=> 

Explanation

The SQL Server client cannot connect to the server. This error could occur because the server is not configured to accept remote connections.

User Action

Use the SQL Server Surface Area Configuration tool to allow SQL Server to accept remote connections. For more information about the SQL Server Surface Area Configuration Tool, see Surface Area Configuration for Services and Connections.

Ref: 

http://blogs.msdn.com/sql_protocols/archive/2005/10/22/483684.aspx