asked on

Upgrading WSUS from 2.0 to 3.0 with remote SQL 2000 database

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

Netman66

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.

resourcepc

ASKER

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.

ASKER CERTIFIED SOLUTION

Netman66

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

resourcepc

ASKER

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

resourcepc

ASKER

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?

Netman66

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.

resourcepc

ASKER

So what is the point of retaining the old database then?

Netman66

There isn't really one.

resourcepc

ASKER

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