Working with Multiple Versions of SQL Server
Microsoft SQL Server 2005 supports multiple instances of the Database Engine, Microsoft SQL Server 2005 Analysis Services (SSAS), and Microsoft SQL Server 2005 Reporting Services (SSRS) on the same computer. You can upgrade previous versions of SQL Server, or install SQL Server 2005 on a computer where previous SQL Server versions are already installed.
You can also run a SQL Server 2000 failover cluster instance in a side-by-side configuration with a SQL Server 2005 failover cluster instance. For more information about side-by-side failover cluster instances of SQL Server, see The Microsoft SQL Server support policy for Microsoft Clustering.
Using SQL Server 2005 Side-By-Side with Previous Versions of SQL Server
You can install SQL Server 2005 on a computer already running instances of a previous SQL Server version. If a default instance already exists on the computer, SQL Server 2005 will be installed as a named instance.
Important For SQL Server 2005 installations in side-by-side configurations with previous versions of SQL Server, SQL Server 2005 services must use accounts found only in the global domains group. Additionally, accounts utlized by SQL Server 2005 services must not appear in the local Administrators group. Failure to comply with this guideline will result in unexpected security behavior.
Side-by-side support is as follows:
| Side-by-side support | SQL Server 2000 (32-bit) | SQL Server 2000 (64-bit) | SQL Server 2005 (32-bit) | SQL Server 2005 (64-bit) IA64 | SQL Server 2005 (64-bit) X64 |
|---|---|---|---|---|---|
SQL Server 7.0 |
Yes |
No |
Yes |
No |
No |
SQL Server 2000 (32-bit) |
Yes |
No |
Yes |
No1 |
Yes |
SQL Server 2000 (64-bit) |
No |
Yes |
No |
Yes |
No |
SQL Server 2005 (32-bit) |
Yes |
No |
Yes |
No |
Yes |
SQL Server 2005 (64-bit) IA64 |
No |
Yes |
No |
Yes |
No |
SQL Server 2005 (64-bit) X64 |
Yes |
No |
Yes |
No |
Yes |
1The 32-bit editions of SQL Server are supported in WOW64 only on the X64 versions of 64-bit operating systems. The 32-bit editions of SQL Server are not supported in WOW64 on the IA64 versions of 64-bit operating systems.
See Also
Tasks
How to: Install SQL Server 2005 (Setup)
Reference
Hardware and Software Requirements for Installing SQL Server 2005
Concepts
Using Upgrade Advisor to Prepare for Upgrades
Other Resources
Upgrading to SQL Server 2005
Backward Compatibility
Help and Information
Getting SQL Server 2005 Assistance
Change History
| Release | History |
|---|---|
15 September 2007 |
|
12 December 2006 |
|