Insufficient Resource Space

If a Microsoft® SQL Server™ configuration option is set too high for the amount of available resources, SQL Server fails to start. For example, if the max server memory setting is too high, other applications may take some time to start.

Reset configuration options to their default values as described in Setting Configuration Options and sp_configure, or start SQL Server with minimal configuration by using the -f startup option of the sqlservr application.

See Also
Setting Configuration Options sqlservr Application
sp_configure  

  


(c) 1988-98 Microsoft Corporation. All Rights Reserved.