Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

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

Posted on 2008-10-14
1
Medium Priority
?
621 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 2000 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

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

Question has a verified solution.

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

The SBS 2011 release date (RTM) is supposed to be around Christmas, 2011.  This article is a compilation of my notes -- things I have learned first hand.  The items are in a rather random order, but I think this list covers most of what is new and d…
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…
Exchange organizations may use the Journaling Agent of the Transport Service to archive messages going through Exchange. However, if the Transport Service is integrated with some email content management application (such as an anti-spam), the admin…
Please read the paragraph below before following the instructions in the video — there are important caveats in the paragraph that I did not mention in the video. If your PaperPort 12 or PaperPort 14 is failing to start, or crashing, or hanging, …

963 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