One of our Windows VPS customers received the following error while connecting to the MSSQL server.
Upon checking the error message in the event logs, we came to know that the connection on the MSSQL server was already made, and new connections were being rejected. To fix connection restrictions, we set the user connection limit to unlimited as follows.
1. Open the command prompt with Administrator privileges and issue the following commands.
exec sp_configure 'user connections', 0
2. After issuing the above commands, restart MSSQL service.