Error 17809 (ODS)

Severity Level 21

Message Text

Unable to connect. The maximum number of '%d' configured user connections are already connected. System Administrator can configure to a higher value with sp_configure.

Explanation

This error results when all configured user connections are in use and a request to create another SQL Server process occurs. SQL Server is not configured with enough user connections to support all requests. There is one "PSS" (Process Slot Structure) for each configured user connection.

Action

Use the sp_configure system procedure to increase the number of user connections:

1. Set the new number for user connections. Type:

   sp_configure 'user connections', new_number
   go

2. Instruct SQL Server to accept the values by using the RECONFIGURE statement:

   RECONFIGURE
   go

3. Restart SQL Server to activate the changes.

Depending on the exact configuration of your SQL Server, each user connection requires 37K of memory, whether or not it is in use. Gradually increase the number of user connections until this error no longer occurs. When you change the user connections parameter, you may need to increase the memory parameter.