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.