Solved

SBS 2003 R2 WSUS not working; Removed R2; Installed R2; WSUS not working... Help!

Posted on 2008-10-14
1
601 Views
Last Modified: 2008-11-24
Hello,

We have a SBS 2003 R2 server (fully updated, WSUS 3.0 via R2 technologies) that is about 3 months old. Everything was working well until late last week when our workstations reported that they could not get updates. I investigated and determined that the c:\wsus and another directory were missing! The software was still installed, but when I clicked on "Update Services" in server control panel, I received an error from IIS and not the usual updates webpage.

I researched how to reinstall update services in an SBS 2003 R2 environment, and followed their instructions, which basically was to uninstall R2 from SBS 2003, reboot, verify that some services and wsus directories were deleted, and to reinstall R2. The installation of R2 was problematic, but I resolved each issue and R2 finally installed, but Update Services on the server control panel still had issues. I decided to install WSUS 3.0 and WSUS 3.0 SP1, which cleaned up errors.

Today, when I go to the server control panel and click "Update Services", I get an message saying that I cannot use this tool to configure updates because I "customized update services." When I launch update services management via mmc and try to connect to the server, the connection fails even though the "Update Service" service is started. There are no errors in the Event Log.

My ulitimate goal is to get the SBS R2 Update Service page via the server control panel working again, but if it is not possible, I need to get WSUS 3.0 SP1 working properly. I would appreciate your help and suggestions...

Thanks,

Mike
0
Comment
Question by:mjgardne
1 Comment
 
LVL 5

Accepted Solution

by:
gratex_ssd earned 500 total points
Comment Utility
Hi Mike, the solution is quite easy, you need to revert changes you've made to WSUS 3 configuration. Just follow these steps:

1, http://support.microsoft.com/kb/945985

2, If you get error in /UpdateServices application in the console, you also need to recreate default auto approval rule by running this script (source: http://technet.microsoft.com/en-us/library/cc708091.aspx)

I get a "Server Error in '/UpdateServices' Application" error.

Cause: This occurs if you delete the Default Auto Approval Rule by using the WSUS 3.0 Administration Console. The Windows SBS 2003 R2 Update Services node in the Server Management console does not load if you delete this rule.

Solution: Recreate the Default Auto Approval Rule by using the following procedure.
To recreate Default Auto Approval Rule

   1.      From the server, copy the following script on a notepad and save the file as C:\FixR2.SQL. (it may be better for you to copy this script directly from source website rather than this post)

USE SUSDB;
PRINT 'Using SUSDB';
GO
IF NOT EXISTS (SELECT * FROM dbo.tbAutoDeploymentRule WHERE ID = 2)
BEGIN
    PRINT 'Setting IDENTITY_INSERT to On';
    SET IDENTITY_INSERT tbAutoDeploymentRule ON;
    PRINT 'Inserting auto deployment rule';
    INSERT INTO dbo.tbAutoDeploymentRule(ID, Enabled, ActionID, Name) VALUES (2, 0, 0, 'Default Auto Approval Rule');
    IF @@ROWCOUNT = 0
        PRINT 'Warning: No rows were affected.';
    ELSE
        PRINT 'Rows were updated.';
    PRINT 'Setting IDENTITY_INSERT to Off';
    SET IDENTITY_INSERT tbAutoDeploymentRule OFF;
END
ELSE
    PRINT 'No work to do.  Record already exists.';
GO

Click Start, click Command Prompt, and then type %Programfiles%\Common files\update services\setup\executesql.exe -S MICROSOFT##SSEE -i C:\fixR2.SQL -l C:\output.log.
#

Review the information in the C:\output.log file to ensure that it contains the following:

Changed database context to 'SUSDB'.

Using SUSDB

Setting IDENTITY_INSERT to On

Inserting auto deployment rule

Rows were updated.

Setting IDENTITY_INSERT to Off

If the file contains these items, the script successfully recreated the Default Auto Approval Rule.

Check if everything works okay.  Let me know. Good Luck!

0

Featured Post

Free Trending Threat Insights Every Day

Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

Join & Write a Comment

I’m often asked about newer and larger USB drives connected to SBS2008 and 2011 failing Windows Server Backup vs the older USB drives not failing. As disk space continues to grow and drive technology change SBS2008 and some SBS2011 end up with the f…
You may have discovered the 'Compatibility View Settings' workaround for making your SBS 2008 Remote Web Workplace 'connect to a computer' section stops 'working around' after a Windows 10 client upgrade.  That can be fixed so it 'works around' agai…
This video discusses moving either the default database or any database to a new volume.
In this seventh video of the Xpdf series, we discuss and demonstrate the PDFfonts utility, which lists all the fonts used in a PDF file. It does this via a command line interface, making it suitable for use in programs, scripts, batch files — any pl…

771 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

11 Experts available now in Live!

Get 1:1 Help Now