Microsoft KB Archive/59024
PRB: Number of User Connections Has Been Exceeded Error
The information in this article applies to:
- Microsoft SQL Server for OS/2, version 4.2
The following error message is displayed in the SQL Server error log:
server: No Pss structures available for new process
This message indicates that the number of user connections that has been specified in the configuration for SQL Server.
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.
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