PRB: Installing SQL Server 7.0 Fails If SQL Server 2000 Is Already Installed (278612)
The information in this article applies to:
- Microsoft SQL Server 2000 (all editions)
- Microsoft SQL Server 7.0
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.
| Modification Type: | Major | Last Reviewed: | 10/16/2003 |
|---|
| Keywords: | kbBug kbpending kbprb KB278612 |
|---|
|