Journey to SQL Authority with Pinal Dave

The following sections list the minimum hardware and software requirements to install and run SQL Server 2008.

The following requirements apply to all SQL Server 2008 installations:

1.Framework

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

- NET Framework 3.5
- SQL Server Native Client
- SQL Server Setup support files

2. Software

SQL Server Setup requires Microsoft Windows Installer 4.5 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.

3. Internet Software

Microsoft Internet Explorer 6 SP1 or a later version is required for all installations of SQL Server 2008. 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.

4. Display

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

For Installing SQL Server 2008 Enterprise Edition:

1. Processor :

Processor type: Pentium III-compatible processor or faster
Processor speed: Minimum: 1.0 GHz, Recommended: 2.0 GHz or faster

2. Operating System: Windows XP Professional SP2

Windows XP SP2 Tablet
Windows XP SP2 Media Center 2002
Windows XP SP2 Media Center 2004
Windows XP Media Center 2005
Windows XP Professional Reduced Media
Windows Server 2003 Small Business Server R2 Standard
Windows Server 2003 Small Business Server R2 Premium
Windows Server 2003 SP2 Standard
Windows Server 2003 SP2 Enterprise
Windows Server 2003 SP2 Data Center
Windows Server 2003 Small Business Server SP2 Standard
Windows Server 2003 Small Business Server SP2 Premium
Windows Server 2003 SP2 64-bit x64 Standard
Windows Server 2003 SP2 64-bit x64 Data Center
Windows Server 2003 SP2 64-bit x64 Enterprise
Windows Vista Ultimate
Windows Vista Home Premium
Windows Vista Home Basic
Windows Vista Enterprise
Windows Vista Business
Windows Vista 64-bit x64 Ultimate
Windows Vista 64-bit x64 Home Premium
Windows Vista 64-bit x64 Home Basic
Windows Vista 64-bit x64 Enterprise
Windows Vista 64-bit x64 Business
Windows Server 2008 Standard (with and without Hyper-V)
Windows Server 2008 Web
Windows Server 2008 Data Center
Windows Server 2008 Data Center without Hyper-V
Windows Server 2008 Enterprise
Windows Server 2008 Enterprise without Hyper-V
Windows Server 2008 x64 Standard
Windows Server 2008 x64 Standard without Hyper-V
Windows Server 2008 x64 Data Center
Windows Server 2008 x64 Data Center without Hyper-V
Windows Server 2008 x64 Enterprise
Windows Server 2008 x64 Enterprise without Hyper-V

3. Memory:

RAM:

Minimum: 512 MB
Recommended: 2.048 GB or more
Maximum: Operating system maximum

4. Features and 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 Books Online   :    240 MB

Reference: SQL Server TechCenter (http://technet.microsoft.com)