Create an offline installation of SQL Server Management Studio 21 Preview

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

SQL Server Management Studio 21 Preview is designed to work well in various computer configurations. In this article, you learn how to create an offline installation package of files for installation on the local machine.

Use the "Download all, then install" feature

Sometimes online access is problematic. For example, you might have an unreliable internet connection or your internet connection might have low bandwidth. For situations like these, you have other methods available for acquiring SQL Server Management Studio (SSMS). You can use the Download all, then install feature from the Visual Studio Installer to download an installation package on the local machine before you install it locally, or you can use the command line to create a local installation package to install locally later.

After you download the bootstrapper, run it to install SSMS. It first installs and then launches the latest version of the Visual Studio Installer, which you can use to customize and configure your installation, download installation packages, and install the product.

To complete downloading the product before installation starts, select the Download all, then install option in the dropdown list at the bottom of the default Workloads tab of the Visual Studio Installer. The purpose of this feature is to download the SSMS packages in advance on the computer where SSMS is eventually installed. By downloading the packages locally first, you can then safely disconnect from the internet before you install SSMS.

Use the command line to create a local layout

Step 1 - Download the SSMS bootstrapper

Download the correct bootstrapper for the version of SSMS you want, and copy it into the directory you want to use as the source location for your local layout. The bootstrapper is the executable you use to create, update, or modify your local layout. You must have an internet connection to complete this step.

Step 2 - Create a local layout

Open a command prompt with administrator privileges, navigate to the directory where you downloaded the bootstrapper, and use the bootstrapper's parameters to create your local layout. You must have an internet connection to complete this step.

You can install a language other than English by changing en-US to a locale from the list of language locales, and you can use the [list of component IDs to further customize your local layout.

To create a complete local layout for SQL Server Management Studio, run:

vs_ssms.exe --layout c:\localSSMSlayout --add Microsoft.Component.HelpViewer

Note

Make sure that your full installation path is less than 80 characters and that your machine has ample storage. SQL Server Management Studio requires a minimum of 4-GB of disk space. For more information, see System requirements for SQL Server Management Studio 21 Preview.

Step 3 - Install SSMS from the local layout

When you install SSMS from a local layout, the Visual Studio Installer uses the local versions of the files. If you select components during installation that aren't in the layout, then the Visual Studio Installer attempts to download them from the internet. To make sure you install only the files you previously downloaded, use the same command-line options you used to create the local layout. To make sure your installer doesn't try to access the internet when it's installing the product, use the --noweb switch.

For example, if you created a local installation layout with the following command:

vs_ssms.exe --layout c:\localSSMSlayout --add Microsoft.Component.HelpViewer

Then use the following command to run the installation and prevent the client machine from accessing the internet:

c:\localSSMSlayout\vs_ssms.exe --noWeb --add Microsoft.Component.HelpViewer

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.