Deploy SQL Server Management Studio using SCCM

Prajwal Desai
Posted by Prajwal Desai

In this post we will look at the steps to deploy SQL server management studio using SCCM (SSMS). SQL server management studio provides tools to configure, monitor, and administer instances of SQL. If you install SQL server 2016, by default SQL management studio is not installed on the machine.

I hope you will notice this when you install SQL server 2016 for SCCM. Prior to this SQL server 2014 had an option to allow installation of management tools. I am not a core SQL user but I do use SQL management studio while working on SCCM. This is basically to connect to the SQL instance and perform some tasks.

Microsoft decided to split the installation of management studio from the main SQL server installation. Probably the idea behind is to manage your SQL servers remotely. The question is why the SQL user needs to login to SQL server just to manage things that can be managed remotely as well.

Rather than logging in to the SQL server directly, installing management studio to manage SQL server is a better way. Therefore I believe in the future versions of SQL server, management studio will be a stand-alone tool.

Update – I have updated this post as the install and uninstall commands were incorrect.

Deploy SQL Server Management Studio using SCCM

To deploy SQL server management studio using SCCM, download the latest version from this link. This comes as an executable and I wish there was a msi file available. Furthermore on the same link you would find the compatible operating systems, change-log and prerequisites for installing studio. I must say that the studio is compatible with most of the modern operating systems. However do have a check once and proceed with the deployment.

Create a new application and choose Manually specify the application information. Click Next.

Deploy SQL Server Management Studio using SCCM

Add some information about the app and click Next.

Deploy SQL Server Management Studio using SCCM

Click on Add button to add deployment type. Select Manually specify the deployment information. Click Next.

Deploy SQL Server Management Studio using SCCM

Specify the content location, commands to install and uninstall the software.

Install Program - SSMS-Setup-ENU.exe /install /quiet /norestart
Uninstall Program - "C:\ProgramData\Package Cache\{91a1b895-c621-4038-b34a-01e7affbcb6b}\SSMS-Setup-ENU.exe" /uninstall /quiet /norestart

Deploy SQL Server Management Studio using SCCM

Add a detection rule by choosing setting type as File system.

Specify the File path as

%programfiles(x86)%\Microsoft SQL Server\140\tools\binn\managementstudio.

Next specify file name as Ssms.exe. Click OK and Next.

Deploy SQL Server Management Studio using SCCM

Specify the user experience settings based on your requirements. Click Next and complete the remaining steps. Finally distribute the content and deploy the application to the device collection.

Deploy SQL Server Management Studio using SCCM

Wait for the software to appear in the software center on client machine. Click Install to install the SQL management studio.

Deploy SQL Server Management Studio using SCCMI have tested the app installation and uninstallation and the commands are correct.

Share This Article
Prajwal Desai
Posted by Prajwal Desai
Follow:
Prajwal Desai is a Microsoft MVP in Intune and SCCM. He writes articles on SCCM, Intune, Windows 365, Windows Server, Windows 11, WordPress and other topics, with the goal of providing people with useful information.
26 Comments