HEELPBOOK - SQL Server - Fix for 'No Process is on the Other End of the Pipe' Error #####################

If you are trying to login to SQL Server 2005 and get an error message that says 'No Process is on the Other End of the Pipe', then try the following.

* Open up SQL Server Suraface Area Configuration tool by clicking: Start > Microsoft SQL Server 2005 > Configuration Tools > SQL Server Suraface Area Configuration;

* Click the Surface Area Configuration for Services and Connections link at the bottom of the window;

* 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;

* In the setting for the Remote Connections, click the Local and Remote Connectionsoption.

* 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!



############ ARTICLE INFO #############

Article Month: May
Article Date: 18/05/2012
Permalink: http://heelpbook.altervista.org/2012/sql-server-fix-for-no-process-is-on-the-other-end-of-the-pipe-error/
Source: http://mycodetrip.com/2006/12/20/fix-no-process-is-on-the-other-end-of-the-pipe-error-2005_48/
Language: English

View more articles on: http://www.heelpbook.net/
Follow us on Facebook: http://it-it.facebook.com/pages/HeelpBook/100790870008832
Follow us on Twitter: https://twitter.com/#!/HeelpBook
Follow us on RSS Feed: http://feeds.feedburner.com/Heelpbook
Follow us on Delicious: http://delicious.com/heelpbook