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.

  • 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? – a CVn Dec 24 '16 at 12:28
  • I select all the packages but not able to see it there. – Ramesh Chand Dec 24 '16 at 12:35
  • You will have to download the package separately – Ramhound Dec 24 '16 at 21:21
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'.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.