Tutorial: Getting Started with the Database Engine

SQL Server 2008 Books Online (October 2009)

Welcome to the Getting Started with the Database Engine tutorial. This tutorial is intended for users who are new to SQL Server and who have installed SQL Server Developer, Express, or Evaluation on a computer running Windows XP Professional Service Pack 2 (SP2).This brief tutorial helps you get started using the Database Engine.

What You Will Learn

This tutorial shows you how to connect to the Database Engine using SQL Server Management Studio or Management Studio Express, on both the local computer and from another computer.

This tutorial is divided into two lessons:

Lesson 1: Connecting to the Database Engine: In this lesson, you will learn how to connect to the Database Engine and enable additional people to connect.

Lesson 2: Connecting from Another Computer: In this lesson, you will learn how to connect to the Database Engine from a second computer, including enabling protocols, configuring ports, and configuring firewall settings.

Requirements

This lesson has no knowledge prerequisites.

Your system must have the following installed to use this tutorial:

Internet Explorer 6.0 or later.
Either SQL Server Management Studio or Management Studio Express.

Note:
When reviewing tutorials we recommend that you add Next and Previous buttons to the document viewer toolbar. For more information, see Adding Next and Previous Buttons to Help.

Tasks

Other Resources

Help and Information