Error 17809

Severity Level 10

Message Text

Could not connect. The maximum number of '%1!ld!' configured user connections are already connected. The system administrator can change the maximum to a higher value using sp_configure.

Explanation

This error results when all configured user connections are in use and a request to create another Microsoft® SQL Server™ process occurs. SQL Server is not configured with enough user connections to support all requests. There is one process slot structure (PSS) 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 installation, each user connection requires 37 KB 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.

See Also