Issue
Steps to upgrade MSDE SP3a to SP4
Environment
SQL Server Service Pack
Cause
Upgrade the current Service Pack to the latest and update Service Pack 4
Resolution
If you have an existing Continuum db, get a backup first.
- Download file SQL2000.MSDE-KB884525-SP4-x86-ENU.EXE from Microsoft’s web site.
- Copy the file to a new folder on a hard drive called C:\MSDESp4
- Run the .exe to extract the files and selected this new folder by the browse button
- Open a DOS prompt (Start>Run>cmd)
- Use the CD command to navigate to the location where the files were extracted (C:\MSDESP4\MSDE)
- Execute the following command to install SP4
- C:\MSDESP4\MSDE>setup /upgradesp sqlrun blanksapwd=1
*Note: If you have a password on the sa account then use SAPWD="yourpassword" instead
For more information and additional options see the following link:
http://download.microsoft.com/download/1/B/D/1BDF5B78-584E-4DE0-B36F-C44E06B0D2A3/ReadmeSql2k32desks...