Monday, April 28, 2014

Problems Removing WSUS from SBS 2008

Once upon a time (approximately 4 years ago) I built an SBS 2008 server for a small business,  everything worked, everything was automated and the customer was very happy.  I was engaged to build this server, deploy the workstations and setup the network infrastructure but not maintain it.  Four years later the customer tracks me down by and calls me back with a mountain of problems.  The integrator here in Perth Western Australia (which will remain nameless) turned my perfect SBS deployment into a nightmare of problems due to unexperienced engineers performing server work - something which is far to common here in Australia.

One of the problems I faced was with the Windows Software Update Services, the service which "deploys updates" to computers on the network.

I found the "Update Services" service in a disabled state, the Windows Internal Database (WID) SQL Instance was completely missing from the server.  As a result the Windows Server Update Services mmc console would simply not launch and crash.  Starting the Update Services service also did not help improve the situation due to the missing SQL WID database.

Running a "wsusutil reset" simply failed due to the lack of database!

Fatal Error: 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: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)

 
Attempting to uninstall WSUS resulted in the following error messages:
 
The Windows Server Update Services 3.0 SP2 was not removed successfully because an error occurred.
 
 
Attempt to un-install Windows Server Update Services failed with error code 0x80070643.  Fatal error during installation
 
 
These uninstall errors were being caused because the SQL database no longer exists.  To remove a WSUS server which is missing its SQL database I found that you need to modify the following registry key:
 
 HKLM\Software\Microsoft\Update Services\Server\Setup
 
DWORD: wYukonInstalled
 
Set the decimal value to 0
 
 
Repeat the uninstall process (make sure you select not to remove the SQL database) as part of the uninstall and it will complete successfully.
 
 
After performing the uninstall, a simple server reboot was required before I re-installed WSUS using Windows Server 2008 Server Manager.

7 comments:

  1. Thank you! Similar situation here. We setup the server, had everything running pretty much autonomously and thought the client should be fine for years to come. Another group came in and "fixed" some things so well that they were removed and we were called back. This was one of the last issues we were working to figure out. It really helped finding your registry edit, I wasn't aware of that setting. We're just about back to working conditions again.

    ReplyDelete
  2. Wow! Great solution!!!

    Most other posts about this issue involve granting SQL admin rights (which I tried, but to no avail) and a manual removal of the entire database (which would cause numerous problems since there are other active databases on this box.)

    Changing one digit in this one registry key worked like a charm!

    ReplyDelete
  3. Great! Thanks for this!

    ReplyDelete
  4. Worked fine. Many thanks

    ReplyDelete
  5. It aint working for me yet

    ReplyDelete
  6. Thank You very much.... You saved my day.... Great

    ReplyDelete