PRB: Cannot Register Server in SEM Due to Insufficient Memory

ID: Q132451

The information in this article applies to:

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:

Q110983 : 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

Last Reviewed: April 15, 1999