Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 SQL Server Administration (2005)
 Error 233

Author  Topic 

NarayanaMoorthy
Starting Member

19 Posts

Posted - 2007-10-05 : 08:45:25
Hello,
I'm using windows XP SP2 and I have installed SQL Server 2005 Standard Edition. I usually connect my SQL Server 2005 using windows authenticationmode and server name as default. I have a only one server to which 4 client machines are connected. When I'm connecting I am getting this message.

"A connection was successfully established with the server, but then an error occurred during the pre-login handshake. 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. (Provider: Named pipes Provider, error: 0- No process is on the other end of the pipe.) (Microsoft SQL Server, Error: 233)"

Narayanamoorthy

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2007-10-05 : 23:28:07
You should enable remote access in sql server configuration manager and start sql server browser service.
Go to Top of Page

sebantom1979
Starting Member

6 Posts

Posted - 2013-03-04 : 06:34:15
http://answerforu.com/2011/06/08/no-process-is-on-the-other-end-of-the-pipe-microsoft-sql-server-error-233/
Go to Top of Page
   

- Advertisement -