|
Page 1 of 3
Getting started and Installing SQL Server 2005
Microsoft has redesigned SQL server 2005 to deliver unprecedented value and functionality to the Database Administrator and the Developer. The four editions of the SQL server are Express, workgroup, Standard and Enterprise. Each of these editions offers a range of features.
High scalability, availability with advanced business intelligence tools empowers business users with a more secure, reliable and productive database management system. A reduced downtime and tight security controls make for a step forward in providing support to enterprise systems. Moreover, customers benefit from a reduced cost of ownership as this belongs to the Windows Server system.
In this tutorial we shall be installing SQL Server 2005 Enterprise Edition. However, before actually describing the installation process let us briefly examine the minimum requirements for installing and running SQL Server 2005.
Requirement for 32 bit platform
|
SQL Server 2005 (32-bit)
|
Processor type
|
Processor speed
|
Memory (RAM)
|
|
SQL Server 2005 Enterprise Edition
SQL Server 2005 Developer Edition
SQL Server 2005 Standard Edition
|
Pentium III compatible processor or higher required
|
Minimum: 500 MHz
Recommended: 1 GHz or higher
|
Minimum: 512 MB
Recommended: 1 GB or more
Maximum: OS maximum
|
|
SQL Server 2005 Workgroup Edition
|
Pentium III compatible processor or higher required
|
Minimum: 500 MHz
Recommended: 1 GHz or higher
|
Minimum: 512 MB
Recommended: 1 GB or more
Maximum: 3 GB
|
|
SQL Server 2005 Express Edition
|
Pentium III compatible processor or higher required
|
Minimum: 500 MHz
Recommended: 1 GHz or higher
|
Minimum: 128 MB
Recommended: 512 MB or more
Maximum: 1 GB
|
Requirement for the 64 bit platform
|
QL Server 2005 (64-bit)
|
Processor type
|
Processor speed
|
Memory (RAM)
|
|
SQL Server 2005 Enterprise Edition4
SQL Server 2005 Developer Edition
SQL Server 2005 Standard Edition
|
IA64 minimum: Itanium processor or higher
X64 minimum: AMD Opteron, AMD Athlon 64, Intel Xenon with Intel EM64T support, Intel Pentium IV with EM64T support
|
IA64 minimum: 733 MHz
IA64 recommended: 733 MHz or more
X64 minimum: 1 GHz
X64 recommended: 1 GHz or more
|
IA64 minimum: 512 MB
IA64 recommended: 1 GB or more
IA64 maximum: 32 TB
X64 minimum:512 MB
X64 recommended: 1 GB or more
X64 maximum: 32 TB
|
Disk space requirements
|
Feature
|
Disk space requirement
|
|
Database Engine and data files, Replication, and Full-text Search
|
150 MB
|
|
Analysis Services and data files
|
35 KB
|
|
Reporting Services and Report Manager
|
40 MB
|
|
Notification Services engine components, client components, and rules components
|
5 MB
|
|
Integration Services
|
9 MB
|
|
Client Components
|
12 MB
|
|
Management Tools
|
70 MB
|
|
Development Tools
|
20 MB
|
|
SQL Server Books Online and SQL Server Mobile Books Online
|
15 MB
|
|
Samples and sample databases
|
|
Other Requirements
|
Resolution
|
1024 x 768
|
|
DVD Drive
|
Required
|
|
Cluster installations
|
For 32 and 64 bit platforms eight node cluster installations required
|
|
Operating System
|
Windows Server 2003, Windows XP, Windows 2000, Windows 98 or Windows ME
|
|
End points
|
Introduces new concept of server connections called Transact SQL endpoint.
|
|
Internet
|
Microsoft Internet Explorer 6.0 SP1 or later is required for SQL Server Management Studio, Business Intelligence Management Studio, the Report Designer component of reporting services.
|
|
Software Requirements
|
Microsoft Windows Installer 3.0
|
|
|
Microsoft Windows .NET Framework 2.0
|
|
|
Reporting services require MDAC 2.8 on Windows 2000
|
|
|
SQLXML requires MDAC 2.6 or higher on Windows 2000
|
|
|
SQL Server Failover clusters require Microsoft Cluster Server (MSCS) on at least one node of the server cluster.
|
The above list is by no means exhaustive but it does cover the fundamental requirements that need to be present while installing SQL Server 2005.
Now insert the DVD into the drive and begin the installation. The user is expected to read through the license agreement and accept the license before he can proceed any further. After accepting the license agreement click on Next to proceed.
|