6 out of 13 rated this helpful - Rate this topic

Tutorial: Getting Started with the Database Engine

SQL Server 2008 R2

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 Edition. This brief tutorial helps you get started using the Database Engine.

Note
This tutorial applies to SQL Server 2005 and later versions.

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 tutorial 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. Management Studio can be installed by running SQL Server setup. Management Studio Express can be installed from Microsoft Download Center.

Tasks

How to: Connect to SQL Server from Windows Vista

Concepts

Tutorials

Did you find this helpful? Yes No

Not accurate

Not enough depth

Need more code examples

(1500 characters remaining)

Community Additions

ADD