WSUS 3 on SBS2008 not working

I'm having some issues with WSUS on my SBS 2008 box.  This all started when an HD died.  After installing a new replacement drive I noticed that a new PC that I was trying to deploy was constantly failing on installing certain updates (the same ones).
I figured it was due to corrupted updates in WSUS (due to the HD failing) so I read that in order to re-download updates for WSUS, I had to run the wsusutil reset command.

I ran that command 2 weeks ago, and i'm not sure if it did anything but all i know now is that wsus is not working.  
When I start the Update Services MMC, i can't view anything under the Updates Node.  It sits there and eventually crashes because it times out.
If i go to the Options node and try to change the email settings for example, I get a notice at the bottom of the popup window that says "Cannot save configuration because the server is still processing a previous configuration change"

How do I figure out what its trying to process?
BTW, I did re-boot the server and that didn't change anything.
MedrxAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Larry Struckmeyer MVPCommented:
Hi:

Did you follow the procedure bellow to do the reset?
http://www.lukecjdavis.com/how-to-clear-out-your-wsuscontent-folder/

You can see there are a number of steps that will prepare the system for the reset and clearing of the previous data.  What we can't be sure of is if there was actual corruption in the data that would not allow the total clearing.

Perhaps you should consider uninstall and reinstall:
http://blogs.msmvps.com/bradley/2009/08/27/repairing-wsus-3-on-sbs-2008/

Which is "relatively easy" per the link.  <g>
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
MedrxAuthor Commented:
I did the uninstall and re-install while keeping the DB so that I would not loose all the information.  When the install was finished I was basically returned back to the way things were before the uninstall.  Whatever the DB is trying to do, its still doing it even after the re-install.

What tools can I use to see what the server is doing with the SUSDB so that I can stop it.

The last resort here would be to uninstall and start from scratch which I would like to avoid if possible.
0
MedrxAuthor Commented:
In the end I was not able to figure out what WSUS was doing to the DB.  I ended up uninstalling WSUS and not keeping the DB.

When installing WSUS, I decided to install the DB on a remote SQL instance which seems to have helped with performance.
I did run into a snag when telling the WSUS wizard about the remote SQL server.  For anyone reading this in the future, I have to put the following for the remote instance name:  SQL_SERVER_NAME\MSSQLSERVER,1433 .   I had to add ",1433" for the wizard to see the DB, otherwise it would fail.

Once everything was installed and all the computer groups were created for SBS to work, I realized I had to install KB2720211 in order for my clients to talk to WSUS.  Apparently WSUS 3.0 with SP2 does not come with that update.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
SBS

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.