Connection to Microsoft SQL Server 2005

 

You will need SQL Server Management Studio installed to view your MS SQL Server database.

 

Click Start -> All Programs -> Microsoft SQL Server 2005 -> SQL Server Management Studio.

 

Next you will be prompted to connect to a server. Select Database Engine for the Server type then type cs-sqlsrvr.cs.usna.edu for the Server name. Next select SQL Server Authentication as your Authentication type, type in your user name (Mxxxxxx where xxxxxx is your alpha), and the password provided by your instructor, and click Connect.

 

 

 

At this point you are connected to the server. Click the plus sign in front of the Databases object. Scroll down and find your database named Mxxxxxx (where xxxxxx is your alpha) then click the plus sign. All the objects that you create (tables, views, stored procedures, etc) will be stored in your database.