you're reading...
Intune, SQL Server

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.

Dependencies and Supersedence (preview), Scope has been skipped in the Assignments click the +Add group to which you’re going to deploy the Win32 app in my case I’ve assigned it to a device group. Click Next to continue.

In the next page, review all parameters are set for the Windows app then click Create

Wait until the uploading completes

Go to the assigned device(s) and verify that the SQL Express 2019 has installed successfully.

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.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

%d bloggers like this: