MS SQL 2016 Management Studio Silent Install

06 September,2017 by Jack Vamvas

 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: Jack Vamvas (http://www.sqlserver-dba.com)


Share:

Verify your Comment

Previewing your Comment

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

Working...
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.

Working...

Post a comment on MS SQL 2016 Management Studio Silent Install


sqlserver-dba.com | SQL Server Performance Tuning | SQL Server DBA:Everything | FAQ | Contact|Copyright & Disclaimer