SQL Server Management Studio (SSMS) is a free, integrated environment developed by Microsoft for managing any SQL infrastructure. It is primarily used to manage SQL Server databases, both on-premises and in the cloud (like Azure SQL Database). This article will guide you through the process of installing SQL Server Management Studio (SSMS) on Windows devices via Microsoft Intune.
The application version used in this article is SSMS 20.2
Download Link: https://aka.ms/ssmsfullsetup
Things to consider during the packaging of applications
Please specify the source folder: [APP_FOLDER_NAME]
Please specify the setup file: SSMS-Setup-ENU_20_2.exe
Please specify the output folder: [OUTPUT_APP_PACKAGE_FOLDER_NAME]
(Refer Win32 Packaging Instructions: https://sysopsinsiders.com/packaging-win32-app-for-intune-upload)
Uploading and Deploying SSMS Win32 Package into Intune
Login to Microsoft Intune Admin Center: https://intune.microsoft.com/
Upload the SSMS-Setup-ENU_20_2.intunewin win32 file
I have mentioned only the following parameters during the deployment process. Other settings are similar for every application, or you can set them as required. Make sure the following parameters, such as Install, Uninstall, and Detection Rules, are set for this application.
| Parameters | Command / Value |
| Install Command (silent) | SSMS-Setup-ENU_20_2.exe /Install /Quiet /norestart SSMSInstallRoot="C:\SSMS" |
| Uninstall Command (silent) | "C:\SSMS\Common7\IDE\Ssms.exe" /uninstall /Quiet /norestart |
| Detection Rules | Add - rule type - File |
Refer to the complete instructions provided regarding uploading and deploying the win32 App to Intune from the link below
https://sysopsinsiders.com/upload-and-deploy-win32-application-using-microsoft-intune/