Logo

Navigation
  • Home
  • Services
    • ERP Solutions
    • Implementation Solutions
    • Support and Maintenance Solutions
    • Custom Solutions
    • Upgrade Solutions
    • Training and Mentoring
    • Web Solutions
    • Production Support
    • Architecture Designing
    • Independent Validation and Testing Services
    • Infrastructure Management
  • Expertise
    • Microsoft Development Expertise
    • Mobile Development
    • SQL Server Database and BI
    • SAP BI, SAP Hana, SAP BO
    • Oracle and BI
    • Oracle RAC
  • Technical Training
    • Learn Data Management
      • Business Intelligence
      • Data Mining
      • Data Modeling
      • Data Warehousing
      • Disaster Recovery
    • Learn Concepts
      • Application Development
      • Client Server
      • Cloud Computing Tutorials
      • Cluster Computing
      • CRM Tutorial
      • EDI Tutorials
      • ERP Tutorials
      • NLP
      • OOPS
      • Concepts
      • SOA Tutorial
      • Supply Chain
      • Technology Trends
      • UML
      • Virtualization
      • Web 2.0
    • Learn Java
      • JavaScript Tutorial
      • JSP Tutorials
      • J2EE
    • Learn Microsoft
      • MSAS
      • ASP.NET
      • ASP.NET 2.0
      • C Sharp
      • MS Project Training
      • Silverlight
      • SQL Server 2005
      • VB.NET 2005
    • Learn Networking
      • Networking
      • Wireless
    • Learn Oracle
      • Oracle 10g
      • PL/SQL
      • Oracle 11g Tutorials
      • Oracle 9i
      • Oracle Apps
    • Learn Programming
      • Ajax Tutorial
      • C Language
      • C++ Tutorials
      • CSS Tutorial
      • CSS3 Tutorial
      • JavaScript Tutorial
      • jQuery Tutorial
      • MainFrame
      • PHP Tutorial
      • VBScript Tutorial
      • XML Tutorial
    • Learn Software Testing
      • Software Testing Types
      • SQA
      • Testing
  • Career Training
    • Career Improvement
      • Career Articles
      • Certification Articles
      • Conflict Management
      • Core Skills
      • Decision Making
      • Entrepreneurship
      • Goal Setting
      • Life Skills
      • Performance Development
      • Personal Excellence
      • Personality Development
      • Problem Solving
      • Relationship Management
      • Self Confidence
      • Self Supervision
      • Social Networking
      • Strategic Planning
      • Time Management
    • Education Help
      • Career Tracks
      • Essay Writing
      • Internship Tips
      • Online Education
      • Scholarships
      • Student Loans
    • Managerial Skills
      • Business Communication
      • Business Networking
      • Facilitator Skills
      • Managing Change
      • Marketing Management
      • Meeting Management
      • Process Management
      • Project Management
      • Project Management Life Cycle
      • Project Management Process
      • Project Risk Management
      • Relationship Management
      • Task Management
      • Team Building
      • Virtual Team Management
    • Essential Life Skills
      • Anger Management
      • Anxiety Management
      • Attitude Development
      • Coaching and Mentoring
      • Emotional Intelligence
      • Stress Management
      • Positive Thinking
    • Communication Skills
      • Conversation Skills
      • Cross Culture Competence
      • English Vocabulary
      • Listening Skills
      • Public Speaking Skills
      • Questioning Skills
    • Soft Skills
      • Assertive Skills
      • Influence Skills
      • Leadership Skills
      • Memory Skills
      • People Skills
      • Presentation Skills
    • Finding a Job
      • Etiquette Tips
      • Group Discussions
      • HR Interviews
      • Interview Notes
      • Job Search Tips
      • Resume Tips
      • Sample Resumes
 

Getting started with SQL Server 2005

By Exforsys | on August 9, 2005 |
SQL Server 2005

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.

The next screen informs the user that some of the required components will be checked for and upgraded.

 

Once the installation of the components required prior to Installing SQL Server is complete the finish button is to be clicked. Now the Welcome screen appears.

The next step is the system configuration check. The report of the check is displayed to the user. The success or failure of the check is reported along with warnings if any.

Once the user clicks continue the installation begins.

The next step is to enter the registration information. The user enters his name, company name and the serial number as it appears on the yellow sticker on the cover of the DVD. The user then clicks on Next to continue.

Next the components to be installed have to be specified. The user can chose to install all the components or some of the components.

On clicking Next, the Feature selection dialog box appears. All the selected features are displayed.

On clicking next the user is prompted to select the instance name. If he selects Default instance no name need be specified. If he selects Named instance, he will have to specify a name for the instance. Click Next to continue.

The user is now prompted to enter the details of the service account which is to be used for login to the server. The local or Domain user account can be selected.

The Authentication mode dialog box appears. The user must specify the authentication mode. It can be Windows authentication or Mixed mode. The user must assign a login irrespective of the mode selected. He must enter the password and confirm it before clicking next to continue.

The next dialog box is the Collation Settings dialog box. Collation settings define the sorting behaviour of the server. SQL server collations are used for setting up compatibility with earlier versions of SQL Servers.

The Report server database setup dialog box which appears requires the user to specify the instance of the SQL Server which will host the report server database. Select Host in current instance of SQL Server and specify the report server database name and click next to continue

The Next dialog box is the Report Server Delivery Settings dialog box. The user has to specify the parameters required for sending email reports. Click Next to continue if you do not wish to enter any details here.

The Error Reporting dialog box appears prompting the user that SQL server, its components and Analysis services will be configured to send fatal service error reports to Microsoft or a corporate error reporting server. The user can select the check box and click next as this helps Microsoft in monitoring its services and improving upon its software. Click Next to continue.

The ready to install dialog box displays all the components that are going to be installed on the system. To proceed with the installation the user has to click on Next.

The setup progress bar is displayed. On completion of set up the Next button will become enabled and the user has to click on Next to proceed.

The next dialog box displays all the files that are being configured. The user has to click on Next to continue.

The last dialog box displays the progress of the set up. All the selected components being configured are displayed and their status indicated. Click on Next to continue.

This takes the user to the final screen of the setup. The system is required to be rebooted for the configuration to take effect. The user is asked to click on finish to reboot the system. The user is informed that any errors in set up are recorded in the summary log for future reference. Click on Finish to complete the process.

In this lesson we have completed the set up of SQL Server 2005. In the lessons that follow we shall explore the new features of SQL Server 2005.

« « VB.NET Windows Application Testing
Tracing VB.NET Windows Application » »

Author Description

Avatar

Editorial Team at Exforsys is a team of IT Consulting and Training team led by Chandra Vennapoosa.

Free Training

RSSSubscribe 392 Followers
  • Popular
  • Recent
  • Security Features in SQL Server 2005 for the Developer

    October 15, 2005 - 0 Comment
  • SQL Server 2005 Configuration Manager

    December 18, 2005 - 0 Comment
  • SQL Server 2005 Administrative Tools

    November 19, 2005 - 0 Comment
  • SQL Server 2005 – Using Database Snapshots

    December 26, 2005 - 0 Comment
  • SQL Server 2005 – Unattended Installations

    December 7, 2005 - 0 Comment
  • T-SQL Enhancements in SQL Server 2005

    October 15, 2005 - 0 Comment
  • SQL Server 2005 – Populating the Database

    December 18, 2005 - 0 Comment
  • SQL Server 2005 – Registered Servers

    November 19, 2005 - 0 Comment
  • SQL Server 2005 – Backing up a Database

    January 1, 2006 - 0 Comment
  • SQL Server 2005 – Upgrading from earlier versions of SQL Server

    December 7, 2005 - 0 Comment
  • SQL Server 2005 – Configuring Replication

    January 11, 2006 - 0 Comment
  • SQL Server 2005 Replication Enhancements

    January 11, 2006 - 0 Comment
  • SQL Server 2005 – Mirror Server

    January 11, 2006 - 0 Comment
  • SQL Server 2005 – Introduction to Data Availability

    January 1, 2006 - 0 Comment
  • SQL Server 2005 – Backing up a Database

    January 1, 2006 - 0 Comment
  • SQL Server 2005 – Using Database Snapshots

    December 26, 2005 - 0 Comment
  • SQL Server 2005 – Disaster Recovery

    December 26, 2005 - 0 Comment
  • SQL Server 2005 – Managing Certificates

    December 26, 2005 - 0 Comment
  • SQL Server 2005 – Managing Permissions

    December 26, 2005 - 0 Comment
  • Managing SQL Server 2005 Security

    December 24, 2005 - 0 Comment

Exforsys e-Newsletter

ebook
 

Related Articles

  • SQL Server 2005 – Configuring Replication
  • SQL Server 2005 Replication Enhancements
  • SQL Server 2005 – Mirror Server
  • SQL Server 2005 – Introduction to Data Availability
  • SQL Server 2005 – Backing up a Database

Latest Articles

  • Project Management Techniques
  • Product Development Best Practices
  • Importance of Quality Data Management
  • How to Maximize Quality Assurance
  • Utilizing Effective Quality Assurance Strategies
  • Sitemap
  • Privacy Policy
  • DMCA
  • Trademark Information
  • Contact Us
© 2023. All Rights Reserved.IT Training and Consulting
This website uses cookies to improve your experience. We'll assume you're ok with this, but you can opt-out if you wish.AcceptReject Read More
Privacy & Cookies Policy

Privacy Overview

This website uses cookies to improve your experience while you navigate through the website. Out of these, the cookies that are categorized as necessary are stored on your browser as they are essential for the working of basic functionalities of the website. We also use third-party cookies that help us analyze and understand how you use this website. These cookies will be stored in your browser only with your consent. You also have the option to opt-out of these cookies. But opting out of some of these cookies may affect your browsing experience.
Necessary
Always Enabled
Necessary cookies are absolutely essential for the website to function properly. This category only includes cookies that ensures basic functionalities and security features of the website. These cookies do not store any personal information.
Non-necessary
Any cookies that may not be particularly necessary for the website to function and is used specifically to collect user personal data via analytics, ads, other embedded contents are termed as non-necessary cookies. It is mandatory to procure user consent prior to running these cookies on your website.
SAVE & ACCEPT