Install-SSMS

Introduction

SQL Server Management Studio is also known as (SSMS). It is the most popular integrated environment tool for managing and administering Microsoft SQL Server infrastructure or connecting to an Azure cloud SQL Database.

SSMS is a Microsoft proprietary tool that allows users to connect to SQL Server, create databases, and run complex queries with ease. It is widely used by SQL database administrators, SQL database developers, SQL business intelligence developers, database analysts, system analysts, database devops engineers, etc.

SSMS Features

  • Object Explorer
  • Query Editor
  • Database Designer
  • Table Designer
  • Template Explorer
  • Query Execution Plan
  • Query and View Designer
  • Import or Export Data

System Requirements

The following are the system requirements for installing SQL Server Management Studio.

Supported Operating Systems

  • Windows 11 (64-bit)
  • Windows 10 (64-bit) version 1607 (10.0.14393) or later
  • Windows 8.1 (64-bit)
  • Windows Server 2022 (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)

Hardware Support

  • Processor: 1.8 GHz or faster. Dual-core or better recommended
  • Memory: 2 GB of minimum RAM, 4 GB of RAM recommended
  • Hard disk: 2GB up to 10GB minimum available free space.

Installation of SQL Server Management Studio (SSMS)

Visit the below link to download SQL Server Management Studio.

https://docs.microsoft.com/en-us/sql/ssms/download-sql-server-management-studio-ssms?view=sql-server-ver15

Click “Free Download SQL Server Management Studio (SSMS)”. 18.11.1 is the latest version, but we have downloaded 18.9.1 a few months back, which we will be installing.

Graphic User Interface (GUI) Installation

1. After downloading SSMS, run the setup file and click “Install“. By clicking install, you accept the license agreement terms. You can change the installation location if you want to.

How to Install SQL Server Management Studio (SSMS)

2. The installation will take some time, depending upon your computer specs. After the installation is completed, click “Close.”

How to Install SQL Server Management Studio (SSMS)

Unattended Installation

There is another way to install SSMS through a Command Prompt as an Unattended Installation. It will install SSMS in the background with no user interface prompts.

Open the Command Prompt with Administrator Previleges and run the following command.

start “” /w <path where SSMS-Setup-ENU.exe file is located> /Quiet SSMSInstallRoot=<path where you want to install SSMS>

Example

start “” /w <E:\Downloads> /Quiet SSMSInstallRoot = <C:\SQLServer Management Studio 18>

If you receive an error during the installation process, to troubleshoot the issue, you can look into the log file location at %TEMP%SSMSSetup.

Connecting to the Database

We will connect to Microsoft SQL Server Express 2019 edition that is installed on our computer, but before connecting to the SQL Server database using SSMS, make sure the database service is running.

Click on the start menu, and open SQL Server 2019 Configuration Management.

How to Install SQL Server Management Studio (SSMS)

Click SQL Server Services and you will see SQL Server(SQLEXPRESS) is running.

SQL-Server-Express-Service-is-running

Now launch SQL Server Management Studio (SSMS), from the start menu.

How to Install SQL Server Management Studio (SSMS)

Connect to the SQL Server Database.

How to Install SQL Server Management Studio (SSMS)

After connecting to SQL Server Express, let’s run the query to create the database.

Create Database EasyTechHub

The EasyTechHub database has been created.

Database-created

Follow our post below on how to install Microsoft SQL Server 2019 Express Edition.

https://easytechhub.com/how-to-install-sql-server-express-2019/

Conclusion

Microsoft SQL Server Management Studio (SSMS) is the most popular tool for connecting Microsoft SQL Server infrastructure on-premises or on the cloud to manage, maintain, administrate, monitor, or troubleshoot Microsoft SQL Server or its components.

Spread the love

By Feroz Khan

Feroz Khan works as a system administrator with more than 12 years of experience in information technology. He would like to share the knowledge with others that he has gained during his working experience.

5 1 vote
Article Rating
Subscribe
Notify of
guest

0 Comments
Inline Feedbacks
View all comments
0
Would love your thoughts, please comment.x
()
x