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

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 Cancel reply

Community Version

Recent App Tips

ScaleFT ScaleFT 1.84.0
October 10, 2024
Microsoft Windows SDK 10.1.22621.2428
October 10, 2024
RODE Connect 1.3.39
October 2, 2024
Geek Software PDF24 Creator 11.20.1
October 2, 2024
SRWare Iron 127.0.6450.0
October 2, 2024

Upcoming Events

october 2024

11oct8:00 am7:00 pmAppManagEvent 2024

Upcoming Courses

october 2024

09sep(sep 9)9:00 am13dec(dec 13)4:30 pmUSA: Learning MSI Projects with InstallShield 2024

Event Details

The InstallShield, MSI Projects course provides you with a solid understanding of installation terminology, the tasks an installation program needs to perform, and the InstallShield development environment.

In this course, you will learn how to customize your installation with custom actions in order to make changes to your end users’ systems. You will also see how to correctly identify, install, and configure special types of files (e.g. COM servers, Windows services, and .NET assemblies). Finally, you will understand how to perform simple to sophisticated changes to your installation’s user interface.

This course teaches you how to create Basic MSI projects, which use the Windows Installer service (MSI) for the installation’s behaviour and appearance. This course does not cover InstallScript MSI projects.

OBJECTIVES

In this class you will learn how to:

Create and organize an installation project
Install files and create shortcuts
Install and configure special types of files and data, such as registry and INI data, COM servers, Windows services, and .NET assemblies
Work with MSI sequences and custom actions
Customize your installer’s user interface
Package your installer for Windows Vista, Windows 7, and later
Use the Automation interface to modify your project outside the graphical environment

COURSE PREREQUISITES

Previous InstallShield experience is not required; however, you should be comfortable with the following:

Using Windows Explorer and the command prompt to create and manage files, and run executables
Basic Windows terminology (e.g. DLL, Control Panel, etc.)

Later sections of the course assume familiarity with programming or scripting languages such as VBScript, C or C++, and C#.

Time

September 9 (Monday) 9:00 am - December 13 (Friday) 4:30 pm(GMT-05:00) View in my time

Location

Online

Register Here!

Calendar GoogleCal

Organizer

T-Lux Group

TLUX was founded in 2014 and since then has been leveraging over 25 years experience in the Application Packaging, Installation Authoring and End-User Computing/Desktop Deployment space. Operating out of two bases in London and Ulm, Germany – we are the global certified Professional Services provider for Flexera and Revenera as well as having a global partner network throughout EMEA, the USA and APAC – bringing our world class consulting and training offerings to clients of all shapes, sizes and industries. We have a wide range of services offerings from training and bespoke workshops, through to complete AdminStudio implementations and integrations, an Application Packaging ‘Factory’ capability as well as helping manage and maintain the installation strategies, builds and deployment configurations for many organisations. Letting them get on with their core business.

124 City Road, London, EC1V 2NX, United Kingdom

30sep(sep 30)9:00 am04oct(oct 4)4:30 pmUSA: Application Packaging with AdminStudio 2024

Event Details

The AdminStudio application packaging training course will teach you to use AdminStudio to repackage traditional setups into Windows Installer packages and customize those packages to meet specific needs. Learn application packaging best practices and much more.

In this application packaging training course, you will also gain experience in creating transforms for existing third-party MSI packages and improving package quality through identifying and resolving conflicts between packages, validation and automated tests before deploying your applications.

OBJECTIVES

In this class you will learn:

How to prepare your development systems, test systems and documentation for the application-migration process
How to use AdminStudio’s Repackager to convert traditional setups to Windows Installer setups and virtual applications
How to enhance and customize repackaged setups using the InstallShield Editor and to correct validation errors
How to use AdminStudio’s Test Center to identify and resolve potential issues using automated test cases and Best Practices.
How to manage the Application Catalog and workflows
How to keep your Application Catalog up to date via the Package Feed Module
How to use AdminStudio’s Tuner to customize the installation of existing Windows Installer setups——to meet your company-specific requirements
How to convert MSI packages to virtual packages

COURSE PREREQUISITES

Previous AdminStudio experience is not required; however, you should be comfortable with the following:

Using Windows Explorer and the command prompt to create and manage files and run executables
Basic Windows terminology (e.g. DLL, Control Panel, etc.)

Time

September 30 (Monday) 9:00 am - October 4 (Friday) 4:30 pm(GMT-05:00) View in my time

Location

Online

Register Here!

Calendar GoogleCal

Organizer

T-Lux Group

124 City Road, London, EC1V 2NX, United Kingdom

07oct(oct 7)9:00 am11(oct 11)4:30 pmAUS: Application Packaging with AdminStudio 2024

Event Details

OBJECTIVES

In this class you will learn:

How to prepare your development systems, test systems and documentation for the application-migration process
How to use AdminStudio’s Repackager to convert traditional setups to Windows Installer setups and virtual applications
How to enhance and customize repackaged setups using the InstallShield Editor and to correct validation errors
How to use AdminStudio’s Test Center to identify and resolve potential issues using automated test cases and Best Practices.
How to manage the Application Catalog and workflows
How to keep your Application Catalog up to date via the Package Feed Module
How to use AdminStudio’s Tuner to customize the installation of existing Windows Installer setups——to meet your company-specific requirements
How to convert MSI packages to virtual packages

COURSE PREREQUISITES

Previous AdminStudio experience is not required; however, you should be comfortable with the following:

Using Windows Explorer and the command prompt to create and manage files and run executables
Basic Windows terminology (e.g. DLL, Control Panel, etc.)

Time

7 (Monday) 9:00 am - 11 (Friday) 4:30 pm(GMT+11:00) View in my time

Location

Online

Calendar GoogleCal

Organizer

T-Lux Group

124 City Road, London, EC1V 2NX, United Kingdom

14oct(oct 14)9:00 am18(oct 18)4:30 pmEMEA: Learning MSI Projects with InstallShield 2024

Event Details

In this course, you will learn how to customize your installation with custom actions in order to make changes to your end users’ systems. You will also see how to correctly identify, install, and configure special types of files (e.g., COM servers, Windows services, and .NET assemblies). Finally, you will understand how to perform simple to sophisticated changes to your installation’s user interface.

This course teaches you how to create Basic MSI projects, which use the Windows Installer service (MSI) for the installation’s behavior and appearance. This course does not cover InstallScript MSI projects.

COURSE OBJECTIVES

In this class you will learn how to:

Create and organize an installation project
Install files and create shortcuts
Install and configure special types of files and data, such as registry and INI data, COM servers, Windows services, and .NET assemblies
Work with MSI sequences and custom actions
Customize your installer’s user interface
Package your installer for Windows Vista, Windows 7, and later
Use the Automation interface to modify your project outside the graphical environment

COURSE PREREQUISITES

Previous InstallShield experience is not required; however, you should be comfortable with the following:

Using Windows Explorer and the command prompt to create and manage files, and run executables
Basic Windows terminology (e.g. DLL, Control Panel, etc.)

Later sections of the course assume familiarity with programming or scripting languages such as VBScript, C or C++, and C#.

Time

14 (Monday) 9:00 am - 18 (Friday) 4:30 pm(GMT+00:00) View in my time

Location

Online

Register Here!

Calendar GoogleCal

Organizer

T-Lux Group

124 City Road, London, EC1V 2NX, United Kingdom

14oct(oct 14)9:00 pm18(oct 18)5:00 pmIT Pro Masters Packaging for MSIX

Event Details

TMurgent is bringing Tim Mangan and his world-renowned training back to The Netherlands, and now we focus exclusively on Packaging for MSIX.

The Masters Packaging for MSIX class will be run by TMurgent. This 4-day class is designed to accommodate students that are new to packaging, new to MSIX, and especially those with significant prior experience.

We will provide you with both theory and practical hands-on experience in our training lab. We will cover the commonly used tooling from Microsoft, our own tools, and a few others as well.

We recommend the in-person classroom experience, however remote students are accepted in this class also.

NOTE: YOU MUST REQUEST REMOTE AT LEAST 30 DAYS PRIOR TO START OF CLASS!

Prerequisites:

The course is designed for people with a general background in IT and/or Packaging. We take students with or without prior experience in MSIX. Although Software Developers are not targeted for this course, and we will not be covering developer material, Developers are welcome.

There are no hard pre-requisites to be able to take the class, however, the following are helpful:

Knowledge and experience with general Microsoft Windows Administration.
Experience with other “packaging” techniques helpful.
Experience with Application Deployment.
Help Desk Experience.

The training site will provide desktop Computers to access the Labs. You are welcome to bring your own VMs, on your laptop or back in your office via VPN, but we do provide all of the VMs you need. Remote students will provide their own VMs based on information we provide after registration.

Syllabus

IT Pro Masters Packaging for MSIX

A 4-day (in-person) or 8 half-days (when remote) hands-on class where you will learn the concepts, techniques, and latest tricks to be successful and packaging and configuring applications for delivery within the Enterprise using Microsoft MSIX.

Whether you use modern or traditional application delivery methods, the applications your company depends on must be customized, and in many cases remediated to work in today’s desktops. MSIX is the future for new applications, and while not all traditional applications will work in the MSIX container, this class will give you the ability to get the most application compatibility possible today.

Syllabus

1. Concepts of Packaging

Principals and rules of Packaging
Filter Drivers, Function hooking, and Dll Injection
MSIX technology overview
Principals of Redirection and Copy-on-Write
Anatomy of an installer package and the Windows API

2. Overview of Delivery Options

Including Configuration Manager, Intune, App Attach, PowerShell, and 3rd Party Managers.

3. Fundamentals of the MSIX Package Format and Runtime

4. Setting up VMs for Packaging and Testing

Setting up a MSIX Capture Station
Setting up a “Smoke Test” Station

5. Packaging with App-V and MSIX

Hands-on Labs covering Best Practices, VFS techniques, Modification Packages, Plug-Ins, AppInstaller updates, Shared Package Containers, the PSF Fixes, and package scripts.
PowerShell for MSIX
Using MSX Packaging Tool
The 7 fixups available from the PSF
Using PsfTooling
Using TMEditX
Using other Third-party tools for MSIX
Automation
MSIX App Attach, VHD/X and CIM

6. Debugging Techniques for MSIX and apps in general

7. Conversion from App-V to MSIX

Time

14 (Monday) 9:00 pm - 18 (Friday) 5:00 pm(GMT+02:00) View in my time

Location

PDS Training Center

Parallelweg Oost 13a, Culemborg

Register Here!

Calendar GoogleCal

Organizer

Professional Development Systems b.v.

Parallelweg Oost 13a 4103 NC Culemborg

november 2024

11nov(nov 11)9:00 am15(nov 15)4:30 pmEMEA: Application Packaging with AdminStudio 2024

Event Details

OBJECTIVES

In this class you will learn:

How to prepare your development systems, test systems and documentation for the application-migration process
How to use AdminStudio’s Repackager to convert traditional setups to Windows Installer setups and virtual applications
How to enhance and customize repackaged setups using the InstallShield Editor and to correct validation errors
How to use AdminStudio’s Test Center to identify and resolve potential issues using automated test cases and Best Practices.
How to manage the Application Catalog and workflows
How to keep your Application Catalog up to date via the Package Feed Module
How to use AdminStudio’s Tuner to customize the installation of existing Windows Installer setups——to meet your company-specific requirements
How to convert MSI packages to virtual packages

COURSE PREREQUISITES

Previous AdminStudio experience is not required; however, you should be comfortable with the following:

Using Windows Explorer and the command prompt to create and manage files and run executables
Basic Windows terminology (e.g. DLL, Control Panel, etc.)

Time

11 (Monday) 9:00 am - 15 (Friday) 4:30 pm(GMT+00:00) View in my time

Location

Online

Register Here!

Calendar GoogleCal

Organizer

T-Lux Group

124 City Road, London, EC1V 2NX, United Kingdom

25nov(nov 25)9:00 am29(nov 29)4:30 pmUSA: Learning MSI Projects with InstallShield 2024

Event Details

OBJECTIVES

In this class you will learn how to:

Create and organize an installation project
Install files and create shortcuts
Install and configure special types of files and data, such as registry and INI data, COM servers, Windows services, and .NET assemblies
Work with MSI sequences and custom actions
Customize your installer’s user interface
Package your installer for Windows Vista, Windows 7, and later
Use the Automation interface to modify your project outside the graphical environment

COURSE PREREQUISITES

Previous InstallShield experience is not required; however, you should be comfortable with the following:

Using Windows Explorer and the command prompt to create and manage files, and run executables
Basic Windows terminology (e.g. DLL, Control Panel, etc.)

Later sections of the course assume familiarity with programming or scripting languages such as VBScript, C or C++, and C#.

Time

25 (Monday) 9:00 am - 29 (Friday) 4:30 pm(GMT-06:00) View in my time

Location

Online

Register Here!

Calendar GoogleCal

Organizer

T-Lux Group

124 City Road, London, EC1V 2NX, United Kingdom

december 2024

02dec(dec 2)9:00 am06(dec 6)4:30 pmUSA: Application Packaging with AdminStudio 2024

Event Details

OBJECTIVES

In this class you will learn:

How to prepare your development systems, test systems and documentation for the application-migration process
How to use AdminStudio’s Repackager to convert traditional setups to Windows Installer setups and virtual applications
How to enhance and customize repackaged setups using the InstallShield Editor and to correct validation errors
How to use AdminStudio’s Test Center to identify and resolve potential issues using automated test cases and Best Practices.
How to manage the Application Catalog and workflows
How to keep your Application Catalog up to date via the Package Feed Module
How to use AdminStudio’s Tuner to customize the installation of existing Windows Installer setups——to meet your company-specific requirements
How to convert MSI packages to virtual packages

COURSE PREREQUISITES

Previous AdminStudio experience is not required; however, you should be comfortable with the following:

Using Windows Explorer and the command prompt to create and manage files and run executables
Basic Windows terminology (e.g. DLL, Control Panel, etc.)

Time

2 (Monday) 9:00 am - 6 (Friday) 4:30 pm(GMT-06:00) View in my time

Location

Online

Register Here!

Calendar GoogleCal

Organizer

T-Lux Group

124 City Road, London, EC1V 2NX, United Kingdom

Cookie	Duration	Description
cookielawinfo-checkbox-analytics	11 months	This cookie is set by GDPR Cookie Consent plugin. The cookie is used to store the user consent for the cookies in the category "Analytics".
cookielawinfo-checkbox-functional	11 months	The cookie is set by GDPR cookie consent to record the user consent for the cookies in the category "Functional".
cookielawinfo-checkbox-necessary	11 months	This cookie is set by GDPR Cookie Consent plugin. The cookies is used to store the user consent for the cookies in the category "Necessary".
cookielawinfo-checkbox-others	11 months	This cookie is set by GDPR Cookie Consent plugin. The cookie is used to store the user consent for the cookies in the category "Other.
cookielawinfo-checkbox-performance	11 months	This cookie is set by GDPR Cookie Consent plugin. The cookie is used to store the user consent for the cookies in the category "Performance".
viewed_cookie_policy	11 months	The cookie is set by the GDPR Cookie Consent plugin and is used to store whether or not user has consented to the use of cookies. It does not store any personal data.