How do you install SQL Server 2019 using Microsoft Intune

acarr urbanscience 1 Reputation point
2021-04-22T14:22:59.293+00:00

I converted the SQL exe tool to intunewin format, but there are many additional files needed to fully set up the application in silent mode that i do not know how to include in the intune win32 application package option. Also, i wanted to use a batch script to uninstall the application to run some commands to remove any left over sql folders and i cant find a way to add a batch file. Any help or guidance, reference to a KB article or anything will be appreciated

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,184 questions
Microsoft Intune Application management
Microsoft Intune Application management
Microsoft Intune: A Microsoft cloud-based management solution that offers mobile device management, mobile application management, and PC management capabilities.Application management: The process of creating, configuring, managing, and monitoring applications.
908 questions
0 comments

4 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Sukhbaj Singh 5 Reputation points
    2024-05-31T05:25:41.93+00:00

    The best way to install SSMS via Intune is similar to how we push other apps through Intune. Once you have created the .intunewin file for SSMS, follow these steps:

    -Go to the Microsoft Endpoint Manager admin center.
    -Log in with your admin credentials.
    -Navigate to Apps > All apps > Add.
    -In the Select app type pane, choose Windows app (Win32), and click Select.
    -Upload the .intunewin file which you created.
    -Fill in the required app information such as Name, Description, and Publisher.
    -Configure the installation program to use the command: SSMS-Setup-ENU.exe /install /quiet /norestart
    -Configure the uninstall command (if applicable): "%ProgramFiles(x86)%\Microsoft SQL Server Management Studio 18\Common7\IDE\SsmsUninstall.exe" /uninstall /quiet /norestart

    Detection Rules:
    -Configure the detection rules to ensure Intune can detect if SSMS is installed:
    Type: File
    Path: C:\Program Files (x86)\Microsoft SQL Server Management Studio 18\Common7\IDE\Ssms.exe
    Requirements:
    -Specify any system requirements for SSMS.
    Dependencies:
    -Add any dependencies if necessary.
    Assign the App:
    -Assign the app to user or device groups as needed. You can do this under Assignments

    Review + Create:
    -Review the app configuration and create the app.

    1 person found this answer helpful.
    0 comments
  2. Cici Wu-MSFT 1,176 Reputation points
    2021-04-23T03:23:06.363+00:00

    I consult with SQL engineer and it seems that the SQL Server 2019 cannot be installed in silent mode as there is some prompt during the installation, such as typing account and password. See: https://video2.skills-academy.com/en-us/mem/intune/apps/apps-win32-app-management

  3. Martin Don 1 Reputation point
    2022-01-13T22:16:21.153+00:00

    There is a way to install this using silent mode. I have managed to do this but it seems it fails on the uninstall as the setup.exe is not in the same location as the installation. This is really frustrating as I need to install around 15 laptops with SQL server for Sales Consultants. The error that I get from intune is very generic though.

    164938-image.png

  4. Jay-R Barrios 1 Reputation point
    2022-09-23T08:12:39.217+00:00

    I had the same requirement recently, after several test i managed to deploy SQL express via intune with these steps.

    https://jayrbarrios.com/2022/09/22/how-to-install-sql-server-2019-express-from-intune/

    0 comments