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