We help IT Professionals succeed at work.

Upgrading WSUS from 2.0 to 3.0 with remote SQL 2000 database

451 Views
Last Modified: 2013-12-04
I currently have WSUS 2.0 on a W2k3 SP1 server with a remote SQL database on a SQL 2000 server.  I have a separate server running SQL 2005 SP1.  What is correct upgrade path to accomplish this?  I've tried creating a new database on the SQL 2005 box and then restoring a backup from the 2000 server with backward compatability enabled.  I've tried detaching from the old and attaching to the new.  Each time, I changed the following registry keys before I ran the wsus setup.  

HKLM\software\microsoft\update services\server\setup\WmsdeInstalled from 0 to 1
HKLM\software\microsoft\update services\server\setup\SqlServerName from the old server to the new one.


2007-12-11 11:05:21  Success   MWUSSetup          Creating database backup...
2007-12-11 11:05:21  Success   MWUSSetup          The SQL server instance is remote. No database backup will be created
2007-12-11 11:05:21  Success   MWUSSetup          Uninstalling the selfupate tree...
2007-12-11 11:05:21  Error     MWUSSetup          RemoveSelfupdate20: SelfUpdateTree Uninstall Failed (Error 0x80070645: This action is only valid for products that are currently installed.)
2007-12-11 11:05:21  Error     MWUSSetup          CUpgradeDriver::PerformSetup: Uninstall of selfupdate failed (Error 0x80070645: This action is only valid for products that are currently installed.)
2007-12-11 11:05:21  Error     MWUSSetup          CSetupDriver::LaunchSetup: Setup failed (Error 0x80070645: This action is only valid for products that are currently installed.)
2007-12-11 11:05:24  Error     MWUSSetup          DoInstall: Wsus setup failed (Error 0x80070645: This action is only valid for products that are currently installed.)

Comment
Watch Question

CERTIFIED EXPERT
Top Expert 2005

Commented:
Here's what I would try.

1)  Make sure you add the admin account you're using to the SQL Manager as a DB Admin.
2)  Make sure your prerequisites are met on the server to host WSUS 3.0.
3)  Run the WSUS setup with the switch "/g" - this will upgrade the 2.0 install.

You can move the DB from 2000 to 2005 after.

There is a good deal of this info in the Release notes and deployment guides.

Author

Commented:
I cannot upgrade the remote SQL 2000 server to 2005 SP1 and the WSUS setup will not allow me to proceed until I do this.
CERTIFIED EXPERT
Top Expert 2005
Commented:
This one is on us!
(Get your first solution completely free - no credit card required)
UNLOCK SOLUTION

Author

Commented:
Right, but then I'll lose all my info in the old database.

Author

Commented:
If I did a fresh install with a fresh database, will WSUS be able to tell what updates that clients already have installed and need?
CERTIFIED EXPERT
Top Expert 2005

Commented:
Yes.

The new installation will pick up the clients and whatever they require.  It will take some time to download the content again, but it should happen over night.  Maybe a good time to do it is tomorrow and allow the sync all weekend.

Author

Commented:
So what is the point of retaining the old database then?
CERTIFIED EXPERT
Top Expert 2005

Commented:
There isn't really one.

Author

Commented:
Thanks, I ended up installing from scratch like you suggested and used a remote SQL 2005 SP1 database.

Gain unlimited access to on-demand training courses with an Experts Exchange subscription.

Get Access
Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant
Empower Your Career
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE

Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

  • Troubleshooting
  • Research
  • Professional Opinions
Unlock the solution to this question.
Join our community and discover your potential

Experts Exchange is the only place where you can interact directly with leading experts in the technology field. Become a member today and access the collective knowledge of thousands of technology experts.

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.