Where is SQL Management Studio in SQL 2016?

So, in preparation of installing SharePoint 2016, I was installing SQL 2016 Enterprise. I got to the “Feature Installation” page and found that SQL Management Studio is not listed in the SQL install. Think I am lying? Look below!


So, I did a bit of research and found this: https://msdn.microsoft.com/en-us/library/mt238290.aspx where you can download SSMS for 2016. It is backwards compatible. I have not seen the technical reason behind this change, but if I had to guess it is so you can get SSMS by itself AND you don’t install anything extra on your Database Server. I am sure someone will comment and give a good number.

About Ben Adams

Ben Adams is a seasoned SharePoint Infrastructure Architect and proven leader. As a former Microsoft Certified Trainer and MCITP, Ben enjoys socializing SharePoint in the community and helping others come up with successful deployment models for SharePoint. Ben also enjoys music and photography.
Posted on by Ben Adams

Leave a Reply

Your email address will not be published. Required fields are marked *