Skip to main content

Posts

Showing posts from June, 2011

SQL Server Login Failure - No Process Is on the Other End of the Pipe (Microsoft SQL Server, Error:233)

You may experience login failure preventing you from connecting to SQL Server for many possible reasons. Each reason is clearly mentioned at the login failure error message at the time you try to login. (Assuming you are using SQL Server Native Client Tool) One of such possibility is your login attempt fails with below message: A connection was successfully established with the server, but then an error occurred during the login process. (provider: Shared Memory Provider, error: 0 – No process is on the other End of the pipe.) (Microsoft SQL Server, Error:233) Resolution: Possibility 1: The client is attempting to connect with the named pipes protocol before trying the TCP protocol (because of the protocol order from client configuration) but named pipes are not enabled on the server. Resolution: Move TCP before named pipes in the protocol order list on the client computer using SQL Server Configuration Manager. Possibility 2: The client is attempting to connect usin