WSUS 3.0 SP2 needs repair/unable to reinstall

I had WSUS setup on a window server 2008 R2 x64 server. It was having trouble and I was unable to repair so I decided to try and reinstall and start new.

I used the following links to attempt uninstall of WSUS 3.0 SP2 and windows internal database.

http://technet.microsoft.com/en-us/library/dd939818(WS.10).aspx
http://blogs.technet.com/b/sus/archive/2008/11/05/how-to-manually-remove-all-of-wsus.aspx

Now the role still shows up in server manager and I am unable to remove the role. I restarted the server and I am still unable to remove. I also tried downloading WSUS 3 SP2 and running the installer, it fails. The log it provides is below.


2012-03-15 11:55:14  Success   MWUSSetup          Validating pre-requisites...
2012-03-15 11:55:14  Error     MWUSSetup          WSUS is outdated. But this will not block setup (Error 0x00000000: The operation completed successfully.)
2012-03-15 11:55:17  Success   MWUSSetup          ReportViewer is not installed on this machine
2012-03-15 11:55:17  Success   MWUSSetup          ReportViewer is not installed on this machine
2012-03-15 11:55:31  Success   MWUSSetup          Initializing installation details
2012-03-15 11:55:31  Success   MWUSSetup          Skipping Asp.Net install since not running on win2k3...
2012-03-15 11:55:31  Success   MWUSSetup          Installing wYukon using ocsetup
2012-03-15 11:55:31  Success   MWUSSetup          Installing Windows Internal database using ocsetup with command line as "ocsetup "WSSEE" /quiet /norestart"
2012-03-15 11:55:37  Error     MWUSSetup          The process ocsetup "WSSEE" /quiet /norestart returned error: 0x643 (Error 0x80070643: Fatal error during installation.)
2012-03-15 11:55:37  Error     MWUSSetup          ExecCmd failed (Error 0x80070643: Fatal error during installation.)
2012-03-15 11:55:37  Error     MWUSSetup          Install Windows Internal database: Failed to execute "ocsetup "WSSEE" /quiet /norestart" (Error 0x80070643: Fatal error during installation.)
2012-03-15 11:55:37  Error     MWUSSetup          CInstallDriver::PerformSetup: Installation of wYukon failed (Error 0x80070643: Fatal error during installation.)
2012-03-15 11:55:37  Error     MWUSSetup          CSetupDriver::LaunchSetup: Setup failed (Error 0x80070643: Fatal error during installation.)
2012-03-15 11:55:40  Error     MWUSSetup          DoInstall: Wsus setup failed (Error 0x80070643: Fatal error during installation.)


I have searched all over the internet looking for a way to reinstall WSUS but I am making no progress at this point.

How do I get WSUS installed again? I am assuming I will need to manually remove what is left of windows internal database and WSUS but I have found nothing explaining what reg keys to modify and what files to remove.

Thanks,

Justin
JustinGSEIWIAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
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.

Michael PfisterCommented:
Did you try to install via "Add roles" or via the Stand-Alone installer?
0
Michael PfisterCommented:
Try to install the databse in a separate step, see

http://www.experts-exchange.com/ITPro/IT_Administration/Q_24911652.html
0
JustinGSEIWIAuthor Commented:
I have tried installing via a stand alone installer. It is worth noting that my WSUS install used internal database. I removed WSUS and the internal database and now I want to reinstall WSUS and use SQL. SQL is already installed and functioning on the server. However, when I try to do a stand alone installer, where it says "use an existing database server on this computer" is grayed out and I am only able to select windows internal database option. I am not sure why this is the case.

When I go to add server role, WSUS is checked as if it is already installed. However, I have manually removed it and I know it is not installed. I go to remove server role and WSUS is not an option to remove. If I check server features, internal database is removed. The error log I posted above is from trying to install using windows internal database since that is my only option.

How can I get the WSUS installer to allow me to use the SQL database?

I checked the link above but I am logged in as administrator of the domain. Permissions should not be an issue. I also checked other links from the link above and had no luck.

Thanks,

Justin
0
Acronis Data Cloud 7.8 Enhances Cyber Protection

A closer look at five essential enhancements that benefit end-users and help MSPs take their cloud data protection business further.

Michael PfisterCommented:
Did you add the administrators group to the system admins of the SQL server?

Which SQL version did you install? Mixed or Windows Authentication?

Check if you have a reg key named
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Update Services\Server\Setup
If yes, back it up and delete the entire key.


Check the installing users temp folder (%TEMP%) for additional log files
0
JustinGSEIWIAuthor Commented:
The domain administrator is added as a sysadmin for SQL server. I am using windows authentication for the SQL server.

I found the reg key you mentioned and deleted it. Once I did that, the role was removed from server manager and it was an option to install again.

I tried to add the role again and I received the following error.

"The update could not be found. There may be a network connection issue."

Since I received the above error, I thought I would try to install WSUS SP 2 manually. When I do, I am still unable to choose the local SQL instance to place the database in. It is grayed out.

So I choose to continue by installing internal database since it is my only option and it still fails. The following was in the log.


2012-03-30 09:10:35  Error     MWUSSetup          DoInstall: Wsus setup failed (Error 0x80070642: User cancelled installation.)
2012-03-30 09:46:23  Success   MWUSSetup          Validating pre-requisites...
2012-03-30 09:46:23  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-03-30 09:46:23  Error     MWUSSetup          WSUS is outdated. But this will not block setup (Error 0x00000000: The operation completed successfully.)
2012-03-30 09:46:32  Success   MWUSSetup          ReportViewer is not installed on this machine
2012-03-30 09:46:32  Success   MWUSSetup          ReportViewer is not installed on this machine
2012-03-30 09:47:25  Success   MWUSSetup          Initializing installation details
2012-03-30 09:47:25  Success   MWUSSetup          Skipping Asp.Net install since not running on win2k3...
2012-03-30 09:47:25  Success   MWUSSetup          Installing wYukon using ocsetup
2012-03-30 09:47:25  Success   MWUSSetup          Installing Windows Internal database using ocsetup with command line as "ocsetup "WSSEE" /quiet /norestart"
2012-03-30 09:47:39  Error     MWUSSetup          The process ocsetup "WSSEE" /quiet /norestart returned error: 0x643 (Error 0x80070643: Fatal error during installation.)
2012-03-30 09:47:39  Error     MWUSSetup          ExecCmd failed (Error 0x80070643: Fatal error during installation.)
2012-03-30 09:47:39  Error     MWUSSetup          Install Windows Internal database: Failed to execute "ocsetup "WSSEE" /quiet /norestart" (Error 0x80070643: Fatal error during installation.)
2012-03-30 09:47:39  Error     MWUSSetup          CInstallDriver::PerformSetup: Installation of wYukon failed (Error 0x80070643: Fatal error during installation.)
2012-03-30 09:47:39  Error     MWUSSetup          CSetupDriver::LaunchSetup: Setup failed (Error 0x80070643: Fatal error during installation.)

I do have the SQL SP4 update which tried to install via automatic updates and failed. I am wondering if this failed update is making it so I cannot choose SQL during WSUS setup?

I can't try to force this update to install until Monday or Tuesday evening. So we will not know until then and only if I am successful with getting the update to install.

Also, once I get this working, should I reuse the database that was used with the previous install or should I create a new one?

Thanks,

Justin
0
Michael PfisterCommented:
You can keep the downloaded patches but drop the database.

The standalone installer should have written some logs for the internal database (Yukon*.log or WSUSYukon*.log) to the installation users %temp% folder.
0
JustinGSEIWIAuthor Commented:
I now have WSUS working.

I think it was a combination of a couple of things. Firstly, mpfister suggested to delete the reg key and that removed the role from the server manager.

Then I manually went into the C:\Windows\SoftwareDistribution\Download directory and found the update that automatic updates was trying to install for SQL 2005. The update was SP4. I am not sure if this helped or not. Once I successfully got SQL 2005 to SP4, I tred running the WSUS install manually again.

When I got to the point where the WSUS install asked me where to place the database, I selected to put it on a remote server and typed (local) for the server name. This successfully connected and then the WSUS install eventually finished.

WSUS is now running on my server.

Thanks,

Justin
0

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
JustinGSEIWIAuthor Commented:
I eventually was able to get WSUS manually installed by selecting to install the database on a remote server and then typing in (local) to use the local SQL instance.
0
PorcupineCommented:
I had the same problem and it seems I solved it (at least in my scenario it worked).
1) Find this tree in registry:
HKLM\SOFTWARE\Microsoft\Update Services\Server\Setup
2) Change value of this key "wYukonInstalled" from 1 to 0
3) Try to install WSUS 3.0 (it will perform ininstall first and install at second run)
0
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
Windows Server 2008

From novice to tech pro — start learning today.