Page 19 - DCAP508_DATABASE_ADMINISTRATION

Unit 2: Installing SQL Server

Management tools Notes
Documentation

Notes SQL Server is available in 32-bit and 64-bit editions. The 64-bit and 32-bit editions
of SQL Server are installed either through the Installation Wizard, or at a command prompt.
2.1 Hardware and Software Requirements for SQL Server 2008
Installation

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

LOVELY PROFESSIONAL UNIVERSITY 13