PRB: SQL Administrator Hangs When Viewing Error Log on Novell

Last reviewed: April 28, 1997
Article ID: Q86582

The information in this article applies to:

  - Microsoft SQL Server version 4.2

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


THE INFORMATION PROVIDED IN THE MICROSOFT KNOWLEDGE BASE IS PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND. MICROSOFT DISCLAIMS ALL WARRANTIES, EITHER EXPRESS OR IMPLIED, INCLUDING THE WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. IN NO EVENT SHALL MICROSOFT CORPORATION OR ITS SUPPLIERS BE LIABLE FOR ANY DAMAGES WHATSOEVER INCLUDING DIRECT, INDIRECT, INCIDENTAL, CONSEQUENTIAL, LOSS OF BUSINESS PROFITS OR SPECIAL DAMAGES, EVEN IF MICROSOFT CORPORATION OR ITS SUPPLIERS HAVE BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. SOME STATES DO NOT ALLOW THE EXCLUSION OR LIMITATION OF LIABILITY FOR CONSEQUENTIAL OR INCIDENTAL DAMAGES SO THE FOREGOING LIMITATION MAY NOT APPLY.

Last reviewed: April 28, 1997
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.