PRB: SQL Administrator Hangs When Viewing Error Log on Novell

ID: Q86582

The information in this article applies to:

Microsoft SQL Server version 4.2x

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:

sqlmontr /P /E500

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.

Additional query words: admin errorlog

Keywords : kbnetwork SSrvLAN SSrvMon SSrvSQL_Admin
Version : 4.2
Platform : OS/2
Issue type :