Friday, December 12, 2008

SharePoint Configuration Fail after Update

My SharePoint installation is totally broken now. If I am trying to load my homepage I am getting this message:
An error has occurred on the server.http://go.microsoft.com/fwlink?LinkID=96177

I am receiving the following error with the service pack:

Configuration Failed
One or more configuration settings failed. Completed configuration settings will not be rolled back. Resolve the problem and run this configuration wizard again. The following contains detailed information about the failure:

Failed to initiate the upgrade sequence.

An exception of type System.Data.SqlClient.SqlException was thrown. Additional exception information: Ad hoc update to system catalogs is not supported.
Configuration option 'show advanced options' changed from 0 to 1. Run the RECONFIGURE statement to install.

To diagnose the problem, review the application event log and the configuration log file located at:

c:\....logs\pscdiagnostics....log


Solution:
---------------------------------------------------------------------------------------------------------------
I did a new sql query within the sql database:

USE master;
GOEXEC sp_configure 'show advanced option', '1';

RECONFIGURE WITH OVERRIDE;
EXEC sp_configure;

And afterwards run:SharePoint Products and Technologies Configuration Wizard

..\12\Bin\
---------------------------------------------------------------------------------------------------------------

Psconfig -cmd upgrade -force
Stsadm -o upgrade -inplace -forceupgrade