Exforsys

SQL Server 2005 Training

  1. SQL Server 2005 - Configuring Replication
  2. SQL Server 2005 Replication Enhancements
  3. SQL Server 2005 - Mirror Server
  4. SQL Server 2005 - Introduction to Data Availability
  5. SQL Server 2005 - Backing up a Database
  6. SQL Server 2005 - Using Database Snapshots
  7. SQL Server 2005 - Disaster Recovery
  8. SQL Server 2005 - Managing Certificates
  9. SQL Server 2005 - Managing Permissions
  10. Managing SQL Server 2005 Security
  11. SQL Server 2005 - Using the Database Tuning Advisor
  12. SQL Server 2005 - Tuning a Database
  13. Maintain indexes in a SQL Server 2005 database
  14. SQL Server 2005 - Defining Indexes
  15. SQL Server 2005 - Database Backup
  16. SQL Server 2005 - Populating the Database
  17. SQL Server 2005 Configuration Manager
  18. SQL Server 2005 - Using the Sqlcmd Utility
  19. Using the SQL Management Objects
  20. Using SQL Sever Management Studio - Part 2
  21. Using SQL Sever Management Studio - Part 1
  22. SQL Server 2005 - Using Event Notifications
  23. SQL Server 2005 - Using DDL Triggers
  24. SQL Server Monitoring Tools - Server Profiler
  25. SQL Server 2005 - Testing Troubleshooting
  26. SQL Server 2005 - Upgrading from earlier versions of SQL Server
  27. SQL Server 2005 Installation - Maintenance Plan Without Using Wizard
  28. SQL Server 2005 - Unattended Installations
  29. SQL Server 2005 Installation - Maintenance Plan Using Wizard
  30. Installing a Second Copy of SQL Server 2005
  31. Planning to Install SQL Server 2005
  32. SQL Server 2005 Installation
  33. SQL server 2005 Editions
  34. SQL Server 2005 Architecture Overview
  35. SQL Server 2005 - Management studio interface Summary Page
  36. SQL Server 2005 - Server Groups
  37. SQL Server 2005 - Registered Servers
  38. SQL Server 2005 Administrative Tools
  39. Developing Client applications in SQL Server 2005
  40. SQL Server Management Objects
  41. NET CLR in SQL Server 2005
  42. Native HTTP Support in SQL Server 2005
  43. XML Data Types in SQL Server 2005
  44. Using XML in SQL Server 2005
  45. Using Notification Services in SQL Server 2005
  46. SQL Server 2005 - Service Broker
  47. Data Manipulation Language (DML) in SQL Server 2005
  48. T-SQL Enhancements in SQL Server 2005
  49. Security Features in SQL Server 2005 for the Developer
  50. SQL Server Architecture and Components
  51. SQL Server 2005 Management Studio
  52. Overview of SQL Server 2005 for the Database Developer
  53. Getting started with SQL Server 2005

Ads


Home arrow Technical Training arrow SQL Server 2005 Training

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

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.



 
This tutorial is part of a SQL Server 2005 Training tutorial series. Read it from the beginning and learn yourself.

SQL Server 2005 Training

  1. SQL Server 2005 - Configuring Replication
  2. SQL Server 2005 Replication Enhancements
  3. SQL Server 2005 - Mirror Server
  4. SQL Server 2005 - Introduction to Data Availability
  5. SQL Server 2005 - Backing up a Database
  6. SQL Server 2005 - Using Database Snapshots
  7. SQL Server 2005 - Disaster Recovery
  8. SQL Server 2005 - Managing Certificates
  9. SQL Server 2005 - Managing Permissions
  10. Managing SQL Server 2005 Security
  11. SQL Server 2005 - Using the Database Tuning Advisor
  12. SQL Server 2005 - Tuning a Database
  13. Maintain indexes in a SQL Server 2005 database
  14. SQL Server 2005 - Defining Indexes
  15. SQL Server 2005 - Database Backup
  16. SQL Server 2005 - Populating the Database
  17. SQL Server 2005 Configuration Manager
  18. SQL Server 2005 - Using the Sqlcmd Utility
  19. Using the SQL Management Objects
  20. Using SQL Sever Management Studio - Part 2
  21. Using SQL Sever Management Studio - Part 1
  22. SQL Server 2005 - Using Event Notifications
  23. SQL Server 2005 - Using DDL Triggers
  24. SQL Server Monitoring Tools - Server Profiler
  25. SQL Server 2005 - Testing Troubleshooting
  26. SQL Server 2005 - Upgrading from earlier versions of SQL Server
  27. SQL Server 2005 Installation - Maintenance Plan Without Using Wizard
  28. SQL Server 2005 - Unattended Installations
  29. SQL Server 2005 Installation - Maintenance Plan Using Wizard
  30. Installing a Second Copy of SQL Server 2005
  31. Planning to Install SQL Server 2005
  32. SQL Server 2005 Installation
  33. SQL server 2005 Editions
  34. SQL Server 2005 Architecture Overview
  35. SQL Server 2005 - Management studio interface Summary Page
  36. SQL Server 2005 - Server Groups
  37. SQL Server 2005 - Registered Servers
  38. SQL Server 2005 Administrative Tools
  39. Developing Client applications in SQL Server 2005
  40. SQL Server Management Objects
  41. NET CLR in SQL Server 2005
  42. Native HTTP Support in SQL Server 2005
  43. XML Data Types in SQL Server 2005
  44. Using XML in SQL Server 2005
  45. Using Notification Services in SQL Server 2005
  46. SQL Server 2005 - Service Broker
  47. Data Manipulation Language (DML) in SQL Server 2005
  48. T-SQL Enhancements in SQL Server 2005
  49. Security Features in SQL Server 2005 for the Developer
  50. SQL Server Architecture and Components
  51. SQL Server 2005 Management Studio
  52. Overview of SQL Server 2005 for the Database Developer
  53. Getting started with SQL Server 2005
 

Comments