Page 18 - DCAP508_DATABASE_ADMINISTRATION

Database Administration Sartaj Singh, Lovely Professional University

Notes Unit 2: Installing SQL Server

CONTENTS
Objectives
Introduction
2.1 Hardware and Software Requirements for SQL Server 2008 Installation
2.2 Procedure of Installing Microsoft SQL Server

2.3 Installing the Clients Tools of Microsoft SQL Server
2.4 Using SQL Server
2.4.1 Opening MS SQL Server
2.4.2 Launching SQL Server
2.5 Security Considerations for a SQL Server Installation
2.5.1 Before Installing SQL Server
2.5.2 After Installing SQL Server

2.6 Summary
2.7 Keywords
2.8 Review Questions
2.9 Further Readings

Objectives

After studying this unit, you will be able to:
Know the minimum hardware and software requirements to install and run SQL Server
2008
Understand the procedure of installing SQL server
Describes security considerations for a SQL Server installation

Introduction

There are various ways of installing sql server. The primary type consists of installing Microsoft
SQL Server on only one computer you will use to do everything. That machine may not be
connected to another or you will not be concerned with using things (files or databases) in other
computers. With this type of setup, you perform the installation on that computer and simply
start using Microsoft SQL Server.
The SQL Server Installation Wizard is Windows Installer-based. It provides a single feature tree
to install all SQL Server components:
SQL Server Database Engine
Analysis Services

Reporting Services
Integration Services
Replication

12 LOVELY PROFESSIONAL UNIVERSITY