Getting started with SQL Server 2005

Page 1 of 3

Author : Exforsys Inc. Published on: 9th Aug 2005 | Last Updated on: 6th Apr 2011

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.

Ads

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 Edition⁴

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.

Ads

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.