Encountered an oddball of a problem today with our usergroup server.
Event Type: Error
Event Source: MSSQLSERVER
Event Category: (4)
Event ID: 17809
Date: 8/5/2007
Time: 10:46:58 PM
User: N/A
Computer: SGDOTNET
Description:
Could not connect because the maximum number of '2' user connections has already been reached. The system administrator can use sp_configure to increase the maximum value. The connection has been closed. [CLIENT: <local machine>]
For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.
Data:
0000: 00004591 00000014 00000009 00470053
0010: 004f0044 004e0054 00540045 00000000
0020: 0000
For some reason SQL Server was somehow set to allow a ridiculous maximum of 2 connections. Very useful server. It made is extremely difficult to connect to it even within for local Management Studio administration. Fortunately, somebody else by the name of Jason has found a direct way to reconfigure SQL Server to allow unlimited connections again.
Make sure to connect in Management Studio using File > New > Database Engine Query, then run the following commands
sp_configure 'show advanced options', 1
go
reconfigure
go
sp_configure 'user connections', 0
go
reconfigure