PRB: Number of User Connections Has Been Exceeded Error

ID: Q59024

The information in this article applies to:

Microsoft SQL Server for OS/2, version 4.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>

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 query words: Optimization and tuning


Keywords          : kbother SSrvGen 
Version           : 4.2
Platform          : OS/2 
Issue type        :

Last Reviewed: March 9, 1999