How to install SQL Server 2019 Express from Intune

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.