Microsoft SQL Server logo.

SQL Server Management Studio (SSMS)

Opening SQl Server Management Studio

Open your Windows Start menu then scroll down and open the folder named Microsoft SQL Server 2016. In that folder you should see an application named Microsoft SQL Server Management Studio (as shown in figure 1), click on the app to open it.

Figure 1: The SQL Server Management Studio icon in the Windows Start menu.

Connecting to the Student Database Server

For the CSIS 786 class you will be using a Microsoft SQL Server as your Student Database Server to complete your database assignments.

In order to make a connection to the Student Database Server follow these steps:

  1. In SSMS click on the Connect Object Explorer icon, in the Visual Studio SQL Object Explorer, click on the Add SQL Server button as shown in figure 2.
Figure 2: The Add SQL Server button.
  1. In the Connect to Server dialog box (shown in figure 3) type the following:
    • Server Type: Database Engine
    • Server: ia.msjc.edu
    • Authentication Method: SQL Server Authentication
    • Login: 1st initial + LastName
    • Password: pw
    • Check the Remember password checkbox
Figure 3: The Connect to Server dialog box.
  1. Click on the Connect button to establish a connection to the Student Database Server.

SQL Server Objects

SQL server objects are organized into the following folders:

Table 1: SQL Server Management Studio Folders
FOLDER DESCRIPTION
Databases Contains all the databases available on the server. This list includes not only the user-created databases but also the system databases that are used by the server itself to manage all the relationships within and without the user databases.
Security As the folder name suggests, this folder maintains security information. In SQL Server the primary security concepts are logins that provide authentication, and roles that support authorization. Access to a database is determined by assigning a login a role in that database. This role could be anything from read-only to full administrative control.
Server Objects Contains various different support items, such as backup devices for configuring backups for your databases or other servers with whom this server has open communications.
Replication Replication is a group of technologies that support information distribution and mirroring between different databases. SQL replication enables not only copying data between databases, but also copying any database objects. These data- bases can be on the same server or any other server that has connectivity, even across the Internet
Management Items within this folder support management of the server itself, and contains items such as logs and event