We had one of our SBS 2003 R2 Premium boxes go blue shield on us after WSUS v3 was service packed.
As we combed through the various settings to make sure they were set to the SBS 2003 R2 specific ones, we ended up needing to recreate the groups in the WSUS console, set the Products updated to all, and reset the sync schedule to automatic.
After combing through all of those settings though, we still had a blue shield.
The fix ended up being the SQL script that we needed to run in the following Knowledgebase article under the second method:
- Microsoft KB 945985: Software updates are not managed by Windows Small Business Server 2003 Update Services after you upgrade to Windows Server Update Services 3.0 Service Pack 1
After running the script we received the following output:
Changed database context to 'SUSDB'.
Using SUSDB
No work to do. Record already exists.
Automatic Approval For Detection is already enabled
Target group of approval for detection is not "AllComputers"
Inserting "AllComputers" group
"AllComputers" Group added
Critical update is not in approval for detection classification
Critical update is inserted to approval for detection classification
Security update is not in approval for detection classification
Security update is inserted to approval for detection classification
Service pack is not in approval for detection classification
Service pack is inserted to approval for detection classification
We then went into the SBS Console and clicked on the Update Services node and after a few minutes were greeted with:
We now have our WSUS integration back.
Philip Elder
MPECS Inc.
Microsoft Small Business Specialists
Co-Author: SBS 2008 Blueprint Book
*Our original iMac was stolen (previous blog post). We now have a new MacBook Pro courtesy of Vlad Mazek, owner of OWN.