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.