SQL Server : A connection was successfully established with the server, but then an error occurred d

Posted by Pandians under Error and Solution on 4/18/2012 | Points: 10 | Views : 31255 | Status : [Member] [MVP] | Replies : 2

When I try to Initiate/open a new connection, The following Error occurred!
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)
Root Cause: Maximum connection has been exceeded on your SQL Server Instance.

How to fix it...!
1. F8 or Object Explorer
2. Right click on Instance --> Click Properties...
3. Select "Connections" on "Select a page" area at left
4. Chenge the value to 0 (Zero) for "Maximum number of concurrent connections(0 = Unlimited)"
5. Restart the SQL Server Instance once.

Caution: Please do not configure this on your Production/Multi-user servers! (The value should be 0 (ZERO))

Cheers
www.SQLServerbuddy.blogspot.com
iLink Multitech Solutions



Responses

Posted by: Chvrsri on: 4/18/2012 [Member] [Moderator] [MVP] Silver | Points: 25

Up
0
Down
Thank you PandianS,

For sharing this valuable information.

Thanks,
Radha Srikanth

Pandians, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Sebantom1979 on: 3/4/2013 [Member] Starter | Points: 25

Login to post response