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
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:
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.
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.
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.
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:
- 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 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.