FIX: Upgrade to SQL Server Fails When MSDE Installed from MOD

ID: Q234915

The information in this article applies to:

Microsoft SQL Server version 7.0
Microsoft Data Engine (MSDE), version 1.0
Microsoft Office 2000 Developer

IMPORTANT: This article contains information about editing the registry. Before you edit the registry, make sure you understand how to restore it if a problem occurs. For information about how to do this, view the "Restoring the Registry" Help topic in Regedit.exe or the "Restoring a Registry Key" Help topic in Regedt32.exe.

BUG #: 55572(SQLBUG_70)

SYMPTOMS

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.

CAUSE

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:

HKEY_LOCAL_MACHINE/Software/Microsoft/MSSQLServer/MSSQLServer/CurrentVersion/CurrentVersion

WORKAROUND

WARNING: Using Registry Editor incorrectly can cause serious problems that may require you to reinstall your operating system. Microsoft cannot guarantee that problems resulting from the incorrect use of Registry Editor can be solved. Use Registry Editor at your own risk.

For information about how to edit the registry, view the "Changing Keys and Values" Help topic in Registry Editor (Regedit.exe) or the "Add and Delete Information in the Registry" and "Edit Registry Data" Help topics in Regedt32.exe. Note that you should back up the registry before you edit it. If you are running Windows NT, you should also update your Emergency Repair Disk (ERD).

Start the Registry Editor (Regedt32.exe).

Locate the CurrentVersion value under the following key in the registry:

  HKEY_LOCAL_MACHINE/Software/Microsoft/MSSQLServer/MSSQLServer/CurrentVersion

From the Edit menu, click Modify, enter 7.00.623, and then click OK.

Quit Registry Editor.

- OR -

If you have a Microsoft Visual Studio 6.0 product, uninstall this version of MSDE and install MSDE for Visual Studio. MSDE for Visual Studio is available from the following:

http://msdn.microsoft.com/vstudio/msde

STATUS

Microsoft has confirmed this to be a problem in SQL Server version 7.0. This problem has been corrected in U.S. Service Pack 1 for Microsoft SQL Server version 7.0. For information about downloading and installing the latest SQL Server Service Pack, see http://support.microsoft.com/support/sql/.

For more information, contact your primary support provider.

MORE INFORMATION

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:

HKEY_LOCAL_MACHINE/Software/Microsoft/MSSQLServer/MSSQLServer/CurrentVersion/CurrentVersion

In addition, this registry key will contain 7.00.699, which is the version number returned by the query "select @@version":

HKEY_LOCAL_MACHINE/Software/Microsoft/MSSQLServer/MSSQLServer/CurrentVersion/CSDVersion

For MSDE shipping with Access 2000 (with GUI setup) and Visual Studio 6.0 MSDE, the SQL Server version is 7.00.623 and the CurrentVersion registry key is correctly set to 7.00.623.

REFERENCES

For information on moving SQL Server 7.0 databases, see the following article in the Microsoft Knowledge Base:

Q224071 INF: Moving SQL Server 7.0 Databases to a New Location

Additional query words:

Keywords : kbDatabase kbbug7.00 kbSQLServ700bug kbSQLServ700sp1fix kbGrpVBDB kbMSDE100
Version : WINDOWS:1.0; winnt:7.0; :
Platform : WINDOWS winnt
Issue type : kbbug