Category Archives: WSUS

Cannot open database "SUSDB" requested by the login.

I’m receiving this error message on my WSUS 3.0 SP2 server. The proposed fix ((http://social.technet.microsoft.com/Forums/windowsserver/en-US/e918a191-ef6d-4c4b-b83a-7a4ae20a5217/wsus-30-sp2-will-not-run-after-installing-update-2720211?forum=winserverwsus)) indicates to perform the following.

  1. Download the KB2720211 from Microsoft: http://support.microsoft.com/kb/2720211
  2. Open Regedit, and change the value of this DWORD to 0: HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Update Services\Server\Setup\wYukonInstalled
  3. Install KB2720211
  4. Change the DWORD value back to 1
  5. Stop the SQL database service (I used Windows Internal Database, so it is MSSQL$MICROSOFT##SSEE)
  6. Delete the DB files in *:\WSUS\UpdateServicesDbFiles (SUSDB.mdf & SUSDB_log.ldf)
  7. Restore the SUSDB.mdf & SUSDB_log.ldf from backup
  8. Start the SQL database service
  9. Start the Update Services service

WSUS3 SP2 Service Problem

I was checking a few systems this morning and came across this glorious error.
2014-07-11_100058
Easy enough to fix, right?  Just go to Administrative Tools > Services and restart the Windows Server

Update Services service, right?

Of course not!

That service doesn’t exist.  I have WSUSCert ((Something cool)) service, but not the server service.  So now I’m downloading WSUS 3.0 SP2 again to re-install on top of this to maybe fix the problem.

Stay tuned!

Update 1

Installing WSUS 3.0 SP2 causing removal of Windows Update Service;  I left the database and synchronization data and logs in place.

After uninstall, I ran the WSUS 3.0 SP2 executable again and it began an install;  I chose the location of my previous Windows Update Service Server install as well as told it to use the existing database and the default IIS website.

Update 2

It’s been a few days but I think I stumbled upon a way to recover from this issue. Things just got real messy but this may be the working solution.

Force client computer to detect and install new updates using WSUS

The time period in which computers will check for updates on WSUS server is 22 hours (default).  However, you can have the client computer check manually by using the following command line:

wuauclt /resetauthorization /detectnow

If that doesn’t initially work, you can try a little more advanced option here involving removing some registry entries and running the same command to force it to check for updates.

@echo off
net stop wuauserv
REG DELETE "HKLMSoftwareMicrosoftWindowsCurrentVersionWindowsUpdate" /v PingID /f
REG DELETE "HKLMSoftwareMicrosoftWindowsCurrentVersionWindowsUpdate" /v AccountDomainSid /f
REG DELETE "HKLMSoftwareMicrosoftWindowsCurrentVersionWindowsUpdate" /v SusClientId /f
net start wuauserv
wuauclt /resetauthorization /detectnow
wuauclt /reportnow

Determine if Windows Update is Using WSUS

Is my computer being updated by a WSUS server?  Here’s a quick way to determine if your computer is using WSUS or not to provide Windows Updates to you.

You can check quickly by looking at the Windows Update screen in Windows 7 and identifying if it says “Managed by your system Administrator” such as the screenshot below indicates.

If your computer is not using a WSUS for Windows Updates, you will see a message similar to the one in the screenshot below.