Solved

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

Posted on 2008-10-14
1
612 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
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

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

The problem of the system drive in SBS 2003 getting full continues to be an issue, even though SBS 2008 and SBS 2011 are both in the market place.  There are several solutions to this, including adding additional drive space or using third party uti…
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…
In this brief tutorial Pawel from AdRem Software explains how you can quickly find out which services are running on your network, or what are the IP addresses of servers responsible for each service. Software used is freeware NetCrunch Tools (https…
Monitoring a network: why having a policy is the best policy? Michael Kulchisky, MCSE, MCSA, MCP, VTSP, VSP, CCSP outlines the enormous benefits of having a policy-based approach when monitoring medium and large networks. Software utilized in this v…

688 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