Your server is out of user connections, ie... you have to many users logged in. Have users logout or allocate more user connections.

To check the current number of connections log in as 'sa' and issue this command in isql:

sp_configure 'user connections'
go

To allocate 40 more connections use this command:

sp_configure 'user connections', 40
go

--Roy Stewart

On 31 Aug 2003 07:36:54 -0700, ofercohen@allot.com (ofer) wrote:
> look at the last line in the error log: 00:2003/08/14 07:08:06.57
> server Error: 1601, Severity: 21, State: 3
>
> I dont understand why did i get this error.
>
>
>
> 00:2003/08/14 04:22:53.26 server WARNING: ***************************
> 00:2003/08/14 07:08:03.49 server Error: 1601, Severity: 21, State: 3
> 00:2003/08/14 07:08:03.53 server There are not enough 'user
> connections' available to start a new process. Retry when there are
> fewer active users, or ask your System Administrator to reconfigure
> SQL Server with more user connections.
> 00:2003/08/14 07:08:06.57 server Error: 1601, Severity: 21, State: 3