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

Reference : Pinal Dave (https://blog.sqlauthority.com) , SQL Server TechCenter (http://technet.microsoft.com)

Database
Previous Post
SQL SERVER – Introduction to Filtered Index – Improve performance with Filtered Index
Next Post
SQLAuthority Author Visit – Microsoft Student Partner Conference

Related Posts

35 Comments. Leave new

  • i cant install sql server 2008 developer on window server 2003 standard edition …it say that the minimum operating system is not match this product..please advice

    Reply
  • how v can control clients with d help of server

    Reply
  • Thank you for the run of the mill information.

    SQL Server Reporting services can not be installed on Windows 7 Home Premium – it requires WIndows 7 Professional.

    Reply
  • Can I install SQL Server 2008 R2 Enterprise on Server 2003 R2 Enterprise Edition?

    Reply
  • can I install MSSQL-2008 in windows server 2003 enterprise edition does it support?

    Reply
  • Hi Pinal,
    i am using sql server 2008 enterprise edition .problem i am facing is the server is very slow and it is taking time to execute query

    Reply
  • I Mr. GOPI C KATTEL IS VERY PROUD OF YOU, I GOT A NO OF CLUE AND
    HIDDEN ANSWERS AFTER READING YOUR ARTICLES, I HAVE NO WORD
    TO DESCRIBE YOUR TALANCY,KNOWLEDGE AND POWER OF EXPRESSION.

    THANKS A LOT ,SIR

    Reply
  • Hi Pinal,
    Is Reporting Servce free of cost?

    Reply
  • HI Pinal

    which version of sql server support on linux os.

    Thank
    Vinay

    Reply
  • Sir am planning to buy a laptop for SQL server enterprise 2008 ,which laptop u suggest me……….am in a hurry to buy ,so plz do help

    Reply
    • Hi…..Eshwar here..
      Go for the laptop having the configuration of 2gb ram, i3 processor and 500 gb hard disc
      (Dell, Lenova)

      Reply
  • This is what Mircrosoft recommends. Do YOU have a minimum configuration you would recommend for best/better performance?

    Reply
  • Carlos Guillermo
    October 29, 2015 2:14 am

    HI Pinal
    I have problems with the installation of Visual studio for server 2008 in window 10 I try all the version that Microsoft has but still have the same problems that it is not compatible version with server 2008 there is another version of visual studio that I can use for server 2008 r2. for building Reports 2.0

    Carlos

    Reply
  • is SQL server 2008 compatible with Windows server 2012 R2 ?

    Reply

Leave a Reply