Monday, July 6, 2009

named pipes provider no process is on the other end of the pipe error 233

Can anyone tell me what the cause of the error below is?

I have the client tools installed on XP Pro Svc Pack 2.0. When I try to
connect to the server on the remote machine I get the error message below.

I have set the logins up correctly for the user id I'm using on the client
machine and the remote SQL Server 2005 is setup to accept remote connections.
Naturally, when I go to the info site the error has no information available.

the SQL Server 2005 installation is on a Server 2003 OS.


TITLE: Browse Server for Database

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)


In SQL Server 2005,
1. use the SQL Server Configuration Manager.
2. Go to the SQL Server 2005 Network Configuration node
3. and under that you will find the protocols.
4. Enable TCP/IP

In SQL Server 2000, use the Server Network Utility. On the
general tab, you select the protocols to enable.
You need to restart the service after enabling protocols.


No comments: