Sunday, May 1, 2011

Sharepoint Installation Error-->Exception:System.Data.SqlClient.SqlException: The configuration option 'minserver memory' does not exist

Hi All,

I was intstalling sharepoint 2007 server in dev enviornrment & had encounterted the below error:

"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."

Remote SQL server is SQL2005

Issue got resolved by running the following query on SQL server:

exec
sp_configure
'show advanced options', 1;

GO

RECONFIGURE
WITH
OVERRIDE;

GO

sp_configure
'allow updates', 0;

GO

RECONFIGURE
WITH
OVERRIDE;

GO

No comments:

Post a Comment