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