WSUS update from 3.0 SP1 to 3.0SP2 fails

Andrew
Andrew used Ask the Experts™
on
Hi Experts,

Seem to be going around in circles attempting to update WSUS to 3.0SP2 but receive the following message -  
"Windows Server Update Services could not be upgraded. A database backup was created at G:\WSUS\{D013EBD7-0B73-41D1-86DF-9453D6B9C958}. For more information, see the Setup log "C:\DOCUME~1\ADMINI~1\LOCALS~1\Temp\1\WSUSSetup.log".

Also having troubles deciphering the logs so I have attached them hoping this might shed some light for the experienced WSUSers... thanks in advance.

 WSUSSetupmsi-110517-1426.log
WSUSSetup.log
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Top Expert 2015

Commented:
stop iis before trying again?
AndrewPartner

Author

Commented:
ok... back on site tomorrow will try that thanks gheist
AndrewPartner

Author

Commented:
No luck on that suggestion gheist
How to Generate Services Revenue the Easiest Way

This Tuesday! Learn key insights about modern cyber protection services & gain practical strategies to skyrocket business:

- What it takes to build a cloud service portfolio
- How to determine which services will help your unique business grow
- Various use-cases and examples

Cris HannaSr IT Support Engineer

Commented:
Did you install the report viewer?
WSUS creates a local group on the WSUS server called "WSUSAdministrators". Add the admin account you're using to fire off the SP2update to this local group on your WSUS server and run the SP2 upgradewizard again. It should now be able to apply the update without anyproblems.
AndrewPartner

Author

Commented:
Yes, Report viewer is installed...

I ended up removing WSUS 3.0 SP1 via Windows Install Cleanup but didnt do a reboot due to staff being onsite. But then was able to get the option to do the upgrade, although I had an error in the end (sorry didnt record it) but was still able to get through and finish.

I checked the logs and it said that 8 PC's had connected recently so I guess something is correct.

Also checked two PC's with the clientdiag tool and got a sucess on that.

Admin Tools shows "Windows Server Update Services" But when I try and connect to Server1 I get the following "The server may be using a different port or sockets layer"

Other issue is I can still see the WSUS 3.0.SP1 in the list of Admin Tools and still same error when trying to connect to server1

Will check the logs in the morning for errors and see how things have progressed overnight ... thanks for the responses.
AndrewPartner

Author

Commented:
Sorry forgot to mention administrator is already added to that WSUSAdministrators group.
Cris HannaSr IT Support Engineer

Commented:
This question is in the Small Business Server zone...is there an SBS server and if so, which version?
DonNetwork Administrator

Commented:
AndrewPartner

Author

Commented:
dstewartjr: no but will have a look at that going onsite there this afternoon.

Chris: Sorry put it in the tag but not the original post its SBS2003
Cris HannaSr IT Support Engineer

Commented:
Are you attempting to do the update via WSUS?
My suggestion is to download and install it separately
http://www.microsoft.com/downloads/en/details.aspx?FamilyID=a206ae20-2695-436c-9578-3403a7d46e40

In this article is a link to special instructions for installing on SBS 2003
http://technet.microsoft.com/en-us/library/cc708091(WS.10).aspx

AndrewPartner

Author

Commented:
Thanks for the links - I downloaded and attempted the install which didnt work originally... but after using Windows Install Cleanup tool I was able to progress further and attach to the old database.

I had the choice to start new or attach to old DB I chose to attach to old... not sure if that was correct thing to do as I am still having issues.


I found 1 entry for in the Server report on 4 instance's of "The API remoting Service is not working" that appears to be the only error in regards to WSUS, but I cant work out why I can still see WSUS SP1 in the programs list in the start menu... but not in the "Add Remove Programs" I am thinking it may be best just uninstalling WSUS and all reminents and starting again your thoughts?
Sr IT Support Engineer
Commented:
I'd rip it out...start database clean...and download the file in the link I sent which includes SP2 but install using the article in the second link
DonNetwork Administrator
Commented:
How to manually remove all of WSUS

http://blogs.technet.com/b/sus/archive/2008/11/05/how-to-manually-remove-all-of-wsus.aspx

And sometimes you also need to remove WID

Uninstalling Windows Internal Database

http://technet.microsoft.com/en-us/library/cc708610(WS.10).aspx
DonNetwork Administrator

Commented:
Also all this can be done successfully without any reboots
Cris HannaSr IT Support Engineer

Commented:
Do not remove the WID..it's used for other things in SBS
DonNetwork Administrator

Commented:


"And sometimes you also need to remove WID"


I should have stressed more on the "sometimes"
AndrewPartner

Author

Commented:
No probs...thanks guys at least I was in the right spot I have that download and also had found the link as I had previously only followed to removing the WSUS via the cleanup tool as mentioned in a prior post.

Onsite now going to give it a try... I think I will skip the WID removal at this point.
Shall let you know how it goes.
AndrewPartner

Author

Commented:
Best solution start fresh!!!

Worked 2nd time around thanks for the advice.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial