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)
1 comment:
Great rread thankyou
Post a Comment