There are 3 steps you need to do
Step 1: Prepare the installation files
Follow the instructions from https://silentinstallhq.com/microsoft-sql-server-2019-express-install-and-uninstall-powershell/
Make sure you have extracted the PowerShell App Deployment Toolkit with the Deploy-SQLExpress2019.ps1 script and SQL Server Express 2019 files that includes the ConfigurationFile.ini (for the NonInteractive installation).
Below is the folder structure:
Step 2: Intunewin file creation
Download the IntuneWinAppUtil.exe from https://github.com/Microsoft/Microsoft-Win32-Content-Prep-Tool and create the .intunewin file for SQL Server Express 2019.
Step 3: Create and Deploy Windows app (Win32) in Intune
Login to the Microsoft Endpoint Manager admin center
Go to Apps > All apps > +Add > Select app type the select Windows app (Win32) in the dropdown menu and click on the Select button.
In the Add App click Select app package file and browse for the Intunewin file that you’ve created.
Fill up the App information then click Next
In Program take note of the install and uninstall commands
Install command: PowerShell.exe -ExecutionPolicy Bypass .\Deploy-SQLExpress2019.ps1 -DeploymentType “Install” -DeployMode “NonInteractive”
Uninstall command: PowerShell.exe -ExecutionPolicy Bypass .\Deploy-SQLExpress2019.ps1 -DeploymentType “Uninstall” -DeployMode “NonInteractive”
In the Requirements specify the operating system, disk, memory and processor requirements and click Next to continue
In the Detection rules choose Manually configure detection rule and selected File or folder.
In the next page, review all parameters are set for the Windows app then click Create
Wait until the uploading completes
back in Intune you should be able to see the installation status.
I hope this guide will help you in your SQL Server Express 2019 deployment from Intune and through Windows Autopilot for applications that requires it.
No comments yet.