I have WSUS 3.0 SP2 installed on a Windows 2003 machine. I have recently applied the WSUS hot fix which cause WSUS not to function
Which hotfix ... there are three that have been released in the past nine months.
I was able to remove WSUS but when I try to install it , it is giving me the error that I cannot connect to the database.
This is expected behavior. All three hotfixes introduce database schema changes which makes it impossible for a downlevel installation of WSUS to talk to a patched instance of the database - which is why the documentation for all three hotfixes provides
instructions to perform a full system backup prior to installing the update.
I believe that the WSUS database might be corrupt and and the registry some how is still pointing to the old database location. I would like to re install WSUS from scratch but I am not sure how to do it at this point.
Any ideas would be appreciated.
You need to do the following.
Install SQL Server Management Studio Express, and DETACH the existing (patched) WSUS database.
Make COPIES of the SUSDB.MDF and SUSDB_log.LDF files to a safe place.
Delete the original instances of SUSDB.MDF and SUSDB_log.LDF.
Install a new WSUS3SP2 (KB972455) instance with a fresh database. Do not run the setup wizard.
PATCH the WSUS installation to whatever hotfix you attempted to install previously.
Stop the Update Services service.
DETACH the new WSUS database and MOVE the new database files to a safe location (SUSDB.MDF and SUSDB_log.LDF).
COPY the patched database files back to the active location.
ATTACH the database to the database instance.
Restart the Update Services service.
or you can install a fresh WSUS server, patch it, and reset your groups and approvals. :)
Lawrence Garvin, M.S., MCITP:EA, MCDBA, MCSA
SolarWinds Head Geek Microsoft MVP - Software Distribution (2005-2013)
My MVP Profile: http://mvp.support.microsoft.com/profile/Lawrence.Garvin The views expressed on this post are mine and do not necessarily reflect the views of SolarWinds.
Microsoft está realizando una encuesta en línea para comprender su opinión del sitio web de Technet. Si decide participar, se le presentará la encuesta en línea cuando abandone el sitio web de Technet.