sql

Download and Install SQL Server Management Studio

In this article, we’re going to the steps to download and install the Microsoft SQL Server Management Studio (SSMS).

1. SSMS System Requirements

SQL Server Management Studio (SSMS) is a powerful application maintained and distributed by Microsoft that is used for configuring, managing, and administering all components within Microsoft SQL Server.

The application was first launched with Microsoft SQL Server 2005 as the successor of Enterprise Manager from SQL Server 2000 and before.

The requirement to install SSMS is a Windows machine compatible with the version. Also, we need some packages and supplements to support the software:

1.1 Hardware requirements

  • 1.8 GHz or faster x86 (Intel, AMD) processor. Dual-core or better recommended.
  • 2 GB of RAM; 4 GB of RAM recommended (2.5 GB minimum if running on a virtual machine).
  • Hard disk space: Minimum of 2 GB up to 10 GB of available space.

1.2 Software requirements

  • Operating System
    • Windows 10 (64-bit) version 1607 (10.0.14393) or later
    • Windows 8.1 (64-bit)
    • Windows Server 2019 (64-bit)
    • Windows Server 2016 (64-bit)
    • Windows Server 2012 R2 (64-bit)
    • Windows Server 2012 (64-bit)
    • Windows Server 2008 R2 (64-bit)

2. Download SSMS

For this article, we’re going to download the most recent version of SSMS that is available here. Further, it’s available in the languages below if you prefer:

3. Install SSMS

After downloaded, open the installer to follow the steps to install the SSMS. The first step is choosing the location.

sql server management studio - ssms install
SSMS install location

Continuing, we’re going to see some package download. Wait until this process finishes.

sql server management studio - installation
SSMS installation progress

Finally, once the installation is completed, a restart should be required to conclude the process.

SSMS required restart

To make sure that the installation ran well, open the Start menu and find SSMS. Then, click to open it and you should see the loading screen and the login window will open to connect to the database.

SSMS loading screen

4. Installation with Azure Data Studio

Starting with SSMS 18.7, SSMS installs a system version of Azure Data Studio by default. However, it works only for Windows.

The Azure Data Studio has also versions to run on macOS and Linux that you can find here. It’s just to download and execute the software.

After extracted (or installed), you can find in the home screen ways to connect to a SQL Server database and execute queries from there.

Azure Data Studio

5. What’s new about ssms

Here I separated a summary of the recently released version of SSMS.

Version 18.9.2

New ItemDetails
Azure Data Studio installation integrationInstallation of SSMS installs Azure Data Studio 1.30.0.
Always EncryptedScripting support for Ledger tables.
Analysis ServicesSupport for XMLA endpoint to refresh datasets in PowerBI premium Gen 2.
Azure SQL DBAdds support for backup_storage_redundancy in database create/modify dialogs.
Azure SQL DBAdds create login script support for AAD-based login syntax.
Integration ServicesImprovement for IR Creation Wizard, Job Migration Wizard, and SSIS package scheduler to support AzureUSGovernment and AzureChinaCloud.
IntellisenseSyntax highlighting for External Language Management and Query Store (query_store_plan_feedback, query_store_query_variant).
SSMS general release notes

The complete information about the release can be consulted in this link.

6. Summary

In this article, we saw a little digest about how to install SSMS. We’ve figured which are the recommended requirements to install it. Also, we could know which languages are available on SSMS and we see some snapshots from the installation wizard.

Finally, I showed some information about Azure Data Studio besides Windows OS and present the general release notes about the latest version of SSMS.

This article was based on Microsoft Official Documentation about SSMS and more details can be found here.

Last updated on Dec. 20th, 2021

Sergio Lauriano Junior

Sergio is graduated in Software Development in the University City of São Paulo (UNICID). During his career, he get involved in a large number of projects such as telecommunications, billing, data processing, health and financial services. Currently, he works in financial area using mainly Java and IBM technologies.
Subscribe
Notify of
guest

This site uses Akismet to reduce spam. Learn how your comment data is processed.

0 Comments
Oldest
Newest Most Voted
Inline Feedbacks
View all comments
Back to top button