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 03:53:18.42 server Error: 1105, Severity: 17, State: 4
00:2003/08/14 03:53:18.42 server Can't allocate space for object
'syslogs' in database 'netreal' because the 'logsegment' segment is
full. If you ran out of space in syslogs, dump the transaction log.
Otherwise, use ALTER DATABASE or sp_extendsegment to increase the size
of the segment.
00:2003/08/14 03:53:18.44 server Unable to write CHECKPOINT record in
database 5 because the log is out of space.
00:2003/08/14 03:53:18.44 server Automatic checkpointing is disabled
in database 'netreal' because the log is out of space. It will
continue when the DBO successfully checkpoints the database. Please
free up some space or extend the database and then run CHECKPOINT.
00:2003/08/14 03:53:27.82 server WARNING: ***************************
00:2003/08/14 03:53:27.82 server Attempt by user 3 to dump xact on db
netreal with NO_LOG
00:2003/08/14 03:56:24.32 server WARNING: ***************************
00:2003/08/14 03:56:24.32 server Attempt by user 3 to dump xact on db
netreal with NO_LOG
00:2003/08/14 03:59:24.81 server WARNING: ***************************
00:2003/08/14 03:59:24.82 server Attempt by user 3 to dump xact on db
netreal with NO_LOG
00:2003/08/14 04:02:26.91 server WARNING: ***************************
00:2003/08/14 04:02:26.92 server Attempt by user 3 to dump xact on db
netreal with NO_LOG
00:2003/08/14 04:05:26.35 server WARNING: ***************************
00:2003/08/14 04:05:26.36 server Attempt by user 3 to dump xact on db
netreal with NO_LOG
00:2003/08/14 04:08:34.61 server WARNING: ***************************
00:2003/08/14 04:08:34.62 server Attempt by user 3 to dump xact on db
netreal with NO_LOG
00:2003/08/14 04:11:29.94 server WARNING: ***************************
00:2003/08/14 04:11:29.94 server Attempt by user 3 to dump xact on db
netreal with NO_LOG
00:2003/08/14 04:14:32.15 server WARNING: ***************************
00:2003/08/14 04:14:32.16 server Attempt by user 3 to dump xact on db
netreal with NO_LOG
00:2003/08/14 04:17:32.32 server WARNING: ***************************
00:2003/08/14 04:17:32.32 server Attempt by user 3 to dump xact on db
netreal with NO_LOG
00:2003/08/14 04:20:27.58 server WARNING: ***************************
00:2003/08/14 04:20:27.61 server Attempt by user 3 to dump xact on db
netreal with NO_LOG
00:2003/08/14 04:22:53.24 server Attempt by user 3 to dump xact on db
netreal with NO_LOG was successful
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

It should be too many connections already opened, so
they reached the maximum configured. A 1601 error
must appear in errorlog for each subsequent attempt
to open a new connection.

I see no reason to think there may be a hidden problem
behind this. I've seen 1601 errors many times and the
reason was always a lack of free connections.

Regards,
Mariano Corral

ofercohen@allot.com (ofer) wrote:
> 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

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