Hardware and Software Requirements for Installing SQL Server 2008

Hardware and Software Requirements for Installing SQL Server 2008

 

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

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

Accessing SQL Server Books Online Documentation for Setup

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

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

For both 32- and 64-bit editions:

SQL Server does not install the .NET Framework 2.0 SDK. However, the SDK contains tools that are useful when you use the .NET Framework for SQL Server development. You can download the .NET Framework SDK from the .NET Framework Web site.

Native Web Service (SOAP/HTTP) support is only available for computers that are running SQL Server and the Windows Server 2003 operating system.

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

SQL Server Developer Edition (64-bit)

The following table shows system requirements for SQL Server Developer Edition (64-bit):

Component Requirement
Processor1 Processor type:

  • IA64 minimum: Itanium processor or faster
  • x64 minimum: AMD Opteron, AMD Athlon 64, Intel Xeon with Intel EM64T support, Intel Pentium IV with EM64T support

Processor speed:

  • IA64 minimum: 1 GHz
  • IA64 recommended: 1 GHz or more
  • x64 minimum: 1 GHz
  • x64 recommended: 1 GHz or more
Framework SQL Server Setup installs the following software components required by the product:

  • Microsoft .NET Framework 2.0
  • Microsoft SQL Server Native Client
  • Microsoft SQL Server Setup support files
Operating System Windows Server 2003 64-Bit x64 SP1 and SP2Windows Server 2003 64-Bit x64 Enterprise Edition SP1 and SP2 Windows Server 2003 64-Bit Itanium SP1 and SP2Windows Server 2003 64-Bit Itanium Enterprise Edition SP1 and SP2

Windows XP Professional 64-Bit x64 SP2

Software SQL Server Setup requires Microsoft Windows Installer 3.1 or a later version, and Microsoft Data Access Components (MDAC) 2.8 SP1 or a later version. You can download MDAC 2.8 SP1 from the MDAC downloads Web site.After installing required components, SQL Server Setup will verify that the computer where SQL Server will be installed also meets all the other requirements for a successful installation.
Network Software Network software requirements for the 64-bit versions of SQL Server are the same as the requirements for the 32-bit versions.Windows Server 2003, Windows XP, and Windows 2000 have built-in network software.

Note:
SQL Server 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.

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.

Internet Software Microsoft Internet Explorer 6 SP1 or a later version is required for all installations of SQL Server. Internet Explorer 6 SP1 or a later version is required for Microsoft Management Console (MMC), SQL Server Management Studio, Business Intelligence Development Studio, the Report Designer component of Reporting Services, and HTML Help. A minimal installation of Internet Explorer is sufficient. 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 SP2 is sufficient.Internet Information Services (IIS) 5.0 or a later version is required for Reporting Services installations.For more information, see How to Install Microsoft Internet Information Services (IIS) in SQL Server Books Online. For information about how to install IIS 7.0 on Windows Vista, see the Installing IIS 7.0 Web site.

ASP.NET 2.0: ASP.NET 2.0 is required for Reporting Services. When installing Reporting Services, SQL Server Setup will enable ASP.NET if it is not already enabled.

For Reporting Services (64-bit) installations on 64-bit servers, the 64-bit version of ASP.NET must be installed. For Reporting Services (32-bit) installations on the 32-bit subsystem (WOW64) of a 64-bit server, the 32-bit version of ASP.NET must be installed. Reporting Services is not supported in side-by-side configurations on the 64-bit operating system and on the 32-bit subsystem (WOW64) of a 64-bit server at the same time. For more information, see : Install 32-bit Reporting Services on a 64-bit Computer in SQL Server Books Online.

Memory3 RAM:

  • IA64 minimum: 512 MB
  • IA64 recommended: 1 GB or more
  • IA64 maximum: Operating system maximum
  • x64 minimum:512 MB
  • x64 recommended: 1 GB or more
  • x64 maximum: Operating system maximum
Hard Disk Disk space requirements will vary with the SQL Server components you install. For more information, see the hard disk space requirements section later in this topic.
Drive A CD or DVD drive, as appropriate, is required for installation from disc.
Display SQL Server graphical tools require VGA or higher resolution: at least 1,024×768 pixel resolution.
Other Devices Pointing device: A Microsoft mouse or compatible pointing device is required.
Other Requirements  

System Configuration Checker (SCC) will block Setup if the requirement for processor type is not met. SCC 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 multiprocessor computers.

Management Tools are supported in WOW64, a feature of 64-bit editions of Microsoft Windows that enables 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 operating system.

SCC 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 available memory when Setup starts.

SQL Server Developer Edition (32-bit)

The following table shows the system requirements for SQL Server Developer Edition (32-bit):

Component Requirement
Processor1 Processor type:

  • Pentium III-compatible processor or faster

Processor speed:

  • Minimum: 600 MHz
  • Recommended: 1 GHz or faster
Framework SQL Server Setup installs the following software components required by the product:

  • Microsoft .NET Framework 2.0
  • Microsoft SQL Server Native Client
  • Microsoft SQL Server Setup support files
Operating System Windows Server 2003 SP1 and SP2Windows Server 2003 Enterprise Edition SP1 and SP2Windows XP Professional SP2Windows Server 2003 64-Bit x64 SP1 and SP2

Windows Server 2003 64-Bit x64 Enterprise Edition SP1 and SP2

Windows Server 2003 64-Bit Itanium SP1 and SP2

Windows Server 2003 64-Bit Itanium Enterprise Edition SP1 and SP2

Software SQL Server Setup requires Microsoft Windows Installer 3.1 or a later version, and Microsoft Data Access Components (MDAC) 2.8 SP1 or a later version. You can download MDAC 2.8 SP1 from the MDAC downloads Web site.After installing required components, SQL Server Setup will verify that the computer where SQL Server will be installed also meets all the other requirements for a successful installation. For more information, see Check Parameters for the System Configuration Checker in SQL Server Books Online.
Network Software Network software requirements for the 64-bit versions of SQL Server are the same as the requirements for the 32-bit versions.Windows Server 2003, Windows XP, and Windows 2000 have built-in network software.

Note:
SQL Server 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.

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.

Internet Software Microsoft Internet Explorer 6 SP1 or a later version is required for all installations of SQL Server. Internet Explorer 6 SP1 or a later version is required for Microsoft Management Console (MMC), SQL Server Management Studio, Business Intelligence Development Studio, the Report Designer component of Reporting Services, and HTML Help. A minimal installation of Internet Explorer is sufficient. 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 SP2 is sufficient.Internet Information Services (IIS) 5.0 or a later version is required for Reporting Services installations.For more information, see How to Install Microsoft Internet Information Services (IIS) in SQL Server Books Online. For information about how to install IIS 7.0 on Windows Vista, see the Installing IIS 7.0 Web site.

ASP.NET 2.0: ASP.NET 2.0 is required for Reporting Services. When installing Reporting Services, SQL Server Setup will enable ASP.NET if it is not already enabled.

For Reporting Services (64-bit) installations on 64-bit servers, the 64-bit version of ASP.NET must be installed. For Reporting Services (32-bit) installations on the 32-bit subsystem (WOW64) of a 64-bit server, the 32-bit version of ASP.NET must be installed. Reporting Services is not supported in side-by-side configurations on the 64-bit operating system and on the 32-bit subsystem (WOW64) of a 64-bit server at the same time. For more information, see: Install 32-bit Reporting Services on a 64-bit Computer in SQL Server Books Online.

Memory3 RAM:

  • Minimum: 512 MB
  • Recommended: 1 GB or more
  • Maximum: Operating system maximum
Hard Disk Disk space requirements will vary with the SQL Server components you install. For more information, see the Hard Disk Space Requirements (32-Bit and 64-Bit) section later in this topic.
Drive A CD or DVD drive, as appropriate, is required for installation from disc.
Display SQL Server graphical tools require VGA or higher resolution: at least 1,024×768 pixel resolution.
Other Devices Pointing device: A Microsoft mouse or compatible pointing device is required.
Other Requirements  

System Configuration Checker (SCC) will block Setup if the requirement for processor type is not met. SCC 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 multiprocessor computers.

This edition of SQL Server can be installed to the Windows on Windows (WOW64) 32-bit subsystem of a 64-bit server.

SCC 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.

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

During installation of SQL Server, Windows Installer creates temporary files on the system drive. Before you run Setup to install or upgrade SQL Server, verify that you have 1.6 GB of available disk space on the system drive for these files. This requirement applies even if you install SQL Server components to a non-default drive.

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

Feature Disk space requirement
Database Engine and data files, Replication, and Full-Text Search 280 MB
Analysis Services and data files 90 MB
Reporting Services and Report Manager 120 MB
Integration Services 120 MB
Client Components 850 MB
SQL Server Books Online and SQL Server Compact Edition Books Online 240 MB
Samples and sample databases. Note that samples and sample databases are not installed automatically. 410 MB

Extended System Support

SQL Server 64-bit versions include support for extended systems, also known as Windows on Windows (WOW64). WOW64 is a feature of 64-bit editions of Windows that enables 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 operating system.

Installing SQL Server on a Domain Controller

You can install SQL Server Katmai on a domain controller. The following limitations apply:

On Windows Server 2003, SQL Server services can run under a domain account or a local system account.

You cannot run SQL Server services on a domain controller under a local service account or a network service account.

After SQL Server is installed on a computer, you cannot change the computer from a domain member to a domain controller. You must uninstall SQL Server before you change the host computer to a domain controller.

After SQL Server is installed on a computer, you cannot change the computer from a domain controller to a domain member. You must uninstall SQL Server before you change the host computer to a domain member.

SQL Server failover cluster instances are not supported where cluster nodes are domain controllers.

Supported Clients (64-Bit)

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

Accessing SQL Server Books Online Documentation for Setup

To view SQL Server Setup documentation, follow these steps:

If you are running Setup from a local DVD drive:

  1. Navigate to the “Servers” or “Tools” folder at the root of the SQL Server CD or DVD and launch the s10ch_setup.chm file from \Setup\Help\<Lang ID>\, where <Lang ID> is the four-digit language designator for your copy of SQL Server.

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 “Servers” or “Tools” folder at the root of the installation directory and launch the s10ch_setup.chm file from \Setup\Help\<Lang ID>\, where <Lang ID> is the four-digit language designator for your copy of SQL Server.

 “”” To view Setup documentation from a network share on a computer running Microsoft Windows Server 2003 Service Pack 1 (SP1) or later, or a version of Windows XP later than SP2, you must first copy the s10ch_setup.chm file to the local computer. “””

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: