SQL Server 2014 Tutorial – SQL Server Management Studio

Published on April 8, 2016 by abundantcode

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 (1 votes)

This article have been viewed 1876 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.

If you enjoyed this post, please consider leaving a comment or subscribing to the RSS feed to have future articles delivered to your feed reader.

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

How to use array Rank in C# ?

In C# , the Rank property of the array is is used to get the rank of the array. In simple terms , ra...

How to append an array to another in JavaScript ?

In JavaScript , you may want to append one array to another array(s) to combine their elements resul...

Building a ASP.NET Web API in Visual Studio 2015

This blog post will explain on how to create a Simple ASP.NET Web API using Microsoft Visual Studio ...