WSUS - AGAIN!! SQL errors

[CHR1S]

2011-12-06 15:26:18 Error MWUSSetup Failed to open service MSSQL$MICROSOFT##SSEE (Error 0x80070424: The specified service does not exist as an installed service.)
2011-12-06 15:26:18 Error MWUSSetup StartService failed (Error 0x80070424: The specified service does not exist as an installed service.)
2011-12-06 15:26:18 Error MWUSSetup Failed to start MSSQL$MICROSOFT##SSEE service (Error 0x80070424: The specified service does not exist as an installed service.)
2011-12-06 15:26:18 Error MWUSSetup Failed to start SQL service for SQL instance %computername%\MICROSOFT##SSEE (Error 0x80070424: The specified service does not exist as an installed service.)

The above errors are after a supposed clean uninstall of WSUS3.

I have tried trimming the relevant SQL entries from the registry as instructed on a page I googled im still stuck.

Anyone?? Please???? Help!!!!!!

[Diello]

Have you tried running: "regsvr32 wuaueng.dll" from CMD? Can you access the DB if you install SQL Management Studio Express?

[CHR1S]

Management server does not recognise the local server as an SQL server.

WSUS "should" install MSSQL$MICROSOFT##SSEE as part of the install, but throws up the above error still.

It also seems to think there is an old WSUS database installed somewhere...... grrrr

[CHR1S]

msiexec /x {CEB5780F-1A70-44A9-850F-DE6C4F6AA8FB} callerid=ocsetup.exe

Also fails when removing the internal database. Going to try reinstalling from a fresh msi.

Edit - the fresh MSI worked, it removed without errors and WSUS now gets a bit further into the install.

2011-12-08 09:25:38 Error MWUSSetup InstallWyukon: wYukon Installation Failed (Error 0x80070643: Fatal error during installation.)
2011-12-08 09:25:38 Error MWUSSetup CInstallDriver::PerformSetup: Installation of wYukon failed (Error 0x80070643: Fatal error during installation.)
2011-12-08 09:25:38 Error MWUSSetup CSetupDriver::LaunchSetup: Setup failed (Error 0x80070643: Fatal error during installation.)
2011-12-08 09:25:41 Error MWUSSetup CWatsonHelper::Init: Failed to load WER library. (Error 0x8007007E: The specified module could not be found.)
2011-12-08 09:25:41 Error MWUSSetup CSetupDriver::ReportFailure: Failed to initalize the CWatsonHelper. This is expected on pre-Vista machines. (Error 0x80004005: Unspecified error)
2011-12-08 09:25:41 Error MWUSSetup DoInstall: Wsus setup failed (Error 0x80070643: Fatal error during installation.)

The specific error is -

An instance with the same name is already installed on this computer

And the error from the SQL Management Studio -

TITLE: Connect to Server
------------------------------

Cannot connect to SERVER\MICROSOFT##SSEE.

------------------------------
ADDITIONAL INFORMATION:

A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified) (Microsoft SQL Server, Error: -1)

For help, click: http://go.microsoft.com/fwlink?ProdN...1&LinkId=20476

------------------------------
BUTTONS:

OK
------------------------------

[CHR1S]

Urgh, somehow the SQL instance reg keys that were previously deleted (MICROSOFT##SSEE) got back in to the registry, perhaps because of the multiple reinstall attempts.

Anyway, this seems to be working now, I hope my solution will help someone else