- WSUS 3.0 SP2 is missing SQL server Express or has been damaged somehow.
- When opening WSUS you receive a SQL error when trying to connect.
- You cannot uninstall WSUS. An attempt to uninstall/re-install fails with an error.
- The event log shows event id: 1034 with “Removal success or error status: 1603”
HOW TO FIX:
- Open REGEDIT in and locate: HKLM\Software\Microsoft\UpdateServices\ServerSetup.
- Change the value of “wYukonInstalled” to 0x0 (zero) and ensure that the value of “SqlInstanceIsRemote” is oxo [hexa] (zero) [decimal].
- Download and run the WSUS 3.0 SP2 installer. You should now be able to remove the product using the installer. Select none of the check boxes (to remove database, logs or updates), we can remove these manually later.
- Run the WSUS 3.0 SP2 installer again and (this time it should allow you to install). Install the Full product including management console.
- Select the option to use an existing database server.
- It should find the Internal Database you installed and configured.
- Step through the WSUS configuration wizard.