Windows SBS 2008 updates

On June 8 I installed the KB2720211 update "Update for Windows Server Update Services 3.0 SP2 for x64-based Sytems."  The update called for a server re-start but upon restart failed to install properly.  It tried a further two times with the same result.

Now I have Update Services turned off and my backup fails to run.  Am I commited to re-installing Update Services?
DesertDawgAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

smplifyCommented:
Do you have any restore points you can use?

Have you checked eventlogs for errors, if so can you post any?

If you are installing this via WSUS, can you try and install manually KB2720211.
DesertDawgAuthor Commented:
I didn't think that SBS had restore points apart from the "last good installation" boot option.

Apart from the failed installation flag, the only other log error event relates to a WSUSPool failure with the Windows Process Activation Service.

A manual install failed too.
Rob WilliamsCommented:
A lot of people have had trouble with this update, with no definitive solution.  The most populated thread to follow is:
http://social.technet.microsoft.com/Forums/en-US/winserverwsus/thread/e918a191-ef6d-4c4b-b83a-7a4ae20a5217
See 1/3 down the page regarding "single user mode".  This seems to be the key issue so far.
Become a CompTIA Certified Healthcare IT Tech

This course will help prep you to earn the CompTIA Healthcare IT Technician certification showing that you have the knowledge and skills needed to succeed in installing, managing, and troubleshooting IT systems in medical and clinical settings.

DesertDawgAuthor Commented:
O.K.  I see the "single user" comment.  Using SQL Server Studio Express, how do I find the single/multi user mode option?
Rob WilliamsCommented:
:-)  I was afraid you would ask that.
I don't know. I havn't run into the problem.  I just thought I would point out what is being followed in some private discussions.  I will have a look in a couple of minutes and see if I can find it.
Rob WilliamsCommented:
No problem locating but I AM NOT A SQL GUY.  I cannot recommend any changes, advise of prerequisites, or consequences.  I recommend researching this further before taking action.

Go to programs | Microsoft SQL Server 2005 (unless updated) | SQL Server Management Studio Express | in the connection window enter:

server type = database engine
server name = \\.\pipe\MSSQL$MICROSOFT##SSEE\sql\query
authentication = Windows authentication

expand "databases" | right click on SUSDB and choose properties  | Options  | scroll down to State | restrict access
Jeffrey Kane - TechSoEasyPrincipal ConsultantCommented:
You should be able to solve this by following:
http://byronwright.blogspot.nl/2012/06/kb-2720211-kills-wsus.html

Jeff
TechSoEasy
DesertDawgAuthor Commented:
Thanks Rob.  Your instructions correctly take me to the DATABASES\SUSDB (Single User) folder but when I right click the folder I get the response "The database SUSDB is not accessible." (Microsoft.SqlServer.Express.ObjectExplorer)

So, it looks as if I do indeed have a "single user" database but do not seem to be able to change it.
DesertDawgAuthor Commented:
Just for additional information, I was able to access the SUSDB database on several other SBS2008 servers with no problem.  They were all in multi-user mode and had not suffered the update failure.
Rob WilliamsCommented:
The article Jeff posted points to the same discssion I linked but has more details.  It suggests stopping the Windows Update and World Wide Web Publishing servics before connecting so that the single user mode is accesible to you.  Sounds like it is already in use by a service account so you are denied access.
Rob WilliamsCommented:
By the way, in an effort to find a common denominator as to why this happens; was your WSUS database moved from the C: partition at any point and if so how long ago?  No problem to do so, but I noticed that was the case in 2 situations.
DesertDawgAuthor Commented:
Thanks Rob.  I'll give that a try.  It seems logical.
Rob WilliamsCommented:
As per my last comment. Was the WSUS database ever moved from the C: partition?
DesertDawgAuthor Commented:
Actually, of the five 2008 SBS servers that I currently manage, this one is the most up to date (installed 15 months) and has experienced the least trouble.  Apart from updates and service packs, the WSUS has not been altered nor the database moved.  The only event log "errors" that I've experienced in months happen when Forefront fails to find an anti-virus update for one of its' engines.  

It's odd then why this one is the only one on which I've experienced trouble with this latest update.
DesertDawgAuthor Commented:
O.K.  Stopping the Windows Update and Windows World Wide WEB publishing services released the database and permitted me to return it to multi-user mode.  I re-started the services, as well as Update Services, and can now access Windows Update and check for updates.  However, the check fails.  Is this because the database has to be re-connected?
Rob WilliamsCommented:
Please reffer to Jeff's link as to the steps to take once in multi-user mode. It is explained better than my link.

I was asking if the database was moved as the other units on which I have heard of the problem were moved.  I thought it might be a common denominator.
DesertDawgAuthor Commented:
I saw where you were going with the moved database denominator, but that wasn't the case on this server.  In fact, of the five SBS servers that I mentioned, this one was the one that I would have least expected to have any problems!

I see Jeff's coments about file copying.  I'll do that in the morning.  I did try the registry key change last week but it didn't work.
Jeffrey Kane - TechSoEasyPrincipal ConsultantCommented:
looking forward to hearing about your results.

Jeff
TechSoEasy
Rob WilliamsCommented:
Some more reading for you. This is a very  recent article pertaining to your problem.  again I have not had the issue so I have not tested any of these suggestions, but it may be of some help.
http://tinyurl.com/c2clhht
Rob WilliamsCommented:
A more recent, "official" Microsoft post created today addressing the issue with KB272011:
http://blogs.technet.com/b/sus/archive/2012/06/20/wsus-kb272011-common-issues-encountered-and-how-to-fix-them.aspx
DesertDawgAuthor Commented:
I still can't get this resolved
Jeffrey Kane - TechSoEasyPrincipal ConsultantCommented:
So if you look at the latest link that RobWill posted, which issue (1, 2, 3 or 4) fits your situation best?

Jeff
TechSoEasy
DesertDawgAuthor Commented:
O.K.  I'm trying to pick up on this again.  Issue 1 is probably the closest so I uninstalled WSUS 3.0 SP2.  I started the new installation but it failed.  Here is the installation log.

2012-10-16 10:26:28  Success   MWUSSetup          Validating pre-requisites...
2012-10-16 10:27:06  Success   MWUSSetup          Removing Wsus...
2012-10-16 10:27:08  Success   CustomActions.Dll  Successfully set propery of WSUS admin groups' full names
2012-10-16 10:27:34  Success   CustomActions.Dll  .Net framework path: C:\Windows\Microsoft.NET\Framework64\v2.0.50727
2012-10-16 10:27:50  Success   CustomActions.Dll  Creating user group: WSUS Reporters with Description: WSUS Administrators who can only run reports on the Windows Server Update Services server.
2012-10-16 10:27:50  Success   CustomActions.Dll  Creating WSUS Reporters user group
2012-10-16 10:27:50  Success   CustomActions.Dll  WSUS Reporters user group already exists
2012-10-16 10:27:50  Success   CustomActions.Dll  Successfully created WSUS Reporters user group
2012-10-16 10:27:50  Success   CustomActions.Dll  Creating user group: WSUS Administrators with Description: WSUS Administrators can administer the Windows Server Update Services server.
2012-10-16 10:27:50  Success   CustomActions.Dll  Creating WSUS Administrators user group
2012-10-16 10:27:50  Success   CustomActions.Dll  WSUS Administrators user group already exists
2012-10-16 10:27:50  Success   CustomActions.Dll  Successfully created WSUS Administrators user group
2012-10-16 10:27:50  Success   CustomActions.Dll  Successfully created WSUS user groups
2012-10-16 10:27:50  Success   CustomActions.Dll  Succesfully set binary SID property
2012-10-16 10:27:50  Success   CustomActions.Dll  Succesfully set binary SID property
2012-10-16 10:27:50  Success   CustomActions.Dll  Successfully set binary SID properties
2012-10-16 10:27:54  Success   CustomActions.Dll  Skipping deleting any WSUS admin group on domain controller...
2012-10-16 10:27:56  Info      IISCustomAction    Performing Setup Action, Command /Uninstall
2012-10-16 10:27:59  Info      IISCustomAction    Command /Uninstall Succeeded
2012-10-16 10:28:42  Success   Uninstall Helper   UninstallHelper Started.
2012-10-16 10:28:45  Success   MWUSSetup          Setup completed successfully
2012-10-16 10:28:56  Success   Uninstall Helper   UninstallHelper Succeeded.
2012-10-16 10:38:16  Success   MWUSSetup          Validating pre-requisites...
2012-10-16 10:38:17  Error     MWUSSetup          Failed to determine if an higher version of WSUS is installed. Assuming it is not... (Error 0x80070002: The system cannot find the file specified.)
2012-10-16 10:38:17  Error     MWUSSetup          WSUS is outdated. But this will not block setup (Error 0x00000000: The operation completed successfully.)
2012-10-16 10:41:33  Success   MWUSSetup          Initializing installation details
2012-10-16 10:41:33  Success   MWUSSetup          Skipping Asp.Net install since not running on win2k3...
2012-10-16 10:41:33  Success   MWUSSetup          Installing wYukon using ocsetup
2012-10-16 10:41:33  Success   MWUSSetup          Windows Internal database is already installed on this machine
2012-10-16 10:41:33  Success   MWUSSetup          Installing WSUS...
2012-10-16 10:41:34  Success   CustomActions.Dll  Unable to get INSTALL_LANGUAGE property, calculating it...
2012-10-16 10:41:34  Success   CustomActions.Dll  Successfully set propery of WSUS admin groups' full names
2012-10-16 10:41:38  Success   CustomActions.Dll  .Net framework path: C:\Windows\Microsoft.NET\Framework64\v2.0.50727
2012-10-16 10:41:42  Success   CustomActions.Dll  Creating user group: WSUS Reporters with Description: WSUS Administrators who can only run reports on the Windows Server Update Services server.
2012-10-16 10:41:42  Success   CustomActions.Dll  Creating WSUS Reporters user group
2012-10-16 10:41:42  Success   CustomActions.Dll  WSUS Reporters user group already exists
2012-10-16 10:41:42  Success   CustomActions.Dll  Successfully created WSUS Reporters user group
2012-10-16 10:41:42  Success   CustomActions.Dll  Creating user group: WSUS Administrators with Description: WSUS Administrators can administer the Windows Server Update Services server.
2012-10-16 10:41:42  Success   CustomActions.Dll  Creating WSUS Administrators user group
2012-10-16 10:41:42  Success   CustomActions.Dll  WSUS Administrators user group already exists
2012-10-16 10:41:42  Success   CustomActions.Dll  Successfully created WSUS Administrators user group
2012-10-16 10:41:42  Success   CustomActions.Dll  Successfully created WSUS user groups
2012-10-16 10:41:42  Success   CustomActions.Dll  Succesfully set binary SID property
2012-10-16 10:41:42  Success   CustomActions.Dll  Succesfully set binary SID property
2012-10-16 10:41:42  Success   CustomActions.Dll  Successfully set binary SID properties
2012-10-16 10:43:49  Error     MWUSSetup          InstallWsus: MWUS Installation Failed (Error 0x80070643: Fatal error during installation.)
2012-10-16 10:43:49  Error     MWUSSetup          CInstallDriver::PerformSetup: WSUS installation failed (Error 0x80070643: Fatal error during installation.)
2012-10-16 10:43:49  Error     MWUSSetup          CSetupDriver::LaunchSetup: Setup failed (Error 0x80070643: Fatal error during installation.)
DesertDawgAuthor Commented:
I've made a few fruitless attempts at re-installing WSUS 3.0.  I guess I could re-boot the server to see if that clears the error.  Oddly enough, since removing the damaged WSUS 3.0 installation, I'm no longer getting daily server reports issued.

Any other suggestions would be welcome.
DesertDawgAuthor Commented:
I reset the daily report time which got that working again.  

Re-booted the server but WSUS 3.0 still fails to install.  This is the daily report error related to updates.  

"Update Services is not properly installed. The following file or one of its dependencies is missing: Microsoft.UpdateServices.Administration, Version=3.1.6001.1, Culture=neutral, PublicKeyToken=31bf3856ad364e35"

I guess that a re-install would solve that if only it wouldn't fail?
DesertDawgAuthor Commented:
Does anybody have any input to help solve this problem?
Jeffrey Kane - TechSoEasyPrincipal ConsultantCommented:
How about this?  http://support.microsoft.com/kb/920660

Jeff
TechSoEasy

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
DesertDawgAuthor Commented:
Thanks Jeff.  

Not the complete answer but it did give me the idea to delete the old update services DB files folder, which was empty anyway, and create a new database.  That got WSUS 3.0 installed!

It's synchronizing now so I'll report after completion on how things are going.
DesertDawgAuthor Commented:
Synchronization complete.....it looks like it's working.  If nothing else, WSUS is now running again so I can "tweak" it from here.  Many thanks.
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
SBS

From novice to tech pro — start learning today.