PRB: Number of User Connections Has Been Exceeded Error

  - Microsoft SQL Server version 4.2 for OS/2

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 specified in the configuration for SQL Server.

WORKAROUND

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>

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.