Microsoft KB Archive/278612

= PRB: Installing SQL Server 7.0 Fails If SQL Server 2000 Is Already Installed =

Article ID: 278612

Article Last Modified on 10/16/2003

-

APPLIES TO


 * Microsoft SQL Server 2000 Standard Edition
 * Microsoft SQL Server 7.0 Standard Edition

-



This article was previously published under Q278612





SYMPTOMS
When trying to install SQL Server 7.0 on a computer that already has a default instance of SQL Server 2000, SQL Server 7.0 Setup may display the following warning message:

Setup has detected a previous 6.x version of SQL Server but cannot obtain the sort order and character set from the 6.x SQL Server service. If you continue with setup it will install a sort order and character set which may be different than the previous 6.x version. Should you choose to convert your existing data at a later time to the newer version successful conversion cannot be guaranteed. Do you wish to continue?

If you continue, Setup fails because SQL Server 7.0 Setup mistakenly treats SQL Server 2000 as SQL Server 6.5.



CAUSE
SQL Server 7.0 can only be installed as a default instance. If SQL Server 2000 is already installed as a default instance, the SQL Server 7.0 setup assumes that it is an older version.



WORKAROUND
To recover from this situation, perform the registry rebuild through SQL Server 2000 Setup.



STATUS
This behavior is by design.



MORE INFORMATION
If SQL Server 7.0 setup fails, you cannot start either SQL Server 7.0 or SQL Server 2000. Note that the above warning message would not be displayed when you install MSDE.

If you want to have both SQL Server 7.0 and SQL Server 2000 on the same computer, SQL Server 7.0 must be installed first as a default instance before SQL Server 2000 is installed. If SQL Server 2000 is already installed and you want to install SQL Server 7.0, you must uninstall SQL Server 2000 before you can install SQL Server 7.0.

Additional query words: upgrade install default named instance version

Keywords: kbbug kbprb kbpending KB278612

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.