Home

Introduction to Microsoft SQL Server

 

Microsoft SQL Server Setup

 

Introduction

Microsoft SQL Server is an application used to create computer databases for the Microsoft Windows family of server operating systems. It provides an environment used to generate databases that can be accessed from workstations, the web, or other media such as a personal digital assistant (PDA).

On this site, we provide lessons and other topics on how to use Microsoft SQL Server 2008.

Before installing Microsoft SQL Server 2008, make sure you have installed all service packs on your operating system. If you plan to use Microsoft Visual Studio 2008 to create Microsoft SQL Server 2008 database, you should install Microsoft SQL Server 2008 first, then install Microsoft Visual Studio 2008.

Getting Microsoft SQL Server

In order to follow the lessons on this site, you must have access to a computer in which Microsoft SQL Server 2008 is installed. To start, you must have a computer that runs an appropriate operating system. If you are just learning, which is assumed for all lessons on this site, you can use a Microsoft Windows XP Professional, Microsoft Windows Vista, or Microsoft Windows Server 2003.

To make it possible for you and other students to study databases and SQL, Microsoft made available a trial version of Microsoft SQL Server 2008. This full version is available from the Microsoft web site. To get the trial edition of Microsoft SQL Server 2008, go to the Microsoft web site, do a search on "trial software", and follow the links to locate the trial edition of Microsoft SQL Server 2008 Enterprise Edition (this is a very big file: 3GB).

Installation Steps

 

Introduction

If you are downloading, the file will be saved in your computer. When the download is over,  you must create an image. After creating the DVD image, you can insert the DVD in the drive. The installation will start. You may get a message that the .NET Framework needs to be installed. On that message, click OK. You will be prompted to start the installation:

Microsoft .NET Framework 3.5 SP1 Setup

After clicking the ACCETP button, you can click Install. The installation of the .NET Framework would start. When the installation of the .NET Framework is over, you would receive a message:

.NET Framework

From there, you can click Exit. If you are installing on Microsoft Windows XP, you may be asked to install a hotfix:

Hotfix

In this case, accept to install it by clicking Next and following the wizard. When the installation is over, you may be asked to restart:

Hotfix

Which you should do.

Practical LearningPractical Learning: Installing MS SQL Server

  1. To start the installation, put the Microsoft SQL Server 2008 DVD in the drive. A window would come up:
     
    Installation
  2. In the left section, click Installation
     
  3. If you are only insterested in studying database design and development in Microsoft SQL Server, on the right side, click New SQL Server Stand-Alone... The installation would start:
     
    Installation
  4. After the message box, click OK
     
    Setup
  5. Another message box would come up. When it finishes, the next page of the wizard would come up. If you are using the evaluation version, read the message and click Next
     
    Product Key
  6. The License Terms page is presented to you. Read it. If you don't agree with the license, click Cancel. Otherwise, click the I Accept check box and click Next:
     
    License Agreement
  7. On the next page, read the messages and click Install:
     
    Microsoft SQL Server 2008 Setup
  8. On the next page, read the messages and click Next:
     
    Microsoft SQL Server 2008 Setup
  9. The next page allows you to specify what you want to install and what would be left out. After making your selections, click Next
     
    Feature Selection
  10. The next page allows you to name the instance and to specify where the server would be installed. After making your selections, click Next:
     
    Instance
  11. The next page mostly allows you to check and confirm the disk space. After checking it, click Next
     
    Disk Space
  12. The next page allows you to configure the server. After making your selections, click Next
     
    Server Configuration
  13. In the next page, specify how authentication would be made. You should also specify the account used as the administrator. To do this, you can click Add Current User. Then click Next
     
    Database Engine Configuration
  14. The next step allows you to specify an account for the analysis services. You can simply click the Add Current User and click Next
     
    Analysis Services Configuration
  15. The next page allows you to specify the reporting service to install. Accept the default or make the necessairy change. Then click Next:
     
    Reporting Services Configuration
     
  16. The next page allows you to specify whether you want installation information to be collected and sent to Microsoft. After making your choice(s), click Next
     
    Error and Usage Reporting
     
    The pre-installation will proceed and let you know when it ends with the Installation Rules display:
     
    Installation Rules
  17. After reading, click Next.
    This would indicate that the installation is ready to proceed:
     
    Ready to Install
  18. To start the installation, you can click Install. The installation would start and the progress bar would indicate the evolution. This can take a while
     
    Installation Progress
     
    Installation Progress
  19. When this phase is over, a message box will let you know. After reading it, you can click Next. The last page of the wizard should announce that the installation was complete
     
    Installation
  20. After reading the message, you can click Close
 

Home Copyright © 2008 FunctionX, Inc. Next