What is SQL Server Management Studio?

Share on Facebook3Share on Google+0Tweet about this on TwitterShare on LinkedIn0Share on Reddit0Pin on Pinterest1

SQL Server Management Studio is an Integrated Environment that allows the user to manage, configure, administer and develop in Microsoft SQL Server.

The latest SQL Server Management Studio (SSMS) is free and can be downloaded from this link. Note that this version of SSMS (currently 17.2) supports only 64-bit Windows Operating Systems. If you need to use SQL Server Management Studio on a 32-bit machine, then you can download the 32-bit version of SQL Server Management Studio Express Edition here.

The below screenshot shows the fist screen of the latest version of SSMS at the time of the writing, which is SSMS 17.2.


As you can see, right after you start the application, you are presented with the login screen.

In the login screen, you need to specify at least two parameters (if you need, you can specify more options in the “Options” dialog), these are:

  1. Server Name
  2. Authentication

In the “Server Name” field, you can enter the name or IP of the SQL Server instance to which you want to connect to.

In “Authentication” you can specify one of 5 values:

  • Windows Authentication
  • SQL Server Authentication
  • Active Directory Authentication with MFA Support
  • Active Directory – Password
  • Active Directory – Integrated

Active Directory – Password authentication, Active Directory – Integrated authentication and Active Directory Authentication with MFA Support are used only for connecting to Microsoft Azure SQL Database.

Normally, in the case of on-premises SQL Server instances, regarding authentication, you either select “Windows Authentication” or “SQL Server Authentication”.

If you choose Windows Authentication, then SSMS will try to log on to the target SQL Server instance within the context of the user that runs SSMS. Usually this is the Windows user you are logged in to Windows, unless you launched SSMS within the context of another user (i.e. using the “Run as different user” option when launching SSMS).

If you choose SQL Server Authentication, then you will need to specify a username and password for connecting to the SQL Server instance. In both cases, you will need to be granted access by your Database Administrator (DBA) in order to be able to access the SQL Server instance and consequently the database.

The other three authentication types will be covered in another blog post where we will be talking about Azure SQL Database.

Now that the authentication part is clear, let’s login with Windows authentication and see a screenshot of SQL Server Management Studio for a sample SQL Server Instance:

As you can see in the above screenshot, right after you connect to a SQL Server instance via SSMS, in the left, there is a tree via which you can access just about anything. For example you can access, view and edit, : databases, tables, views, stored procedures, functions, users, logins, etc. Also, you can access SQL Server Agent jobs. Moreover, you can create databases as well as configure different SQL Server components and features. All these, will be covered in subsequent posts.

If you click on “New query”, you will be presented with the below screen, where you can start working with T-SQL:

As you can see, in the above example, I’m querying a table called “dSampleSales” that exists in a database called “SampleDB”. Right after I’m running the query, the results are displayed in Grid view.

Read also: What is the Difference Between SQL and SQL Server?

Check also: My eBooks on SQL Server

Subscribe to our newsletter and stay up to date with our latest posts, eBook releases and other news!

Stay tuned for more! Also, feel free to check my eBooks on SQL Server!

Rate this article: 1 Star2 Stars3 Stars4 Stars5 Stars (12 votes, average: 4.92 out of 5)


Recommended eBooks on SQL Server:

Developing with SQL Server: eBook by SQL Server MVP Artemakis Artemiou
Developing SQL Server: eBook by SQL Server MVP Artemakis Artemiou
Administering SQL Server: eBook by SQL Server MVP Artemakis Artemiou
Administering SQL Server: eBook by SQL Server MVP Artemakis Artemiou
Tuning SQL Server: eBook by SQL Server MVP Artemakis Artemiou
Tuning SQL Server: eBook by SQL Server MVP Artemakis Artemiou
About artemakis 6 Articles
Artemakis Artemiou is a Senior SQL Server Architect, Author, Software Developer and a Microsoft Data Platform MVP. He has over 15 years of experience in the IT industry in various roles. Among other, via his initiative SQLEBooks.com, Artemakis authors and publishes eBooks on different topics on SQL Server. Artemakis currently serves as the President of the Cyprus .NET User Group (CDNUG) and the International .NET Association Country Leader for Cyprus (INETA). Additionally he is the founder of the SQLArtBits initiative that aims to provide the technical community with simple, yet powerful and high-quality SQL Server tools. Currently, the highlights of these tools are DBA Security Advisor and In-Memory OLTP Simulator. Artemakis's official website can be found at aartemiou.com. Artemakis's blogs can be found at: SQLNetHub.com and TechHowTos.com.