How to install SQL Management Studio

SQL Server Management Studio (SSMS) is the official and preferred client user interface. SQL Server Management Studio (SSMS) is an integrated environment for accessing, configuring, managing, administering, and developing all components of SQL Server.

1) First ,you need to download SQL Server Management Studio (SSMS) installation files (SQL Management Studio_x86_ENU.exe) from the SQL Server download page.

Once downloaded ,it will take you to the first screen namely SQL Server Installation Center as shown below.This is the primary installation screen of SQL Server. Other SQL server tools installations can be launced from here as well.Once you are on this screen ,you need to select “New installation or add features to an existing installation” to proceed with the installation.

2) Once you select the “New SQL Server stand-alone installation or add features  to an existing installation” option ,it will check the setup rules on the server and take you to lisence terms screen. The lisence terms must be read and accepted like with any other application’s lisence terms. 

3)  However,if you need further details,you can select More Information which will take you to support page where you will find details related to the updates.

4) The next step is the Install Setup Files,where SQL Server Management Studio (SSMS) extract and install all necessary setup files to your server.

5)Once SQL Server Management Studio (SSMS) setup is done with the install setup files,it verifies the setup support rules in order to proceed.It then takes you to the feature selection screen.

6)This is very comprehensive screen which has detailed information about each feature.When we run the SQL Server Management Studio (SSMS) installation,it selects Management Tools by default,so you do not need to select anything here.In addition you can select Managemnt Tools-Basic.To get more information n this feature you can view the detailed feature description on right hand side.

You just need to click on the Nex button to continue.

7)In this step SQL Server Management Studio(SSMS) setup will verify the disk space.Make sure you have sufficient disk space available.Not having sufficient disk space may result in a faulty installation.Click on the next button to continue.

8)In this step,you have the opportunity  to decide whether or not to send the error notifications to Microsoft.This is highly recommended in order to help Microsoft improve future releases and to fix any bugs in the existing release.

9)Next,setup checks the installation rules and if it is passed,setup continues.This step will take some time to install SQL Server Management Studio.

10)This step displays the installation status of SQL Server Management Studio(SSMS) along with each feature.This screen helps to view what has been installed and what has not.In case one of the features could not be installed,you can re-run the same installation procedure and install that particular feature.

11)In order to check whether SQL Server Management Studio(SSMS) has been installed successfully,you need to select start menu of your server and then you will find the link to SQL Server Management Studio .

25