Error Explanation
There are not enough ‘user connections’ available to start a new process. Retry when there are fewer active users
Recommended Solution
1. Determine the current number of user connections configured: by using the following command
isql -Uusername -Ppassword 1> sp_configure "number of user connections" 2> go
2. Set the new value for user connections: (use sp_monitorconfig to monitor the number of user connections)
1> sp_configure "number of user connections", 2> new_value 3> go
3. Restart Adaptive Server to activate the changes.