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_MACHINESOFTWAREMicrosoftUpdate ServicesServerSetupwYukonInstalled
  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 *:WSUSUpdateServicesDbFiles (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

Leave a Comment

This site uses Akismet to reduce spam. Learn how your comment data is processed.