Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
Modify SQL Server Management Studio workloads, 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 22 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
By default, to install, update, or modify SQL Server Management Studio (SSMS), the account performing the update must have administrative permissions on the machine. It must also have permissions to the source where the product updates are located (either the internet or an internal location). If you're logged in as a typical user and try to perform one of these commands, you get a User Account Control notice prompting you for admin credentials. An admin can delegate control of modifying SSMS to standard users by configuring the AllowStandardUserControl policy. For more information, see User Permissions and Visual Studio.
The following procedures assume you have an internet connection. For information about how to modify a previously created offline installation of SSMS, see:
Modify your SSMS installation with the Visual Studio Installer
To modify your SSMS installation, you need to open the Visual Studio Installer, and then select an SSMS installation to modify.
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.
If you're prompted to update the Visual Studio Installer, follow the on-screen instructions before continuing.
In the Visual Studio Installer, look for the installation of SSMS that you want to modify and then select Modify.
Change workloads or individual components
Workloads group components that are commonly used together. Use workloads to modify SSMS so that it supports the work you want to do.
In the Visual Studio Installer, on the Workloads tab, select the workloads that you want.
To add individual components, on the Individual components tab, select the individual components that you want.
You can select the default Install while downloading or Download all, then install.
Select Modify.
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.
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 at any time.
To change the default language:
- Select the Language packs tab in the Visual Studio Installer.
- Select the language you prefer.
- 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 for step-by-step guidance.
You can reference the SSMS Developer Community site for other known issues (filter on Tooling under Groups) and to provide feedback to the product team.