This article was previously published under Q234915
This article has been archived. It is offered "as is" and will no longer be updated.
IMPORTANT: This article contains information about modifying the registry. Before you modify the registry, make sure to back it up and make sure that you understand how to restore the registry if a problem occurs. For information about how to back up, restore, and edit the registry, click the following article number to view the article in the Microsoft Knowledge Base:
256986 Description of the Microsoft Windows Registry
BUG #: 55572(SQLBUG_70)
If you install the Microsoft Data Engine (MSDE) from the Office 2000 Developer (MOD) and then try to upgrade to Standard or Desktop SQL Server, the setup fails with the following error:
You cannot install a version which is older (7.00.623) than the version on your machine (7.00.677). Uninstall the older version.
Office 2000 Developer shipped an MSDE build where "Select @@version" will report 7.00.623 but the following registry key will show 7.00.677:
WARNING: If you use Registry Editor incorrectly, you may cause serious problems that may require you to reinstall your operating system. Microsoft cannot guarantee that you can solve problems that result from using Registry Editor incorrectly. Use Registry Editor at your own risk.
Start the Registry Editor (Regedt32.exe).
Locate the CurrentVersion value under the following key in the registry:
Microsoft has confirmed this to be a problem in SQL Server 7.0. This problem has been corrected in U.S. Service Pack 1 for Microsoft SQL Server 7.0. For more information, click the following article number to view the article in the Microsoft Knowledge Base:
232570INF: How to Obtain Service Pack 1 for Microsoft SQL Server 7.0 and Microsoft Data Engine (MSDE) 1.0
For more information, contact your primary support provider.
Applying Service Pack 1 to SQL Server updates the CurrentVersion registry key back to 7.00.623 if the MSDE version was detected as 7.00.677. After installing SP1, this registry key will contain 7.00.623: