How to Install SQL Server Management System for SQL Server 2016

This page contains screenshots of the steps involved in installing SQL Server Management System (SSMS) for SQL Server 2016.

Installing SQL Server 2016 installs many things but it doesn't install SQL Server Management Studio (SSMS). Therefore, if you need to use it, you need to install SSMS separately. Here's how.

  1. Start the Wizard

    Screenshot of the Installation Center.

    This is done from the same SQL Server Installation Center that you use when installing SQL Server.

    So from the SQL Server Installation Center, ensuring that Installation is selected in the left menu, click the second option (Install SQL Server Management Tools).

    If you don't have the SQL Server Installation Center open, locate the SQL Server download package and double-click Setup.

  2. Start the Installation

    Screenshot of the Installation Center. Screenshot of the security message.

    Click Install.

    Click Yes if you get asked if you want this app to make changes to your PC.

    The wizard will download and install SQL Server Management Studio. It could take a while.

  3. Setup Complete

    Screenshot of the completed setup.

    After the wizard has completed the installation, a success message is displayed.

    Click Close to exit the wizard.

  4. Open SSMS

    Screenshot of the Program Files in Windows.

    You can now open SQL Server Management Studio by finding it in your Windows apps list. It is located as a sub group of Microsoft SQL Server 2016.