Solved

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

Posted on 2008-10-14
1
605 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
ID: 22806521
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

Scale it in WD Gold

With up to ten times the workload capacity of desktop drives, WD Gold hard drives employ advanced technology to deliver among the best in reliability, capacity, power efficiency and performance.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

I've often see, or have been asked, the question about the difference between the Exchange 2010 SP1 version, available as part of Small Business Server (SBS) 2011, and the “normal” Exchange 2010 SP1 Standard. The answer to the question is relativ…
A quick step-by-step overview of installing and configuring Carbonite Server Backup.
This Micro Tutorial will teach you how to censor certain areas of your screen. The example in this video will show a little boy's face being blurred. This will be demonstrated using Adobe Premiere Pro CS6.
As a trusted technology advisor to your customers you are likely getting the daily question of, ‘should I put this in the cloud?’ As customer demands for cloud services increases, companies will see a shift from traditional buying patterns to new…

911 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

22 Experts available now in Live!

Get 1:1 Help Now