Search sqlserver-dba.com
Follow sqlserver-dba.com
*Use the Comments section for questions
SQLServer-DBA.com Links
Recent Posts
- How to find privilege changes with SQL Server Default Trace
- sys.dm_server_services - How to check if SQL Server service is running or not?
- Msg 3023, Level 16, State 2 Backup, file manipulation operations (such as ALTER DATABASE ADD FILE) and encryption changes on a database must be serialized. Reissue the statement after the current backup or file manipulation operation is completed.
- Can we restore a database to an older version in SQL Server?
- How do I save all SQL Agent Jobs
- How to view SQL Server mount point space without access to server
- DBCC SHRINKFILE: page could not be moved because it is a work table page.
- SQL Agent Last Modified explanation
- Sql certificate chain was issued by an authority that is not trusted
- sqlserver-dba.com switching from feedburner to follow.it
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 (http://www.sqlserver-dba.com)
Share:
Verify your Comment
Previewing your Comment
This is only a preview. Your comment has not yet been posted.
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.
Posted by: |