SBS 2008 and WSUS

My WSUS in my SBS 2008 is not working.  In the Windows SBS console it shows no updates and if I open Windows Server Update Services it will crash and says it cannot connect to server:  Error: Database Error.  Reset server node.
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.

Cris HannaCommented:
A couple of places to start.
First, have you installed and run the Best Practice Advisor?  
Then the Microsoft SBS 2008 Repair Guide for WSUS
TlingitAuthor Commented:
Yes, I have looked at this.  In the section To Manually Recover Windows Server Update Services the first 3 don't apply because it is listed in Programs and Features .  When I get to 4, however, this part is where it crashes.  Every time I open Windows Server Update Services it waits to gather the information for about five minutes and then it crashes.  I am thinking about uninstall WSUS and reinstalling.  What would be the downside of doing this in a Windows SBS 2008 environment?  If it's plausible, how should I uninstall and reinstall this program?
Cris HannaCommented:
If you uninstall from Programs and can then reinstall using the following from the article
To manually recover Windows Server Update Services
1.  Click Start, click Control Panel, click Programs, and then click Programs and Features.

2.  Verify whether Microsoft Windows Server Update Services <version x> is listed, where <version x> is the version that you are running (for example, 3.0 SP1). If it is listed, skip to Step 4.

3.  Verify that a WSUS subdirectory does not exist on any of the server volumes. If there is a WSUS subdirectory, delete it, and then do the following:
      a.  Create a directory called WSUS on the C: partition.

      b.  Insert Windows SBS 2008 Disc 2 (Component Technologies for Server Repair) into the server that is running
            Windows SBS 2008.

     c.  Open an elevated command line prompt, type <DVD Drive>:\CMPNENTS\wsus\wsussetup.exe /q  DEFAULT_WEBSITE=0 CREATE_DATABASE=1 CONTENT_LOCAL=1 CONTENT_DIR=C:\WSUS WYUKON_DATA_DIR=C:\WSUS, where <DVD Drive> is the DVD drive for the computer, and then press ENTER.

you'll probably want to grab c. from the article as the formatting is probably not correct here...then proceed with the rest of the article

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
Making Bulk Changes to Active Directory

Watch this video to see how easy it is to make mass changes to Active Directory from an external text file without using complicated scripts.

TlingitAuthor Commented:
My concern is uninstalling WSUS in a SBS environment because it relies on everything to be intact otherwise it throws a fit.  I guess I really don't have a choice in the matter.  I will uninstall and reinstall.  I've been fighting with this a couple of days so far.
Cris HannaCommented:
As a Microsoft MVP for Small Business Server since 1997, I'm pretty familiar with how tightly things are wrapped together.

How much ram do you have in the server?
How much free space on your C:\ drive?
Have you moved your WSUS repository to another drive letter?
TlingitAuthor Commented:
4gb of ram
149 gb free on c.
I have WSUS on D drive with about 50 GB left on this drive.
Exchange is on E drive with200 gb left.  I moved the repository and database to D which is recommended.
This is my server at home.
Cris HannaCommented:
well certainly part of the problem is your RAM
Is there any way for you to bump this to 8 or more gigs ?
TlingitAuthor Commented:
yes, that is not a problem.
Cris HannaCommented:
At only 4gigs of Ram you're at the absolute minimum to even install SBS 2008.  That means its going to be putting a real strain on the page file on the hard drive and would be surprised if this was your first real issue
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
Microsoft Legacy OS

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.