Microsoft SQL Server Management Studio 18.9.2
Microsoft SQL Server Management Studio Icon
Author: Tim Mangan
Date: June 11, 2022

Repackaging tips and silent install information for Microsoft SQL Server Management Studio 18.9.2. This App Tip provides comprehensive details for conducting a silent installation of SQL Server Management Studio. It includes additional insights, such as user environment specifics, extra installation parameters, and repackaging tips.

About

Microsoft SQL Server Management Studio (SSMS) is a software application developed by Microsoft that is used for configuring, managing, and administering all components within Microsoft SQL Server. First launched with Microsoft SQL Server 2005, it is the successor to the Enterprise Manager in SQL 2000 or before. The tool includes script editors and graphical tools that work with the server's objects and features. A central feature of SSMS is the Object Explorer, which allows the user to browse, select, and act upon any of the objects within the server. It also shipped a separate Express edition that could be freely downloaded; however, recent versions of SSMS are fully capable of connecting to and managing any SQL Server Express instance. Microsoft also incorporated backward compatibility for older versions of SQL Server, thus allowing a newer version of SSMS to connect to older versions of SQL Server instances. It also comes with Microsoft SQL Server Express 2012, or users can download it separately.

General Information

Vendor Information

Microsoft

Application Name

SQL Server Management Studio

Application Version

18.9.2

Download Link

https://docs.microsoft.com/en-us/sql/ssms/download-sql-server-management-studio-ssms

License Needed

No

Vendor Install

Installation Type

Setup.exe

Architecture

x64

Application Configuration/Settings

Registry

File

AD/GPO

AAD/GPO

User Environment Data

Registry

File

Other

Infrastructure Dependencies

Description

ODBC

Connection Name

Driver

Parameters

Setup.exe parameters

MSI Public Properties

Installation Commands

Silent Install Command

Silent Uninstall Command

Repackaging Score

MSI

Unknown

MSIX

Issues known
The software was packaged on Windows 10 21H2 using Microsoft MSIX Packaging Tool 1.2022.512 both with and without the PSF using TMEditX. The PSF Launcher, FRF, and EnvVarFixups are recommended. The launch of the primary app fails; possibly it still uses unsupported COM+.

App-V

Issues known
Allow VFS Writes is recommended. Launch fails, possibly the app still has unsupported COM+.

ThinApp

Unknown

Citrix App Layer

Unknown

VMWare App Volumes

Unknown

Other

Unknown

Repackaging Tips

There is a blog post claiming that a MSIX package can work by manually turning off part of the container virtual registry, in essence using pass through keys. I did not verify that this solves all problems with the package, but looks promising until Microsoft solves the container registry issue that we are seeing on a number of apps. See https://techcommunity.microsoft.com/t5/windows-dev-appconsult/azure-virtual-desktop-avd-packaging-the-sql-server-management/ba-p/3457856

Comments

0 Comments

Submit a Comment

Your email address will not be published. Required fields are marked *

Free Download

Free Download

Upcoming Events

july 2024

02jul8:30 am5:30 pmManaged Services Summit Benelux 2024

september 2024

16sepAll Day19Workplace Ninja Summit 2024

october 2024

11oct8:00 am7:00 pmAppManagEvent 2024

Upcoming Courses

june 2024

03jun(jun 3)1:00 pm13(jun 13)5:00 pmIT Pro Masters Packaging for MSIX

24jun(jun 24)9:00 am28(jun 28)4:30 pmUSA: Application Packaging with AdminStudio 2023

july 2024

08jul(jul 8)9:00 am12(jul 12)4:30 pmUSA: Learning MSI Projects with InstallShield 2023

15jul(jul 15)9:00 am19(jul 19)4:30 pmEMEA: Application Packaging with AdminStudio 2023