# Getting started with SQL Server 2000

## 1. Connecting to the SQL Server from Enterprise Manager

- Start the Enterprise Manager from the Start Menu: Start => Microsoft SQL Server => Enterprise Manager
- Expand Microsoft SQL Servers, SQL Server Group and click on 128.83.143.141
- When prompted enter user name and password

- Expand server, databases, your database to view tables etc.

## 2. Using the Query Analyzer

- Start the Query Analyzer from Start => Microsoft SQL Server => Query Analyzer OR Expand Tools menu on the Enterprise and click on the Query Analyzer
- Enter SQL statements in the Query window and click Execute Query (F5). Results appear in bottom of the window.

## 3. Registering the SQL Server (from machines outside lab)

- After installing SQL Server client components, start Enterprise Manager
- Right click on SQL Server Group and click on New SQL Server Registration. In the wizard click on Next to start registration.
- Enter 128.83.143.141 in Available servers and click Add. Click Next.

- Select SQL Server login as the Authentication Mode.

- For Connection Option, choose either automatic login or Prompt. In case of Prompt, for connecting later use steps given in 1.

- Add the server to existing server group.

- Complete Server Registration. Click Finish.

- You should obtain a confirmation window.