Deploy Microsoft SQL Server Management Studio (SSMS) 20.x through Intune Microsoft SQL Server Management Studio (SSMS) continues to evolve, with SSMS 20.x now available as the latest release. If you are still using SSMS 19.0.2, it is recommended to upgrade to the current version for enhanced stability, performance, and feature updates. In this guide, we walk through the step‑by‑step process of deploying SSMS as a Win32 app in Microsoft Intune, covering silent installation commands, packaging, detection rules, and assignment strategies.
- Release number: 19.0.2
- Build number: 19.0.20209.0
- Release date: March 13, 2023
You can download Microsoft SQL Server Management Studio from https://aka.ms/ssmsfullsetup.
In this blog post, we will look at the steps to install SQL Server Management Studio version 19.0.2 through Microsoft Intune.
SSMS Silent Install & Uninstall Commands
Install (Silent):
SSMS-Setup-ENU.exe /install /quiet /norestart
Uninstall (silent):
SSMS-Setup-ENU.exe /uninstall /quiet /norestart
Prepare SSMS Installation Source for Intune
Before deploying SQL Server Management Studio (SSMS) through Microsoft Intune, you must first prepare the installation source as a Win32 app package. This ensures Intune can properly upload, distribute, and manage the application.
👉 Follow this guide: How to Prepare Win32 App Installation Source for Microsoft Intune
Create a Win32 App for Microsoft SQL Server Management Studio
Follow the steps below to deploy SQL Server Management Studio (SSMS) using Microsoft Intune Win32 app deployment:
Click Select to proceed with configuration.
In the Microsoft Intune console, go to Apps > Windows Apps.
Click Add.
Select Windows app (Win32) as the app type.
On the Add App page:
Click OK to upload the package.
Click Select app package file.
Click Browse and choose the .intunewin file you created in the previous step.
On the App information page:
Click Next to continue with the deployment configuration.
Provide the required details such as Name, Description, Publisher, and Category.
Optionally, upload an icon/logo for better visibility in the Company Portal.
On the Program page:
Enter the silent install command:
SSMS-Setup-ENU.exe /install /quiet /norestart
Enter the silent uninstall command:
SSMS-Setup-ENU.exe /uninstall /quiet /norestart
Adjust other options (e.g., restart behavior, install context) as per your requirements.
Click Next to continue.
On the Requirements page:
Select the conditions that must be met before installation begins (e.g., OS architecture, minimum OS version, disk space, or custom script checks).
Configure additional requirement rules if needed (file, registry, or PowerShell script).
Click Next
On the Detection rules page, perform the following steps:
- In Rule format, select Manually configure detection rules.
- Click Add.
- In the Detection rule flyout window:
- Rule type: File
- Path:
C:\Program Files (x86)\Microsoft SQL Server Management Studio 19\Common7\IDE - File:
Ssms.exe - Detection method: File or folder exists
- Click Next to continue.
After configuring detection rules:
- Click Next three times to skip Dependencies and Supersedence (not required for this installation).
- On the Assignments page, choose how to deploy the app:
- All Devices
- All Users
- Specific Azure Active Directory (AAD) groups
- Optionally, apply Filters for more granular targeting.
- Select the assignment type:
- Required → App installs automatically on targeted devices.
- Available → App is published to the Company Portal, and users can initiate installation themselves.
Click on Next.
On the Review + create page:
Carefully review all configured settings (App information, Program, Requirements, Detection rules, and Assignments).
Confirm that the details are correct.
Click Create to finalize the deployment.
Intune will now create the application and upload .intunewin file to the Intune portal. You can monitor the progress from the Notification area.
Conclusion
Deploying SQL Server Management Studio (SSMS) through Microsoft Intune Win32 app deployment streamlines application management across your organization. By preparing the installation source, configuring program commands, setting requirements, and defining detection rules, you ensure a reliable and automated deployment process.
Assignments
Related Posts
- Deploy Win32 App Using Intune Enterprise App Catalog
- Understanding Win32 App Detection Rules
- Understanding Win32 App Requirements Rule
- Upgrade / Replace Win32 Apps with Supersedence Relationship
- Win32 App Deployment with Dependencies
- Win32 Apps vs LOB Apps
- Win32 App Deployment failed with error code 0x80070643
- Win32 App Deployment Failed with Error 0x87D1041C
- Win32 App Deployment failed with error 0x87D300C9
- Win32 App failed with error code 0x80070653
- Deploy Google Chrome for Enterprise with Intune Win32 App
- How to Prepare Win32 App Installation source for Microsoft Intune
- SCCM Device Collection Equivalents in Microsoft Intune for App Deployment
- Deploy Microsoft SQL Server Management Studio 19.02 through Intune
- Organizing Laptop and Desktop in Intune Using Filters
Subscribe to Techuisitive Newsletter
Be the first to know about our new blog posts. Get our newsletters directly in your inbox and stay up to date about Modern Desktop Management technologies & news.