SQL SERVER – Management Studio Missing – SSMS 2014 not Installed with SQL Server 2014

Recently I got a message on Skype about SSMS.

Hi Pinal, Need quick suggestion. I am unable to find ssms.exe after installation of SQL Server. Do you know how I can install it?

Initially I thought that since SQL Server 2016 doesn’t come with SQL Server Management Studio, this would be an expected behavior. So, I shared my blog to him.

SQL SERVER – Installing SQL Server Management Studio 2016 – Step by Step

Later, he informed me that they are using SQL Server 2014. The next oblivious question was whether they have installed that feature during installation and he had no idea as it was installed by someone else.

I asked to check discovery report (SQL SERVER – Discovery Report – How to Find Information About Installed Features?) and check if they have Management Tools installed on this machine. As expected, it was not installed and that’s why SSMS, and other client tools were missing.

WORKAROUND/SOLUTION

Here were the steps given to fix the issue.

1. Run Setup.exe
2. Choose below option.
   
3. Later in the wizard, choose “Choose “Add new feature on existing installation”
4. Select “Management Tools” under the features screen.
   
5. Finish the installation.

 After following the above steps, the SSMS was installed.

Reference: Pinal Dave (http://blog.SQLAuthority.com)