Solved

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

Posted on 2008-10-14
1
608 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

Use Case: Protecting a Hybrid Cloud Infrastructure

Microsoft Azure is rapidly becoming the norm in dynamic IT environments. This document describes the challenges that organizations face when protecting data in a hybrid cloud IT environment and presents a use case to demonstrate how Acronis Backup protects all data.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
SBS 2011 - migration to Exchange 2016 5 216
shadow copies 7 76
SBS 2011 wireless nic? & dynamic VPN. 3 84
Small Business Server 2012 Essentials 5 56
Scenerio: You have a server running Server 2003 and have applied a retail pack of Terminal Server Licenses.  You want to change servers or your server has crashed and you need to reapply the Terminal Server Licenses. When you enter the 16-digit lic…
Setting up a Microsoft WSUS update system is free relatively speaking if you have hard disk space and processor capacity.   However, WSUS can be a blessing and a curse. For example, there is nothing worse than approving updates and they just have…
Two types of users will appreciate AOMEI Backupper Pro: 1 - Those with PCIe drives (and haven't found cloning software that works on them). 2 - Those who want a fast clone of their boot drive (no re-boots needed) and it can clone your drive wh…
A short tutorial showing how to set up an email signature in Outlook on the Web (previously known as OWA). For free email signatures designs, visit https://www.mail-signatures.com/articles/signature-templates/?sts=6651 If you want to manage em…

786 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