PRB: Cannot Register Server in SEM Due to Insufficient Memory

 Last reviewed: April 30, 1997
Article ID: Q132451

The information in this article applies to:
  • Microsoft SQL Server, version 6.0

SYMPTOMS

SQL Enterprise Manager returns the following error message when you try to register a SQL Server: 

   Unable to connect to Server (reason: There is insufficient system
   memory to run this query). Register anyway?
If the server is registered anyway, any attempt to connect to the server from within SQL Enterprise Manager will result in the following error: 

   A connection could not be established to <servername> - There is
   insufficient system memory to run this query

CAUSE

SQL Server has not been allocated enough memory. In order to use SQL Enterprise Manager to administer SQL Server, the server must have at least 4.5 megabytes of RAM allocated to SQL Server.

WORKAROUND

Use the sp_configure stored procedure to allocate at least 2304 2K pages to SQL Server.

MORE INFORMATION

For additional information on configuring SQL Server memory, please see the following article in the Microsoft Knowledge Base: 

   ARTICLE-ID: Q110983
   TITLE     : INF: Recommended SQL Server for NT Memory Configurations

Additional query words: sql6 out of 701 Windows NT
Keywords : kbother SSrvServer SSrvWinNT
Version : 6.0
Platform : WINDOWS
Issue type : kbprb

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 30, 1997
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.