Sharepoint Installation Error–>Exception: System.Data.SqlClient.SqlException: The configuration option ‘min server 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 seerver 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

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s