This topic presents hardware and software requirements for installing SQL Server 2005, and instructions to view Setup documentation.

Hardware and Software Requirements (32-bit and 64-bit)

The following sections list the minimum hardware and software requirements for running Microsoft SQL Server 2005.

Note:
Requirements for running SQL Server 2005 on the 32-bit platform are different than requirements for the 64-bit platform.

Monitor

SQL Server graphical tools require VGA or higher resolution: at least 1,024x768 pixel resolution.

Pointing Device

A Microsoft mouse or compatible pointing device is required.

DVD Drive

A DVD drive is required for installation from DVD media.

Cluster Hardware Requirements

On 32-bit and 64-bit platforms, eight-node cluster installations (that is, the maximum number of nodes supported by Microsoft Windows Server 2003) are supported. For more information on high availability solutions, see the topics for "Configuring High Availability" and "Before Installing Failover Clustering" in SQL Server 2005 Books Online.

Network Software Requirements

Network software requirements for the 64-bit versions of SQL Server 2005 are the same as the requirements for the 32-bit versions. Windows Server 2003, Windows XP, Windows 2000, Windows 98, and Windows ME have built-in network software.

Note:
SQL Server 2005 does not support the Banyan VINES Sequenced Packet protocol (SPP), Multiprotocol, AppleTalk, or NWLink IPX/SPX network protocols. Clients previously connecting with these protocols must select a different protocol to connect to SQL Server 2005.

Stand-alone named and default instances support the following network protocols:

  • Shared memory

  • Named pipes

  • TCP/IP

  • VIA

Note   Shared memory is not supported on failover clusters.

New type of endpoint

SQL Server 2005 introduces a new concept for SQL Server connections: the connection is represented on the server end by the concept of a Transact-SQL endpoint. Permissions can be granted, revoked, and denied for Transact-SQL endpoints. By default, all users have permissions to access an endpoint unless the permissions are denied or revoked by a member of the sysadmin group or by the endpoint owner. The GRANT, REVOKE, and DENY ENDPOINT syntax uses an endpoint ID that the admin must get from the endpoint's catalog view.

Transact-SQL endpoints created by SQL Server Setup are as follows:

  • TSQL Local machine

  • TSQL Named Pipes

  • TSQL Default TCP

  • TSQL Default VIA

For more information on managing Transact-SQL endpoints, see topic for "Net-Libraries and Network Protocols" in SQL Server 2005 Books Online.

Internet Requirements

Internet requirements for both the 32-bit and 64-bit versions of SQL Server 2005 are the same. The following table lists the Internet requirements for SQL Server 2005.

Component Requirement

Internet software1

Microsoft Internet Explorer 6.0 SP1 or later is required for all installations of SQL Server 2005, as it is required for Microsoft Management Console (MMC) and HTML Help. A minimal installation of Internet Explorer is sufficient, and Internet Explorer is not required to be the default browser.

However, if you are installing client components only and you will not connect to a server that requires encryption, Internet Explorer 4.01 with Service Pack 2 is sufficient.

Internet Information Services (IIS)

IIS 5.0 or higher is required for Microsoft SQL Server 2005 Reporting Services (SSRS) installations.

For more information on how to install IIS, see the topic for "How to Install Microsoft Internet Information Services (IIS)" in SQL Server 2005 Books Online.

1Microsoft Internet Explorer 6.0 SP1 or later is required for SQL Server Management Studio, Business Intelligence Management Studio, and the Report Designer component of Reporting Services.

Software Requirements

SQL Server Setup requires Microsoft Windows Installer 3.0.

SQL Server Setup installs the following software components required by the product:

  • Microsoft Windows .NET Framework 2.0

Note:
You must remove any previous versions of the .NET Framework 2.0 before installing SQL Server 2005.

  • Microsoft SQL Server Native Client

  • Microsoft SQL Server Setup support files

Note:
SQL Server Express Edition does not install .NET Framework 2.0. Before installing Express Edition, you must download and install the .NET Framework 2.0 from this Microsoft Web site.

Each of these components is installed separately; only the Microsoft SQL Server Setup support files are automatically removed when you uninstall SQL Server 2005. For more information on uninstalling this release, see the topic for "How to: Uninstall an Existing Instance of SQL Server 2005 (Setup)" in SQL Server 2005 Books Online.

Note:
The .NET Framework 2.0 Software Development Kit (SDK) is not installed by SQL Server 2005. The SDK contains documentation, a C++ compiler, and other tools that are useful when using the .NET Framework for SQL Server development. You can download the .NET Framework SDK from this Microsoft Web site.

In addition to the required software components installed by Setup during the component update installation, the following SQL Server components have additional software dependencies:

  • Reporting Services has a dependency on MDAC 2.8 for systems running Windows 2000. You can download MDAC 2.8 from this Microsoft Web site.

  • SQLXML depends on MDAC 2.6 for systems running Windows 2000. Notification Services has a dependency on SQLXML, so MDAC 2.6 or higher is required to run Notification Services on Windows 2000. You can download MDAC 2.6 from this Microsoft Web site.

After installing required components, SQL Server Setup will verify that the computer where SQL Server will be installed also meets all of the other requirements for a successful installation. For more information, see the topic for "Check Parameters for the System Configuration Checker" in SQL Server 2005 Books Online.

SQL Server 2005 failover clusters require Microsoft Cluster Server (MSCS) on at least one node of your server cluster. MSCS is only supported if it is installed on a hardware configuration that has been tested for compatibility with the MSCS software. For more information, see the topic for "Before Installing Failover Clustering" in SQL Server 2005 Books Online.

Hardware and Software Requirements (32-bit only)

Hardware Requirements (32-bit)

This table shows hardware requirements for installing and running SQL Server 2005 on the 32-bit platform.

SQL Server 2005 (32-bit) Processor type1 Processor speed2 Memory (RAM)3

SQL Server 2005 Enterprise Edition4

SQL Server 2005 Developer Edition

SQL Server 2005 Standard Edition

Pentium III compatible processor or higher required

Minimum: 500 MHz

Recommended: 1 GHz or higher

Minimum: 512 MB

Recommended: 1 GB or more

Maximum: OS maximum

SQL Server 2005 Workgroup Edition

Pentium III compatible processor or higher required

Minimum: 500 MHz

Recommended: 1 GHz or higher

Minimum: 512 MB

Recommended: 1 GB or more

Maximum: 3 GB

SQL Server 2005 Express Edition

Pentium III compatible processor or higher required

Minimum: 500 MHz

Recommended: 1 GHz or higher

Minimum: 128 MB

Recommended: 512 MB or more

Maximum: 1 GB

1System Configuration Checker (SCC) will block Setup if the requirement for processor type is not met.

2SCC will warn the user but will not block Setup if the minimum or recommended processor speed check is not met. No warning will appear on multi-processor machines.

3SCC will warn the user but will not block Setup if the minimum or recommended RAM check is not met. Memory requirements are for this release only, and do not reflect additional memory requirements of the operating system. SCC verifies the memory available when Setup starts.

4SQL Server 2005 Evaluation Edition supports the same feature set as SQL Server 2005 Enterprise Edition.

Note:
SQL Server 2005 software works on the hardware certified for use with the Microsoft Windows operating system. For more information about hardware certified for use with the Windows operating system, see this Microsoft Web site: HYPERLINK "http://www.microsoft.com/whdc/hcl/default.mspx" Products Designed for Microsoft Windows - Windows Catalog and HCL.

Hard Disk Space Requirements (32-bit and 64-bit)

Actual hard disk space requirements depend on your system configuration and the applications and features you choose to install. The following table provides disk space requirements for SQL Server 2005 components.

Feature Disk space requirement

Database Engine and data files, Replication, and Full-text Search

150 MB

Analysis Services and data files

35 KB

Reporting Services and Report Manager

40 MB

Notification Services engine components, client components, and rules components

5 MB

Integration Services

9 MB

Client Components

12 MB

Management Tools

70 MB

Development Tools

20 MB

SQL Server Books Online and SQL Server Mobile Books Online

15 MB

Samples and sample databases

390 MB

Operating System Requirements (32-bit)

This table shows the operating systems that run the server software for each 32-bit version of SQL Server 2005.

  Enterprise Edition1 Developer Edition Standard Edition Workgroup Edition SQL Express Evaluation Edition

Windows 2000

No

No

No

No

No

No

Windows 2000 SP42 Professional Edition

No

Yes

Yes

Yes

Yes

Yes

Windows 2000 SP42 Server

Yes

Yes

Yes

Yes

Yes

Yes

Windows 2000 SP42 Advanced Server

Yes

Yes

Yes

Yes

Yes

Yes

Windows 2000 SP42 Datacenter Edition

Yes

Yes

Yes

Yes

Yes

Yes

Windows XP Embedded

No

No

No

No

No

No

Windows XP SP2 Home Edition

No

Yes

No

No

Yes

No

Windows XP SP2 Professional Edition

No

Yes

Yes

Yes

Yes

Yes

Windows XP SP2 Media Edition

No

Yes

Yes

Yes

Yes

Yes

Windows XP SP2 Tablet Edition

No

Yes

Yes

Yes

Yes

Yes

Windows XP 64-Bit Itanium Professional 2003

No

No

No

No

No

No

Windows XP X64 Professional 2003

No

No

No

No

No

No

Windows 2003

No

No

No

No

No

No

Windows 2003 Enterprise Edition

Yes

Yes

Yes

Yes

Yes

Yes

Windows 2003 Datacenter Edition

Yes

Yes

Yes

Yes

Yes

Yes

Windows 2003 Web Edition

No

No

No

No

Yes

No

Windows 2003 64-Bit Itanium Datacenter Edition

No

No

No

No

No

No

Windows 2003 64-Bit Itanium Enterprise Edition

No

No

No

No

No

No

Windows 2003 SP1 Server

Yes

Yes

Yes

Yes

Yes

Yes

Windows 2003 SP1 Enterprise Edition

Yes

Yes

Yes

Yes

Yes

Yes

Windows 2003 SP1 Datacenter Edition

Yes

Yes

Yes

Yes

Yes

Yes

Windows 2003 SP1 Web Edition

No

No

No

No

Yes

No

Windows Small Business Server 2003 SP1 Standard Edition

Yes

Yes

Yes

Yes

Yes

Yes

Windows Small Business Server 2003 SP1 Premium Edition

Yes

Yes

Yes

Yes

Yes

Yes

Windows 2003 SP1 64-Bit Itanium Datacenter Edition

No

No

No

No

No

No

Windows 2003 SP1 64-Bit Itanium Enterprise Edition

No

No

No

No

No

No

Windows 2003 SP1 64-Bit X64 Standard Edition

WOW643

WOW643

WOW643

WOW643

WOW643

WOW643

Windows 2003 SP1 64-Bit X64 Datacenter Edition

WOW643

WOW643

WOW643

WOW643

WOW643

WOW643

Windows 2003 SP1 64-Bit X64 Enterprise Edition

WOW643

WOW643

WOW643

WOW643

WOW643

WOW643

Virtual Machine

No

No

No

No

No

No

Virtual PC

Yes

Yes

Yes

Yes

Yes

Yes

Virtual Server

Yes

Yes

Yes

Yes

Yes

Yes

1SQL Server 2005 Evaluation Edition supports the same feature set as SQL Server 2005 Enterprise Edition, but Enterprise Edition is not supported on all of the operating systems that support Evaluation Edition.

2You can download Windows 2000 SP4 from this Microsoft Web site.

3These editions of SQL Server 2005 can be installed to the Windows on Windows (WOW64) 32-bit subsystem of a 64-bit server.

The following limitations or issues affect installations on supported operating systems:

  • Native Web Service (SOAP/HTTP) support is only available for instances of SQL Server 2005 running on Windows Server 2003.

  • Individual topics in Microsoft SQL Server 2005 Integration Services (SSIS) programming, Analysis Management Objects (AMO), and ADOMD.NET documentation may indicate support for earlier versions of Windows, such as Windows 98, Windows ME, or Windows NT 4.0. However, for this release, these three programming interfaces are only supported on Windows XP, Windows 2000, and Windows Server 2003.

  • SQL Server 2005 failover clusters require Microsoft Cluster Server (MSCS) on at least one node of your server cluster. MSCS is only supported if it is installed on a hardware configuration that has been tested for compatibility with the MSCS software. For more information, see the topic for "Before Installing Failover Clustering" in SQL Server 2005 Books Online.

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.

For specific information on supported upgrade paths, see the topic for "Version and Edition Upgrades" in SQL Server 2005 Books Online.

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 the topic for "How to: Change Operating System Settings to Support Localized Versions" in SQL Server 2005 Books Online.

Supported Clients (32-bit)

SQL Server 2005 32-bit client components can be installed on Windows 2000 Professional SP3 or later.

Note:
This release supports Tabular Data Stream (TDS) 4.2 client connectivity through legacy MDAC/DB-Library, not by using new SQL Server 2005 features.

Hardware and Software Requirements (64-bit only)

Hardware Requirements (64-bit)

This table shows hardware requirements for installing and running SQL Server 2005 on the 64-bit platform.

SQL Server 2005 (64-bit) Processor type1 Processor speed2 Memory (RAM)3

SQL Server 2005 Enterprise Edition4

SQL Server 2005 Developer Edition

SQL Server 2005 Standard Edition

IA64 minimum: Itanium processor or higher

X64 minimum: AMD Opteron, AMD Athlon 64, Intel Xenon with Intel EM64T support, Intel Pentium IV with EM64T support

IA64 minimum: 733 MHz

IA64 recommended: 733 MHz or more

X64 minimum: 1 GHz

X64 recommended: 1 GHz or more

IA64 minimum: 512 MB

IA64 recommended: 1 GB or more

IA64 maximum: 32 TB

X64 minimum:512 MB

X64 recommended: 1 GB or more

X64 maximum: 32 TB

1System Configuration Checker (SCC) will block Setup if the processor type requirement is not met.

2SCC will warn the user but will not block Setup if the minimum or recommended processor speed check is not met.

3SCC will warn the user but will not block Setup if the minimum or recommended RAM check is not met. Memory requirements are for this release only, and do not reflect additional memory requirements of the operating system. SCC verifies the memory available when Setup starts.

4SQL Server 2005 Evaluation Edition supports the same feature set as SQL Server 2005 Enterprise Edition.

Note:
SQL Server 2005 software works on the hardware certified for use with the Microsoft Windows operating system. For more information about hardware certified for use with the Windows operating system, see this Microsoft Web site: Products Designed for Microsoft Windows - Windows Catalog and HCL. For information on installing a high availability solution, see the topic for "Configuring High Availability" in SQL Server 2005 Books Online.

Operating System Requirements (64-bit)

This table shows the operating systems that run the server software from each 64-bit version of SQL Server 2005.

  Enterprise Edition1(IA64) Enterprise Edition1(X64) Developer Edition (IA64)2 Developer Edition (X64)3 Standard Edition (IA64) Standard Edition (X64) SQL Express Evaluation Edition (IA64) Evaluation Edition (X64)

Windows XP 64-Bit Itanium Professional Edition

No

No

No

No

No

No

No

No

No

Windows XP X64 Professional 2003 (64-bit)

No

No

No

Yes

No

Yes

WOW644

No

Yes

Windows 2003 SP1 64-Bit Itanium Datacenter Edition

Yes4

No

Yes4

No

Yes4

No

No

Yes4

No

Windows 2003 SP1 64-Bit Itanium Enterprise Edition

Yes4

No

Yes4

No

Yes4

No

No

Yes4

No

Windows 2003 SP1 64-Bit X64 Standard Edition

No

Yes4

No

Yes4

No

Yes4

WOW644

No

Yes4

Windows 2003 SP1 64-Bit X64 Datacenter Edition

No

Yes4

No

Yes4

No

Yes4

WOW644

No

Yes4

Windows 2003 SP1 64-Bit X64 Enterprise Edition

No

Yes4

No

Yes4

No

Yes4

WOW644

No

Yes4

1SQL Server 2005 Evaluation Edition supports the same feature set as SQL Server 2005 Enterprise Edition, but Enterprise Edition is not supported on all of the operating systems that support Evaluation Edition.

2IA64 = Intel Itanium architecture.

3X64 = AMD architecture / Intel Extended Systems architecture.

4Tools native/WOW64. For more infromation on WOW64, see Extended System Support.

Extended System Support

SQL Server 2005 64-bit versions include support for extended systems, also known as Windows on Windows (WOW64). WOW64 is a feature of 64-bit editions of Microsoft Windows that allows 32-bit applications to execute natively in 32-bit mode. Applications function in 32-bit mode even though the underlying operating system is running on the 64-bit platform.

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.

For specific information on supported upgrade paths, see the topic for "Version and Edition Upgrades" in SQL Server 2005 Books Online.

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 the topic for "How to: Change Operating System Settings to Support Localized Versions" in SQL Server 2005 Books Online.

Supported Clients (64-bit)

SQL Server 2005 64-bit client components can be installed on Windows Server 2003 (64-bit).

Accessing SQL Server 2005 Books Online Documentation for Setup

To view SQL Server 2005 Setup documentation, follow these steps:

If you are running Setup from a local DVD drive:

  • Navigate to the root of the DVD, and launch Setupsql9.chm to view Setup documentation.

If you are running Setup from a network directory on Windows Server 2003 SP1 or later, or any version of Windows XP later than SP2:

  1. Navigate to the root of the installation folder on the network and copy Setupsql9.chm to the local computer.

  2. Launch Setupsql9.chm to view Setup documentation.