Saturday, March 22, 2014


SQL SERVER – 2008 – Hardware and Software Requirements for Installing SQL Server 2008


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

Hardware and Software Requirements for Installing SQL Server 2008 R2

For both 32-bit and 64-bit editions of SQL Server 2008 R2, the following apply:


  • For minimum version requirements to install SQL Server 2008 R2 on Windows Server 2012 or Windows 8, see Installing SQL Server on Windows Server 2012 or Windows 8 (http://support.microsoft.com/kb/2681562).
  • SQL Server 2008 R2 Datacenter is available for evaluation during a 180-day trial period. For more information, see the SQL Server: How to Buy Web site.
  • Microsoft recommends that you run SQL Server 2008 R2 on computers with the NTFS file format. For upgrades to SQL Server 2008 R2, FAT32 file systems will not be blocked.
  • SQL Server Setup will block installations on read-only or compressed drives.
  • For information about using SQL Server 2008 R2 tools to prepare for an upgrade to SQL Server 2008 R2, see Using Upgrade Advisor to Prepare for Upgrades.
  • SQL Server does not install the .NET Framework 3.5software development kit (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.
  • Requirements to restart computers during SQL Server Setup: Installation of the .NET Framework requires a restart of the operating system. If Windows Installer installation also requires a restart, Setup will wait until the .NET Framework and Windows Installer components have installed before restarting