PRB: Number of User Connections Has Been Exceeded Error

ID Number: Q59024

1.11 4.20

OS/2

Summary:

SYMPTOMS

The following error message is displayed in the SQL Server error

log:

server: No Pss structures available for new process

CAUSE

This message indicates that the number of user connections that

has been requested exceeds the maximum number of user connections

specified in the configuration for SQL Server.

RESOLUTION

To get around this error, increase the number of user connections

by issuing the following sp_configure command:

sp_configure 'user connections', <number of user connections>

Then run the reconfigure command and stop and restart the SQL

Server for the changes to take effect.

More Information:

Note that each user connection uses 42K of RAM. Therefore, memory

considerations must be taken into account before increasing the

number of user connections. The "numreqbufs" parameter in the

LANMAN.INI file should also be modified to correspond to the

increased number of user connections. Changing the "numreqbufs"

parameter is also required if you want to change the parameter

for "maxusers". Also, be sure to refer to your network manuals

before modifying any parameters. The network must be stopped and

restarted for the changes to take effect.

Additional reference words: Optimization and tuning