resourcepc
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\up date services\server\setup\Wmsd eInstalled from 0 to 1
HKLM\software\microsoft\up date services\server\setup\SqlS erverName 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::PerformSet up: 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.)
HKLM\software\microsoft\up
HKLM\software\microsoft\up
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::PerformSet
2007-12-11 11:05:21 Error MWUSSetup CSetupDriver::LaunchSetup:
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.)
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Right, but then I'll lose all my info in the old database.
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?
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.
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.
ASKER
So what is the point of retaining the old database then?
There isn't really one.
ASKER
Thanks, I ended up installing from scratch like you suggested and used a remote SQL 2005 SP1 database.
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.