Microsoft SQL Server Error 233, No Process Is On The Other End Of The Pipe

Microsoft SQL Server Error 233, No Process Is On The Other End Of The Pipe

Microsoft SQL Server Error 233, No Process Is On The Other End Of The Pipe, if you are getting this error, then you are at the right page. I faced this issue and by following the under given instruction, i successfully solved it.

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)

If you are getting the above error while connecting with Microsoft SQL server 2005 installed on your system then you are at the right page. I got this error on a developer’s machine and after one hour research on the Google found the correct answer. The first reaction after any error is to check the Event log in windows. I got under given error in application log:

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: ]

After reading the above error anyone can understand the problem and there is also given the solution of this problem. How to solve the above problem, please follow the instruction given below:

    • Open Microsoft SQL Server Management Studio
    • Open a new query
    • Type the under given code and press the execute button

sp_configure ‘show advanced options’, 1;

go

reconfigure

go

sp_configure ‘user connections’, 0

go

reconfigure

go

The reason why you got this error is that the user connections was reset to 1, so only one user was able to connect with the SQL server.

Please visit our Facebook page to follow updates.

13 thoughts on “Microsoft SQL Server Error 233, No Process Is On The Other End Of The Pipe”

  1. I have the same issue but I can’t connect to the default instance so how an i supposed to run that query. SQL will not allow me without logging in first.

    Many Thanks
    Farhat

    Reply
  2. go to sql server configration>> services>> ruuning services
    SQl server(MSSQL EXPRESS) Running
    Sql server(MSSQLSERVER) Running
    other services stop

    Client>> VIV is stop rerst are rtunning

    ur problem slove

    Reply
  3. I have MS SQL Server 2014.

    No Process is on the other end of the pipe.
    Microsoft SQL Server Error: 233

    I try it. But still not working.
    Please tell me why

    Reply
  4. Thanks for this post.

    Just had this problem after applying which failed as part of windows update

    Security Update for SQL Server 2016 Service Pack 1 CU KB4505221

    Connected to database server in SSMS (without initially connection to a database server) by using a new query window and connecting to ADMIN:{servername}

    Reply

Leave a Comment

This site uses Akismet to reduce spam. Learn how your comment data is processed.