PRB: SQL Administrator Hangs When Viewing Error Log on NovellLast reviewed: April 28, 1997Article ID: Q86582 |
The information in this article applies to:
- Microsoft SQL Server version 4.2
SYMPTOMSWhen 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.
WORKAROUNDDo 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:
sqlmontr /P /E500To set the parameter when starting SQL Monitor using the NETSQL command, use the parameter /LOGSIZE:
netsql start sqlmonitor /PASSWORD= /LOGSIZE=500The 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.
|
Additional query words: admin errorlog
© 1998 Microsoft Corporation. All rights reserved. Terms of Use. |