Connection Error 233 : No process at the other end of the pipe

Just had an interesting error the other day.

Got this error when trying to connect one of our servers that has just been patched:

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)

Typically, to troubleshoot this, you go to SQL Server Configuration Manager (SSCM) and:
1. ensure Shared Memory protocol is enabled
2. ensure Named Pipes protocol is enabled
3. ensure TCP/IP is enabled, and s ahead of the Named Pipes in the settings

Check out Pinal Dave’s excellent post on this.

All of these are set in our server.

Next up, I checked the log files. Logs are typically located in a folder similar to this (note you will need to change the folder MSSQL.1 with the appropriate instance name’s folder name):
C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLLOG

When I checked the logs however, I got yet another interesting error:

Could not connect because the maximum number of ‘1’ user connections has already been reached. The system administrator can use sp_configure to increase the maximum value. The connection has been closed. [CLIENT: ]

It’s an interesting error because:
1. We just restarted the server and nobody is able to access it yet
2. DAC is disabled

Solution

After some more sleuthing and fiddling around, I went back to SSCM to check ensure the protocols are enabled properly. There’s 4 (four) options – SharedMemory, TCP/IP, Named Pipes and VIA (for Virtual Interface Adapter). Everything is turned on, except for VIA.

I enabled VIA protocol – and that did it. That was the issue.

Learn more about VIA:
http://en.wikipedia.org/wiki/Virtual_Interface_Adapter
http://msdn.microsoft.com/en-us/library/ms191229.aspx

5 thoughts on “Connection Error 233 : No process at the other end of the pipe

  1. abc January 14, 2012 / 7:02 am

    i m trying to install sql server 2008 on Window 7(Local System) bt not able to use it.It shows “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)” and after following all the steps above given by you still not able to start SQL Server Management Studio.

    Like

  2. Srinivas June 27, 2012 / 3:10 am

    I have 2 systems one server with windows server 2003 sp2 and also sql server 2008 r2 and another client system contain windows xp operating system. I want to access server system having sql server 2008 r2 database from client windows xp system. what are the steps to be followed to do this?

    Like

  3. chandru August 30, 2012 / 3:37 am

    actually i am afraid this problem in my client please… i can’t forget
    this……. i should find out the solution and give it all….

    Like

  4. sibi August 30, 2012 / 3:40 am

    give solution…. or na pora saava….

    Like

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s