|
How do I upgrade from Win2000/IIS5/MSDE to WIn2003/IIS6/WMSDE? |
| The primary complication comes in the upgrade from IIS5 to IIS6. It's
preferable to avoid that upgrade path if at all possible. You also have the
limitation that WMSDE cannot be installed on Windows 2000. A key question is whether you intend to do the upgrade on the same box, or use a new Windows Server 2003 system. Using a new box makes the process immensely easier, but I concede that's not always an option. If you do have a new box, see the WSUS Wiki for methods of migrating the old server to a new server. However, if you're doing this on the same box, that's where it gets tricky. This is how I'd do it: 1. Make copies of the SUSDB*.* files in the MSDE2000 installation. 2. Uninstall WSUS from Windows 2000, retaining only content. 3. Uninstall MSDE2000 from Windows 2000 if the WSUS uninstall did not completely remove it. 4a. Upgrade to Windows Server 2003. Note: If the content is on a non-system logical volume, then you can also do a fresh install of Windows Server 2003, rather than the upgrade, because the WSUS data will be preserved on that non-system volume. As a matter of practice, I always prefer to do a fresh install whenever possible. 4b. If you do the upgrade, you'll also need to manually configure IIS6 out of IIS5 mode. If you do a fresh install, you'll need to install IIS6, and it will be properly configured at installation. 5. Install Windows Server 2003 SP1 (which includes BITS and the .NET Framework SP1). 6. Reinstall WSUS w/WMSDE; let WSUS create a new, empty WSUS database. 7. Shutdown the Update Services service. 8. Use sp_detach_db to disconnect the empty SUSDB from WMSDE. You can accomplish this using MS Query, SQL Query, SQL Enterprise Manager, or osql, depending on what tools you have available to you. The SQL tools must be installed on the WSUS server, as WMSDE does not support network-based administration. 9. Rename the newly installed susdb.mdf and susdb_log.ldf, or move them to another folder. 10. Copy the original susdb.mdf and susdb_log.ldf into the ~\MSSQL$WSUS folder. 11. Use sp_attach_db to connect the original MSDE-based SUSDB database files. |