SQL Server 2014 Tutorial – SQL Server Management Studio

Published on April 8, 2016 by Senthil Kumar

Filed under SQL Server

Last modified April 8, 2016

Print this page

rate 1 star rate 2 star rate 3 star rate 4 star rate 5 star
Your rating: none, Average: 3 (2 votes)

This article have been viewed 17242 times

Problem Statement

You need to manage your Microsoft SQL Server environment using SSMS (SQL Server Management Studio).


Microsoft SQL Server Management Studio (SSMS) lets the administrators to perform the following

  • Configure SQL Server components.
  • Create Database, tables, stored procedures and views.
  • Manage data inside the database.
  • and more…

Follow the below steps to manage your SQL Server environment in Microsoft SQL Server Management Studio (SSMS).

1. To open SQL Management Studio, Click Start -> All Apps -> Microsoft SQL Server 2014 -> SQL Server Management Studio.


2. When SQL Management Studio is opened, you will be prompted to connect to Server Dialog. Enter the Server name, and keep the Authentication to "Windows authentication". You could change the authentication to "SQL Server authentication" but you should provide the valid login and password that you configured when installing the SQL Server. Click connect button to connect to the Server.


3. Let’s have a look at the Object explorer window which provides options for accessing the features of the server and the databases for the user.

As a user, you can connect to the multiple instances of the SQL Server via the object explorer. After you get connected to SSMS and inside the Object explorer window, you can create databases and manage them.

If the Object explorer window is not open, you can navigate to View menu and select "Object explorer" or press the shortcut key "F8" to view it. The Object explorer generally appears in the left side of the SQL Management studio.


4. In the top section of the object explorer, you would see the connect with the dropdown list. Expand the dropdown list to connect to the various other SQL Server components and services

5. The toolbar that is found just above the Object explorer has a button with name "New Query". Click it. This will display a new Query Window where you can write queries and interact with the SQL Server database.


6. We’ll explore more on how to use Object explorer and Query window in the upcoming tutorials.

1 Comment

  1. SQL Server 2014 Tutorial – Personalize SQL Management Studio | Abundant Code
    April 8, 2016 - 10:28 pm

Leave a Comment


You might be Interested in these Posts

Video - Angular Router - Brian Ford

Video - Angular Router - Brian Ford http://www.youtube.com/watch?v=sfV0ApyN5fM ...

Video - An Angular2 Todo App: First look at App Development in Angular2

In this screencast , David East , one of the core contributor of the Angular provides a glimpse of A...

Video - Getting started with Angular 2

In this screencast , Alex Eagle , developer on the Angular team talks about Angular 2 developer prev...