Unable to run with specified memory size of %ld. Please see the System Administration Guide for more information on how to calculate this number.
A RECONFIGURE statement failed because SQL Server determined that there is not enough memory available for subsequent starts of SQL Server.
Note The calculations performed by RECONFIGURE are internal to SQL Server and do not account for computer resources, which might or might not be adequate to support the SQL Server configuration.
This error is a result of using sp_configure to make configuration changes that cannot be met using the specified value of the memory option. Because RECONFIGURE must be executed before the changes can take effect, SQL Server has a chance to verify that there will be enough memory to satisfy all requirements.
Because of the complexity of SQL Server memory allocation, RECONFIGURE cannot always detect potential problems resulting from setting configuration values too high. If such problems go undetected, SQL Server will not start. For information about using RECONFIGURE, see the Microsoft SQL Server Transact-SQL Reference.
Because this error occurs when the value of the memory option is too low to allocate all requested resources, you can correct this problem by using sp_configure to increase the value of the memory option or decrease the value of other parameters.
After these changes have been made, you can execute RECONFIGURE. If the statement completes without error, the problem is probably resolved. For additional information about memory usage, see Chapter 21, "Configuration Issues."