Subscribe to RSS feed  Follow @jackvamvas - Twitter

*Use the Comments section for questions Links


SQL Server DBA Jobs

MS SQL 2016 Management Studio Silent Install

06 September,2017 by Tom Collins

 As part of SQL Server 2016 installation SQL Server Management Studio (SSMS) is no longer available by default. It is necessary to manage SSMS as part of a separate installation.

This SQL Server 2016 release of SSMS  does not require a SQL Server license to install and use.

To install a SQL Server 2016 SSMS silent install  follow these instructions

Step 1- Obtain a copy of the SQL Server 2016 SSMS binaries via Download SQL Server Management Studio (SSMS) and place in a location either on the server or a network path.

Step 2 – Ensure the security context of the executor has sufficient privileges to install the binaries.

Step 3 – Execute the batch from the Command line

           "MY_PATH\SSMS-Setup-ENU.exe" /install /quiet /norestart /log C:\tmp\ssmslog.txt


To confirm SSMS is installed check using the DOS based  command "where"

            Where ssms


which should return something similar to:

       C:\Program Files (x86)\Microsoft SQL Server\140\Tools\Binn\ManagementStudio\Ssms.exe


This is just a basic outline of the steps required to install SQL Server Management Studio 2016. Using different tools such as Powershell it's possible to add a lot more automation around this basic steps .


Author: Tom Collins (


Verify your Comment

Previewing your Comment

This is only a preview. Your comment has not yet been posted.

Your comment could not be posted. Error type:
Your comment has been posted. Post another comment

The letters and numbers you entered did not match the image. Please try again.

As a final step before posting your comment, enter the letters and numbers you see in the image below. This prevents automated programs from posting comments.

Having trouble reading this image? View an alternate.


Post a comment on MS SQL 2016 Management Studio Silent Install | SQL Server Performance Tuning | SQL Server DBA:Everything | FAQ | Contact|Copyright & Disclaimer