Modify SQL Server Management Studio 21 Preview components and language packs

Applies to: SQL Server Azure SQL Database Azure SQL Managed Instance Azure Synapse Analytics

It's easy to modify SQL Server Management Studio 21 Preview so that it includes only what you want. To do so, open the Visual Studio Installer, and then add or remove workloads, components, and language packs. This article walks you through the process.

Prerequisites

Open the Visual Studio Installer to modify your installation

To modify your SSMS installation, you need to open the Visual Studio Installer, and then select an SSMS installation to modify.

  1. There are many ways to open the Visual Studio Installer:

    • On the Windows Start menu, you can search for "installer" and then select Visual Studio Installer from the results.

    • Run the Visual Studio Installer executable file, which is located at C:\Program Files (x86)\Microsoft Visual Studio\Installer\setup.exe.

    You might be prompted to update the Visual Studio Installer before continuing. If you are, follow the prompts.

In the Visual Studio Installer, look for the installation of SSMS that you want to modify and then select Modify.

Change individual components

SSMS contains the components you need for managing SQL Server and Azure SQL databases.

  1. In the Visual Studio Installer, on the Workloads tab, select the workloads that you want.

  2. To add individual components, on the Individual components tab, select the individual components that you want.

  3. You can select the default Install while downloading or Download all, then install.

  4. Select Modify.

  5. After the modified workloads or components are installed, select Launch in the Visual Studio Installer to open SQL Server Management Studio.

You can also use a configuration file to modify an existing installation to add or remove components. For more information, see Import or export installation configurations.

Tip

For information about the SQL Server Data Tools (SSDT) component, see Install SQL Server Data Tools (SSDT) for Visual Studio.

Modify language packs

The Visual Studio Installer selects a default language pack for SSMS that matches the language of your operating system. You can change the default language whenever you want.

To change the default language:

  1. Select the Language packs tab in the Visual Studio Installer.
  2. Select the language you prefer.
  3. Follow the prompts.

Support or troubleshooting

Sometimes, things can go wrong. If your SSMS installation fails, see Troubleshoot installation and upgrade issues for SQL Server Management Studio 21 Preview for step-by-step guidance.

You can reference SQL user feedback for other known issues (filter on Tooling under Groups) and to provide feedback to the product team.