Cannot open database “SUSDB” requested by the login.

This content 6 years old. Please, read this page keeping its age in mind along with the fact technology changes fast and the information on this page me be outdated, not best practice, or plain wrong.

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

Speak Your Mind

*

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