Database Reference
In-Depth Information
Figure 5-8.
Enabling remote connections for a SQL Server
■
our purpose is to allow you to become familiar with the network protocol settings, but there is no need to
make changes at this time. no remote connections are necessary for the exercises in this topic.
Note
Management Studio Windows
SQL Server 2012 introduces a new SQL Server Management Studio user interface. The design may look different,
but functionally it is very similar to previous versions, and it includes multiple windows. These windows can be
repositioned and even moved outside Management Studio. This feature is great for use with multiple monitors.
However, the majority of the time you will use only Object Explorer and a query window.
Object Explorer
Object Explorer is the first of the two main windows utilized in SQL Server Management Studio. In the default
configuration, the Object Explorer window is displayed on the left side of the screen (Figure
5-9
). Object Explorer
allows you to view the various components of the database engine in a treeview format. By clicking the + next to
each folder icon, you are able to expand the folder to access subcomponents.
