0

I have just Install SQL server 2016 and it has been installed successfully. Now I am looking for the Sql Server Management Studio to login into the Database Engine. but not able to see there. Also not able to open it by executing 

ssms.exe

Path: 

C:\Program Files\Microsoft SQL Server\130\Tools\Binn\ManagementStudio\

When i re-run the setup to install management studio it looks that we need to download it from Here: Why its missing with SQL server .ISO File. ?

Please advise if there any other option available or I can found it in DVD without downloading it again.

Improve this question
3
  • At least in previous versions, and likely also in 2016, Management Studio is a separate component that you can select during installation. (For example, it isn't entirely uncommon to not want to install it on dedicated database servers.) Did you accidentally select not to install it?
    – user
    Commented Dec 24, 2016 at 12:28
  • I select all the packages but not able to see it there.
    – Ramesh Chand
    Commented Dec 24, 2016 at 12:35
  • You will have to download the package separately
    – Ramhound
    Commented Dec 24, 2016 at 21:21

2 Answers 2

Reset to default
1

Starting with SQL Server 2016, Management Studio is a separate, stand-alone product and it does not come with SQL Server. You need to download and install it separately. See here for more details.

Improve this answer
0

On SQL2016 iso, during installation there is no option to choose install sql management studio. However, it has link to download 'Install SQL Server Management Tools'. What Windows os are you running?. In my case, I install windows 2016 and need to install vcredist_x64.exe before install sql2016. After succeed install sql2016 and sql management studio, as you mentioned, I have to launch it from dos command line 'ssms'.

Improve this answer

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .