Other SQL Server Blogs around the Web

Browse by Tags

• anti-virus
• maximum
• restart
• service
• sp_configure
• tcp

• Could not connect because the maximum number of '1' user connections has already been reached. The system administrator can use sp_configure to increase the maximum value. The connection has been closed."

  The above error is obvious when you have setup the SQL Server instance to accept only 1 connection. The default setting for number of user connections is '0' which accepts unlimited connections. With similar settings one of my friend have had... Posted Sep 26 2007, 05:27 AM by SSQA.net Filed under: sql server, connections, recovery, tcp, anti-virus, sp_configure, maximum, service, restart