Do you know what is SQL Server Management Studio? Where to get the SQL Management Studio download? How to install and use it? Now, you come to the right place. This post of MiniTool will explain these questions in detail.

What Does SQL Server Management Studio Do

‘This part mainly introduces the definition, features, and system requirements of Microsoft SQL Server Management Studio.

What Is SQL Server Management Studio

SQL Server Management Studio, also called SSMS, is an Integrated Environment that can manage any SQL-based infrastructure from SQL Server to Azure SQL Database. It was a software application first introduced with Microsoft SQL Server 2005 that’s used for managing, configuring, and administering all components within the SQL Server. With the SSMS tool, you can query, manage, and design your database on a local PC or in the cloud.

Now, the latest version of SQL Server Management Studio (SSMS) 18.10 has been released on October 5, 2021. It provides many new features, improvements, and bug fixes like Analysis Services, Import Flat File, fixes for a narrator issue, etc. To know more details, you can click this hyperlink.

System Requirements of SSMS

Before you install the newest version of SSMS 18.10, make sure that you meet the following system requirements for 64-bit platforms. Here we list them as follows:

Operating Systems: Windows 11/8.1 (64 bit), Windows 10 version 1607 or later (64-bit), and Windows Server 2008 R2/2012/2012 R2/2016/2019/2022 (64-bit)

Processor: 1.8 GHz or faster x86 (AMD or Intel), Dual-core or better recommended

RAM: 4GB or more recommended, 2.5GB minimum on a virtual machine

Hard disk: 2GB to 10GB of available space

Note: The SSMD tool is only available as a 32-bit application for Windows. If you want to run the tool on other operating systems, we recommend you use Azure Data Studio. It is a cross-platform tool that can run on Linux, macOS as well as Windows.

Further Reading: What can you do if there's not enough space to install the SSMS tool? Don't worry. MiniTool Partition Wizard can help you free up the hard disk easily.

Free Download

SQL Server Management Studio Download and Install

Once your computer meets the system requirements of Microsoft SQL Management Studio v18.10, you can follow the guide below to download and install the tool. There are 2 ways to install the SSMS and you can choose one bases on what you prefer.

Note: Since the SSMS v18.x installation can’t upgrade or replace SSMS v17.x or earlier, you need to uninstall it before you install the SSMS v18.10 if you have installed a preview version of SSMS v18.x.

Way 1. Install SSMS Manually

Step 1. Click here to get the MS SQL Server Management Studio downloaded freely and select a location to save the download file.

Step 2. After you download SSMS successfully, you should get a .exe file named SSMS-Setup-ENU.exe. Double click the file and click on Yes in the UAC window to run it.

Step 3. If you want to change the installation location, you can click on Change and select another place. Here we take C drive for example. Once you confirmed the location, click on Install.

install SSMS in Windows 10

Step 4. Then you can see the Package Progress and Overall Progress as the picture shows below. Wait for the process to complete.

start installing Microsoft SQL Server Management Studio

Step 5. Once you installed the SSMS successfully, you will see the “Setup Completed” message, and then you can start using the tool.

Setup Completed in SSMS installation screen

Microsoft .NET Framework 3.5 Download & Install for Windows 10/11
Microsoft .NET Framework 3.5 Download & Install for Windows 10/11

Lots of users want to install NET 3.5 Windows 10. Where to get the NET Framework 3.5 download? How to install it? This post provides you with 5 applicable ways.

Read More

Way 2. Install SSMS Using CMD

If you want to install Microsoft SQL Management Studio in the background without any GUI prompts, you can try using a command prompt script.

Step 1. Type cmd in the search box on the taskbar. And then right-click the Command Prompt app and select Run as administrator. Click on Yes to grant admin rights to the Command Prompt window.

Step 2. In the elevated command prompt, copy and paste the following command and hit Enter. Make sure you replace the path with the location where you saved the SSMS package and you want to install it. For example, the command line is: start "" /w %systemdrive%\SSMSfrom\SSMS-Setup-ENU.exe /Quiet SSMSInstallRoot=%systemdrive%\SSMSto

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

install SSMS via CMD

Tip: If you want to view the setup UI, you can replace the /Quiet with /Passive.

Step 3. Then wait for the installation to complete.

How to Use SQL Server Management Studio

Now, you should get the MS SQL Server Management Studio downloaded and installed successfully. Here we will show you how to access Microsoft SQL Server Management Studio.

Step 1. Type SQL in the Search box and select Microsoft SQL Server Management Studio 18 from the top result.

search SSMS in Windows 10

Step 2. In the main interface, you will see the pop-up Connect to Server screen. Here you need to select the Server type and enter the Server name, User name, and Password in the boxes.

  • Server type: There are 5 server types that you can select, based on your demands, including Database Engine, Analysis Services, Reporting Services, Integration Services, and Azure-SSIS Integration Runtime.
  • Server name: It refers to the Server’s name where MS SQL Server is installed. Usually, you can use the Server name as “Machine name\Instance”.
  • Authentication: The default option is “Windows Authentication”.
  • User name\Password: If you select the Authentication other than “Windows Authentication”, then you need to enter your user name and password in the fields.

Step 3. After you enter related information, click on Connect. Then you will be connected to SQL Server Data Management Studio.

connect to SQL Server

Download Visual C++ Redistributable 2015 for Windows (X64/X86)
Download Visual C++ Redistributable 2015 for Windows (X64/X86)

What is Visual C++ Redistributable 2015? Where to find the Visual C 2015 package? If you are trying to figure these questions out, this post is what you need.

Read More
  • Linkedin
  • Reddit