Do you want to install SQL Server Management Studio? Two options are available to you. On the one hand, you can start the process on the local machine without having other SQL Server components. On the other hand, you can choose to install from the configuration file. We will detail the two possible methods below.
How to install SQL Server Management Studio on the local machine without other components?
Installing SQL Server Management Studio on the local machine without having other SQL Server components is usually done from an installation disc. After opening the SQL Server Installation Center, choose “Installation” and then choose “New SQL Server stand-alone installation or add features to an existing installation”.
After that, you need to choose “SQL Server Feature Installation” in the new “Setup Role” window that will open. You will then be able to configure the installation. At this point, check “SQL Server Feature Installation” then click “Next”. In the new window, check for only option “Management Tools – Basic and Management Tools – Complete”.
Continue the process by clicking on the “Next” button. You will have to press this button several times without choosing any option offered and accept the terms of the license, before reaching the “Ready to Install” window.
On the “Ready to Install” window, you will have access to the path of the configuration file. Just use this file to install SQL Server Management Studio on other devices without changing the configuration you choose.
Now all you have to do is click on the “Install” button and wait for the installation to complete. When the installation is complete, a final window titled “Complete” will open and inform you that the process has been completed successfully.
After the installation of SQL Server Management Studio is complete, you can go to the Start menu to find the newly installed program in the list of programs.
How do I install SQL Server Management Studio from the configuration file?
It is also possible to install SQL Server Management Studio on a computer using the configuration file created during a previous installation on a first device. This is the “ConfigurationFile.ini” file.
The advantage of this second method is that it is much faster than the first one on which it depends, however. In addition, using the configuration file from an old installation for a new one allows SQL Server Management Studio to be mounted while preserving its configuration.
How to proceed ? Open the “Cmd.exe” command prompt and enter the following command: C: Users Administrator> i: setup.exe / ConfigurationFile = “C: Program Files Microsoft SQL Server 120 Setup Bootstrap Log 20170611_124546 / ConfigurationFile.ini “/ Q / IAcceptSQLServerLicenseTerms =” True ”.
You will have noted that it is essential to specify the path of the SQL Server installation media as well as the path of the configuration file. The “Q” parameter simply indicates that the installation process will be silent. This means that here you will not see any installation window. Likewise, you will not be able, by choosing this method, to check or uncheck options.
Once the installation is complete, also go to the Windows Start menu, and you will find SQL Server Management Studio in the list of programs.