How to Execute a SQL Query

1. Find a computer in the Paul Allen Center building which has SQL Server installed (most of the undergrad labs should have SQL Server).
2. In Windows, goto Start, Programs, Microsoft SQL Server, Query Analyzer.
3. A Box labelled Connect to SQL Server should show up.
• In the input box labelled SQL Server, type iisqlsrv
• Select the Use SQL Server authentication option
• As Login Name type your UW CSE Login Name
• As Password type UW Student Number...please change your password to something else ASAP as instructed below.
• Press OK

By following the last step, you connected to the SQL Server machine called IISQLSRV, using your account.

• Look at the toolbar on the newly opened window. There is a drop-down menu that shows your current working database. Look for either 'spam1' or 'spam2'. To work on that database, just select it.

  You type your query in the window in the upper right labeled Query. Type Ctrl-E to run the query (or click on the little green arrow on the menu). If everything worked alright, you should get back the results of the query - some tuples.

Changing your password

In Windows, goto Start, Programs, Microsoft SQL Server, Enterprise Manager. 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 UW CSE login) 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.