Thursday, December 27, 2007

SQL Server error updating WSS/MOSS

Exception: System.Data.SqlClient.SqlException: The configuration option 'min server memory' does not exist, or it may be an advanced option. Ad hoc update to system catalogs is not supported.

I have encountered this error during the step 2 in the wizard. It is due a configuration in the SQL Server 2005 and the solution is to execute the following script:

exec
sp_configure
'show advanced options', 1;

GO

RECONFIGURE
WITH
OVERRIDE;

GO

sp_configure
'allow updates', 0;

GO

RECONFIGURE
WITH
OVERRIDE;

GO

After that the wizard finishes successfully.

Related links:
http://www.webservertalk.com/archive132-2007-4-1871302.html (I found here the script)

 
Online Visitors