WSUS broken error 421 connection to database failed

We have SBS 2003R2 Premium.  The WSUS is failing and I can no longer get to the Monitor and Reporting screen.  The reporting is sending emails ... just same message of database connection.

I don't mind reinstalling WSUS ... it is 2.0 and I know that I need to have 3.0 installed.  Evidently the WSUS has not worked in 18 months and when I asked it to sync thats when it went into failure.  We have SQL 2005 and are not currently using it.  We will be installing a software that requires SQL in the very near future.  Any and all suggestions will help.
vic45708Asked:
Who is Participating?
 
DonConnect With a Mentor Network AdministratorCommented:
I would definitely uninstall  and then upgrade to 3.0


Upgrade from WSUS 2.0 to WSUS 3.0
0
 
DonNetwork AdministratorCommented:
Also be aware that after you upgrade to 3.0 you will no longer use a webpage to administer Wsus, you will need to use the MMC from Start>>>administrative tools>>>Update services
0
 
vic45708Author Commented:
What should I expect in Uninstalling WSUS.  Is there a plan or checklist ... I don't want to lock up the server ... It hosts our email through exchange in addition to all of the users desktops and data.
0
Cloud Class® Course: CompTIA Cloud+

The CompTIA Cloud+ Basic training course will teach you about cloud concepts and models, data storage, networking, and network infrastructure.

 
vic45708Author Commented:
I just noticed your link. :)

What about the databases ... should I start from scratch.  If so how do I do this.  I don't understand the importance of the databases considering that it has not worked in 18 months.
0
 
DonConnect With a Mentor Network AdministratorCommented:
start from scratch, delete the databases
0
 
vic45708Author Commented:
Will do over the next few days and I will get back with you .... Thanks!
0
 
DonConnect With a Mentor Network AdministratorCommented:
There are pre-requisites before you install wsus 3.0 this guide will help you

Install WSUS 3.0 - Step-By-Step
0
 
vic45708Author Commented:
I uninstalled WSUS 2.0 and the "Performance and Reporting" is still in ERROR state.  I don't want to install WSUS 3.0 and compound what ever is going on with the system.

When I go to the P&R services it starts and stops with an ERROR Code of 1.

I have pasted the Error Below

Where do I go from here?

****************

Event Type:      Error
Event Source:      ServerStatusReports
Event Category:      None
Event ID:      1
Date:            4/21/2009
Time:            11:29:02 AM
User:            N/A
Computer:      FTCSRV1
Description:
Server Status Report:
      URL:            http://localhost/monitoring/perf.aspx?reportMode=0
      Error Message:      File or assembly name Microsoft.UpdateServices.Administration, or one of its dependencies, was not found.
      Stack Trace:         at Microsoft.SBS.UpdateServices.DataProvider..ctor()
   at Microsoft.SBS.UpdateServices.StatusPage.Utility.GetStatusItems()
   at usage.frmPerf.PopulateStatusItems()
   at usage.frmPerf.renderReportWorker()
   at usage.frmPerf.renderReport()

For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.
0
 
vic45708Author Commented:
Sorry .... Wrong Event Posted Above

Maybe the same info just wrong time ... This was after uninstall reboot.

*********
Event Type:      Error
Event Source:      ServerStatusReports
Event Category:      None
Event ID:      1
Date:            4/21/2009
Time:            11:52:31 AM
User:            N/A
Computer:      FTCSRV1
Description:
Server Status Report:
      URL:            http://localhost/monitoring/perf.aspx?reportMode=0
      Error Message:      File or assembly name Microsoft.UpdateServices.Administration, or one of its dependencies, was not found.
      Stack Trace:         at Microsoft.SBS.UpdateServices.DataProvider..ctor()
   at Microsoft.SBS.UpdateServices.StatusPage.Utility.GetStatusItems()
   at usage.frmPerf.PopulateStatusItems()
   at usage.frmPerf.renderReportWorker()
   at usage.frmPerf.renderReport()

For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.
0
 
DonConnect With a Mentor Network AdministratorCommented:
0
 
vic45708Author Commented:
One last question before I drive out to the site ...

The reinstall of R2 shows to install WSUS first then R2.

1. Is this correct

2. Do I want to install WSUS 3.1 instead of 2.1?  I have already DL the exe WSUS30_SP1-x86
0
 
DonNetwork AdministratorCommented:
1. yes
2. 3.1
0
 
vic45708Author Commented:
I think I'm done.  I installed 3.1 and the Reporting now works.

Question:
In the 3.0 instructions the GPO asks to link OU to GPO ... what is OU.

I DIDNOT install R2 after installing WSUS 3.1 ... doI install?
0
 
DonConnect With a Mentor Network AdministratorCommented:
OU is Organizational Unit, this will give you more info
http://www.bristol.ac.uk/is/computing/advice/operatingsystems/supportstaff/wsus/configuring.html
 
 R2 yes
0
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.

All Courses

From novice to tech pro — start learning today.