PRB: SQL Administrator Hangs When Viewing Error Log on Novell (86582)
The information in this article applies to:
- Microsoft SQL Server 4.2x
This article was previously published under Q86582 SYMPTOMS
When attempting to view the error log using SQL Administrator for
Windows on Novell networks, SQL Administrator displays an hour
glass indefinitely. Any further attempts by any other clients to
schedule backups and manage statistics generate the following
messages:
SQL Monitor is busy with another client; try again later.
SQL Monitor is not started on the server.
This problem occurs only on some Novell systems.
WORKAROUND
Do not use SQL Administrator to view the error log on Novell
networks. You can go to the server and view the error log locally.
If you receive these error messages, stop and restart the SQL
monitor to enable other clients to schedule backups and manage
statistics.
Starting with SQL Server version 4.2a, SQL Monitor has a new
configuration parameter to set the packet size used when the
errorlog is returned to SQL Administrator for Windows. This packet
size parameter helps resolve the problem with viewing the errorlog
over a Novell Network from SQL Administrator for Windows.
To set the parameter when starting SQL Monitor from the command
line, use the /E parameter:
To set the parameter when starting SQL Monitor using the NETSQL
command, use the parameter /LOGSIZE:
netsql start sqlmonitor /PASSWORD= /LOGSIZE=500
The log size can range from 10 to 30720 (4096 is the default)
bytes. Testing indicates that a value of 500 works well on a Novell
network.
| Modification Type: | Major | Last Reviewed: | 3/16/1999 |
|---|
| Keywords: | kbnetwork KB86582 |
|---|
|