How to update MSDE with SP4 to SQL Server 2005 Express

How to update MSDE with SP4 to SQL Server 2005 Express

Procedure Steps

1) Ensure that Service Pack 4 for MSDE is installed. This can be verified by performing a file search for the sqlservr.exe file on the machine running the database, then right-clicking the file, selecting Properties, then clicking the Version tab.

The Service Pack installed can be determined by the version numbers below.

SQL Server 2000 SP1 = 2000.80.384.0
SQL Server 2000 SP2 = 2000.80.534.0
SQL Server 2000 SP3 = 2000.80.760.0
SQL Server 2000 SP3a = 2000.80.760.0
SQL Server 2000 SP4 = 2000.8.00.2039

2) Insert the OnGuard Supplemental Materials disc into the machine's optical drive.

3) Open My Computer, right-click the optical drive containing the Supplemental Materials disc, and choose Explore.

4) Browse to the Prerequisite Software folder, then the Microsoft SQL Server 2005 Express folder.

5) Launch the ExpressUpgrade.bat batch file to begin the upgrade process from MSDE to SQL Server 2005 Express.

Applies To

OnGuard 2008 (6.0.148)
OnGuard 2006 Technology Update (5.12.110)
OnGuard 2006 (5.12.012)
SQL Server 2005 Express
Windows XP
Windows Server 2003

Additional Information

None