Could not able to uninstall SharePoint

Configuration:

MOSS (2007 with SP1) installation on windows 2003 R2 (SP2) standalone machine. (Contains WFE, Appserver, and SQLDB with Embedded Edition)

 

Reason for crash:

The latest change in Auto update configuration of the machine, automatically updated the SQL server with SP2. This machine contains only MS embedded edition (which comes with basic installation of MOSS) of SQL server, not standard or higher. I think the SP2 is not for EE, and obviously corrupted the config DB.

 

Detail:

After the latest MS patch, the MOSS server stopped working. It gave couple of error like this in the event viewer.

· Unknown SQL Exception 33002 occurred. Additional error information from SQL Server is included below.

Access to module dbo.proc_GetCurrent is blocked because the signature is not valid.

· The description for Event ID ( 33002 ) in Source ( MSSQL$MICROSOFT##SSEE ) cannot be found. The local computer may not have the necessary registry information or message DLL files to display messages from a remote computer. You may be able to use the /AUXSOURCE= flag to retrieve this description; see Help and Support for details. The following information is part of the event: module, dbo.proc_GetRunnableWorkItems.

· Cannot start service SPAdmin on computer…. (part of configuration wizard rerun process).

 

Explored Solution:

1. Ran the SharePoint configuration wizard did not help. It stopped at the 4 or 5th point.

2. Server reboot did not give any help. Tried configuration wizard again….no luck.

3. Tried to upgrade the DB with the following command. %commonprogramfiles%\Microsoft Shared\Web Server Extensions\12\BIN\psconfig -cmd upgrade -inplace b2b -wait -force

4. So tried to remove the MOSS installation, Using Add/Remove programs. But I could not able to uninstall SharePoint trial version. The uninstall option quit without any error.

5. Ran the MOSS installation program(using installation CD) and chose the ‘remove’ option to remove the existing MOSS installation. This also did not work (program stopped without any error).

6. Finally I reinstalled the latest service pack, SP1, again on WSS and MOSS. Then I ran the configuration wizard, which went through without any error. The SharePoint sites started working (no errors in the log).

 

Strange... but worked..