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.



 
• To change your password, expand sever, security. Click on logins, find your login, right click to obtain properties. In the properties window, delete the encoded password and click ok. SQL server prompts for new password.

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.