Installation Options
SQL Server Express users: click Installation Options (SQL Server Express) for information that is specific to SQL Server Express Setup.
Use the Installation Options page of the Microsoft SQL Server Installation Wizard to view maintenance and upgrade options for existing SQL Server instances and components. This page appears when components selected for the current installation are already part of an existing installation with the same instance name.
Options
Maintenance and upgrade options are described in the following sections.
Maintenance
SQL Server 2005 instance maintenance and feature maintenance, including failover clusters, is provided through Add or Remove Programs in Control Panel.
Upgrade
The following upgrade scenarios are supported in this release of SQL Server 2005:
| Upgrade from | Supported Upgrade Paths |
|---|---|
SQL Server 7.0 Enterprise Edition SP4 |
SQL Server 2005 Enterprise Edition |
SQL Server 7.0 Developer Edition SP4 |
SQL Server 2005 Enterprise Edition SQL Server 2005 Developer Edition |
SQL Server 7.0 Standard Edition SP4 |
SQL Server 2005 Standard Edition SQL Server 2005 Enterprise Edition |
SQL Server 7.0 Desktop Edition SP4 |
SQL Server 2005 Standard Edition SQL Server 2005 Workgroup Edition |
SQL Server 7.0 Evaluation Edition SP4 |
Upgrades not supported |
SQL Server Desktop Engine (MSDE) 7.0 SP4 |
SQL Server 2005 Express Edition |
SQL Server 2000 Enterprise Edition SP3 or later1 |
SQL Server 2005 Enterprise Edition |
SQL Server 2000 Developer Edition SP3 or later1 |
SQL Server 2005 Developer Edition |
SQL Server 2000 Standard Edition SP3 or later1 |
SQL Server 2005 Enterprise Edition SQL Server 2005 Developer Edition SQL Server 2005 Standard Edition |
SQL Server 2000 Workgroup Edition SP3 or later1 |
SQL Server 2005 Enterprise Edition SQL Server 2005 Developer Edition SQL Server 2005 Standard Edition SQL Server 2005 Workgroup Edition |
SQL Server 2000 Personal Edition SP3 or later1 |
SQL Server 2005 Standard Edition SQL Server 2005 Workgroup Edition SQL Server 2005 Express Edition SQL Server 2005 Express Edition with Advanced Services |
SQL Server 2000 Evaluation Edition SP3 or later1 |
SQL Server 2005 Evaluation Edition |
SQL Server Desktop Engine (MSDE) 2000 SP3 or later1 |
SQL Server 2005 Workgroup Edition SQL Server 2005 Express Edition SQL Server 2005 Express Edition with Advanced Services |
SQL Server 2000 IA64 (64-bit) Enterprise Edition |
SQL Server 2005 IA64 (64-bit) Enterprise Edition |
SQL Server 2000 IA64 (64-bit) Developer Edition |
SQL Server 2005 IA64 (64-bit) Enterprise Edition SQL Server 2005 IA64 (64-bit) Developer Edition |
SQL Server 2005 Developer Edition 1 |
SQL Server 2005 Enterprise Edition SQL Server 2005 Standard Edition SQL Server 2005 Workgroup Edition |
SQL Server 2005 Standard Edition1 |
SQL Server 2005 Enterprise Edition SQL Server 2005 Developer Edition |
SQL Server 2005 Workgroup Edition1 |
SQL Server 2005 Enterprise Edition SQL Server 2005 Developer Edition SQL Server 2005 Standard Edition |
SQL Server 2005 Evaluation Edition1 |
SQL Server 2005 Enterprise Edition SQL Server 2005 Developer Edition SQL Server 2005 Standard Edition SQL Server 2005 Workgroup Edition SQL Server 2005 Express Edition |
SQL Server 2005 Express Edition 1 |
SQL Server 2005 Enterprise Edition SQL Server 2005 Developer Edition SQL Server 2005 Standard Edition SQL Server 2005 Workgroup Edition SQL Server 2005 Express Edition with Advanced Services |
SQL Server 2005 IA64 (64-bit) Developer Edition |
SQL Server 2005 IA64 (64-bit) Enterprise Edition SQL Server 2005 IA64 (64-bit) Standard Edition |
SQL Server 2005 X64 (64-bit) Developer Edition |
SQL Server 2005 X64 (64-bit) Enterprise Edition SQL Server 2005 X64 (64-bit) Standard Edition |
SQL Server 2005 IA64 (64-bit) Standard Edition |
SQL Server 2005 IA64 (64-bit) Enterprise Edition SQL Server 2005 IA64 (64-bit) Developer Edition |
SQL Server 2005 X64 (64-bit) Standard Edition |
SQL Server 2005 X64 (64-bit) Enterprise Edition SQL Server 2005 X64 (64-bit) Developer Edition |
SQL Server 2005 IA64 (64-bit) Evaluation Edition |
SQL Server 2005 IA64 (64-bit) Enterprise Edition SQL Server 2005 IA64 (64-bit) Developer Edition SQL Server 2005 IA64 (64-bit) Standard Edition |
SQL Server 2005 X64 (64-bit) Evaluation Edition |
SQL Server 2005 X64 (64-bit) Enterprise Edition SQL Server 2005 X64 (64-bit) Developer Edition SQL Server 2005 X64 (64-bit) Standard Edition |
1This SQL Server edition can be upgraded to SQL Server 2005 on the 32-bit subsystem (WOW64) of a 64-bit server.
Upgrade Notes
- After upgrading to SQL Server 2005 from another edition of SQL Server 2005, you must re-apply any hotfix or service pack updates to the upgraded SQL Server instance.
- Cross-version instances on SQL Server 2005 are not supported. Version numbers of the Database Engine, Analysis Services, and Reporting Services components must be the same within an instance of SQL Server 2005.
- Before upgrading to SQL Server 2005, enable Windows Authentication for SQL Server Agent and verify that the SQL Server Agent service account is a member of the SQL Server sysadmin group.
- Before upgrading from one edition of SQL Server 2005 to another, verify that the functionality you are currently using is supported in the edition to which you are upgrading. For more information, see the section for your components in Features Supported by the Editions of SQL Server 2005.
- To upgrade a SQL Server instance to a SQL Server 2005 failover cluster, the instance being upgraded must be a failover cluster. To upgrade a stand-alone instance of SQL Server to a SQL Server 2005 failover cluster, install a new SQL Server 2005 failover cluster and then migrate user databases from the stand-alone instance using the Copy Database Wizard. For more information on upgrade, see How to: Upgrade to a SQL Server 2005 Failover Cluster Instance (Setup). For more information on database migration, see Using the Copy Database Wizard.
Adding Components to an Instance of SQL Server 2005
You can add components to an existing installation of SQL Server 2005 from Add or Remove Programs in Control Panel and then select the instance of SQL Server to which you want to add or remove features. For more information, see How to: Change Components in an Existing Instance of SQL Server 2005 (Setup).
Cross-Language Support
For upgrades:
- English-language versions of SQL Server can be upgraded to any localized version of SQL Server 2005.
- Localized versions of SQL Server can be upgraded to localized versions of SQL Server 2005 of the same language.
- Localized version of SQL Server cannot be upgraded to the English-language version of SQL Server 2005.
- Localized versions of SQL Server cannot be upgraded to localized SQL Server 2005 versions of a different localized language.
Additional cross-language support:
- The English-language version of SQL Server 2005 is supported on all localized versions of supported operating systems.
- Localized versions of SQL Server 2005 are supported on localized operating systems that are the same language as the localized SQL Server version.
- Localized versions of SQL Server 2005 are also supported on English-language versions of supported operating systems through the use of Windows Multilingual User Interface Pack (MUI) settings. However, you must verify certain operating system settings before installing a localized version of SQL Server 2005 on a server that is running an English-language operating system with a non-English MUI setting. You must verify that the following operating system settings match the language of the localized SQL Server to be installed:
- The operating system user interface setting
- The operating system user locale setting
- The system locale setting
If these operating system settings do not match the language of the localized SQL Server, then you must correctly set these operating system settings as described in How to: Change Operating System Settings to Support Localized Versions.