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 SQL Server account password,
[Assuming for discussion purposes, your
userid=Userxx
old password=OldPswd
new password that you want to change to=NewPswd]
a) login to "128.83.143.141" (i.e. UTCSDBMS) using your userid (say "Userxx"
and say, "OldPswd")
b) Expand the "Security" Tab (NOT the "Databases" Tab)
c) Click on "Logins"
d) Find your userid "Userxx"
e) Right click on it, Choose "Properties"
f) Delete the encoded password, and type in the new password, and click
on "OK"
g) SQLServer will prompt you for old password, and ask to confirm new password.
Type in your old password (say) "OldPswd" and (say) "NewPswd" --- OBVIOUSLY,
choose something different :-)) that you can remember easily.
h) Then click on "OK". Subsequently, you will need your new password to
log in.
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.
