GETTING STARTED WITH SQL SERVER

• Go to Start->programs->Microsoft SQL Server(client)->Enterprise Manager.
• Once the window opens, click on Action (left most on the tool/command bar) and choose New SQL Server Registration. Make sure that before you click Action, you have SQL Server Group selected, as shown in the picture below.
  
• The Register SQL Server Wizard will open:
  • screen 1: just click next.
  • screen 2: double click on IISQLSRV to select it, then click next (If IISQLSRV does not appear in the available server list, type in IISQLSRV.CS.WASHINGTON.EDU and click Add.
  • screen 3: select the second radio button saying "I want to connect using login information that was assigned to me by the system administrator (SQL Server Authentication), then click next
  • screen 4: you will be given instructions in class on what username and password to use.
  • screen 5: just click next
  • screen 6: click finish!
  • You will then receive a message that IISQLSRV Registered Successfully and you can close the message window

  CONGRATULATIONS!
  You just registered SQL server. Now what?
  There are two ways to interact with the server:

  • Query Analyzer
    lets you execute queries in an interactive mode.
    could be used to display the evaluation plan and execution time
  • Enterprise Manager
    useful for quick table creation, graphical view of the database.
    use to change your password and change access permissions (it is possible to do such changes from the query analyzer, but it is non-trivial).

  You will need to expore both ways of interaction, since the first thing you should do is change your password (see your TA if you need motivation why).
  For purposes of homework, the query analyzer will most likely be sufficient

  Accessing the server via the Enterprise Manager

  On the Console Root, expand Microsoft SQL Servers, then expand SQL Server Group, then expand IISQLSRV (Windows NT), and finally expand the Databases folder.

  Find your database, named as you UWNetId, and expand it.

  Here you have the tools that you need to create and manage your relations.

  Right clicking on any of them will give you different options, for example, right clicking on Tables will allow you to create a new table and so on.

  Changing your password

  On the Console Root, expand Microsoft SQL Servers, then expand SQL Server Group, then expand IISQLSRV (Windows NT), and finally expand the Security Folder.
  Click on Logins.
  Find yourself (your UWNetID) and right-click on your username. From this menu, select properties. You can type in your new password in the password field, just overwrite the old one. Once you click OK, you will be prompted to re-enter the password. Do so, click OK and you should be all done. If you're nervous, log out and re-log in with your new password. Good Luck!