Issue: While Initiating/opening 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)
Possible cause of error:
Maximum connection has been exceeded on your SQL Server Instance.
Here is the solution to fix this problem:
1. F8 or Object Explorer
2. Right click on Instance > Click Properties...
3. Select "Connections" on "Select a page" area at left
4. Change the value to 0 (Zero) for "Maximum number of concurrent connections(0 = Unlimited)"
5. Restart the SQL Server Instance once.
Production Caution: Try to avoid restrictions on connection limit on your Production or Multi-user servers! (The value should be 0 (ZERO) which for unlimited)
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)
Possible cause of error:
Maximum connection has been exceeded on your SQL Server Instance.
Here is the solution to fix this problem:
1. F8 or Object Explorer
2. Right click on Instance > Click Properties...
3. Select "Connections" on "Select a page" area at left
4. Change the value to 0 (Zero) for "Maximum number of concurrent connections(0 = Unlimited)"
5. Restart the SQL Server Instance once.
Production Caution: Try to avoid restrictions on connection limit on your Production or Multi-user servers! (The value should be 0 (ZERO) which for unlimited)
Tags:
MS SQL Server