General discussion

Locked

SQL Server 6.5 Daily errors with no expl

By Richard Jones ·
We have recently been experiencing errors on our SQL Server and the errors have no good answers in any of our Tech guides. These errors include:

1. "# Number of users exceeded" errors in the middle of the night with no one on, this locks the DB down and no one can access it until it is rebooted. This usually occurs after a "General network error, problem sending results to front end" error, although we are getting no errors anywhere else and after using a sniffer are seeing no network errors. There also appears to be a Dr. Watson that will not write out a log when trying to reboot after these errors.

2. This morning I finally caught the Dr. Watson Error, it references a (pid139) and a (pid171) in the log and these show in TechNet as being associated errors with SNA Server and Terminal server but not with SQL Server. The exception error is associated with a SQLSERVR.DBG application. Today the SQLEXEC and SQLServer were shut down when I came in. Looking at the applicationevent log it appears

This conversation is currently closed to new comments.

13 total posts (Page 1 of 2)   01 | 02   Next
| Thread display: Collapse - | Expand +

All Comments

Collapse -

SQL Server 6.5 Daily errors with no expl

by gutridgesj In reply to SQL Server 6.5 Daily erro ...

what service pack are you running? we had a simliar problem. it seemed to go away but then we upgraded to 7.0

Collapse -

SQL Server 6.5 Daily errors with no expl

by Richard Jones In reply to SQL Server 6.5 Daily erro ...

Poster rated this answer

Collapse -

SQL Server 6.5 Daily errors with no expl

by TechAdmin In reply to SQL Server 6.5 Daily erro ...

You must applay the SQL Server service pack 5
you can find in

23 Feb 2000 SQL Server 6.5 Service Pack 5a (Intel) :
*********************************************
http://support.microsoft.com/support/kb/articles/q197/1/77.asp

and there is a post dix
18 Sep 2000 SQL Server 6.5 Post Service Pack 5a Update (Intel)

Collapse -

SQL Server 6.5 Daily errors with no expl

by Richard Jones In reply to SQL Server 6.5 Daily erro ...

Poster rated this answer

Collapse -

SQL Server 6.5 Daily errors with no expl

by PrinterManager In reply to SQL Server 6.5 Daily erro ...

It?s old you should re-post.

Collapse -

SQL Server 6.5 Daily errors with no expl

by Richard Jones In reply to SQL Server 6.5 Daily erro ...

Poster rated this answer

Collapse -

SQL Server 6.5 Daily errors with no expl

by soporte_ms In reply to SQL Server 6.5 Daily erro ...
Collapse -

SQL Server 6.5 Daily errors with no expl

by Richard Jones In reply to SQL Server 6.5 Daily erro ...

The question was auto-closed by TechRepublic

Collapse -

SQL Server 6.5 Daily errors with no expl

by Richard Jones In reply to SQL Server 6.5 Daily erro ...

We have been running 6.5 SP5a since it came out, since I posted this I have have even replace/upgraded the Server that this is running on. Completely reloading from scratch and reloading the data. We ran fine for about a month and now it has started doing it again. No real explication..

Collapse -

SQL Server 6.5 Daily errors with no expl

by Richard Jones In reply to SQL Server 6.5 Daily erro ...

The question was auto-closed by TechRepublic

Back to Networks Forum
13 total posts (Page 1 of 2)   01 | 02   Next

Related Discussions

Related Forums