Search

Monday, September 2, 2013

Error 233

Sometime you may get the below error while connecting to SQL Server.A Connection was successfully established with the server, but than an error occurred during the login process, (Provider: Shared Memory Provider, error: 0 - No process is on the other end end of pipe.)(Microsoft SQL Server Error: 233)The above error clearly states that maximum value for user connection is already reached so you can't login to SQL Server. If you are the system administrator than you can increase the maximum value by using the SP sp_configure.Use the below steps to increase the value. Open the SQL Server Management Studio.Write down the below queries:sp_configure 'show advanced options', 1GoreconfigureGosp_configure 'user connections', 0GoreconfigureGo