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

Description

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

Free Download

Recent App Tips

ShareX ShareX 16.0.1
March 22, 2024
Martin Prikryl WinSCP 6.3.2
March 21, 2024
Open-Shell Open-Shell 4.4.191
March 15, 2024
Speedcrunch Speedcrunch 0.12
March 5, 2024
SecureMix GlassWire 3.3.664.0
February 27, 2024

Upcoming Events

september 2024

16sepAll Day19Workplace Ninja Summit 2024

october 2024

11oct8:00 am7:00 pmAppManagEvent 2024

Upcoming Courses

march 2024

25mar(mar 25)9:00 am29(mar 29)4:30 pmUSA: Application Packaging with AdminStudio 2023

Event Details

DELIVERY APPROACH: 5 day remotely delivered instructor-led live class

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.

COURSE 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 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.)

COURSE CURRICULUM

The following course sections and topics will be covered in the class. If you have a specific area that you think might need extra attention, mention it to your instructor on the first day of application packaging training.

Time

25 (Monday) 9:00 am - 29 (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

april 2024

15apr(apr 15)9:00 am19(apr 19)4:30 pmUSA: Learning MSI Projects with InstallShield 2023

Event Details

DELIVERY APPROACH: 5 day remotely delivered instructor-led live class

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

15 (Monday) 9:00 am - 19 (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

22apr(apr 22)9:00 am26(apr 26)4:30 pmEMEA: Application Packaging with AdminStudio 2023

Event Details

DELIVERY APPROACH: 5 day remotely delivered instructor-led live class

COURSE 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 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.)

COURSE CURRICULUM

Time

22 (Monday) 9:00 am - 26 (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

may 2024

13may(may 13)9:00 am17(may 17)5:00 pmIT Pro Masters Packaging for MSIXMasters Level

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

13 (Monday) 9:00 am - 17 (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

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.

About

General Information

Vendor Install

Application Configuration/Settings

User Environment Data

Infrastructure Dependencies

ODBC

Parameters

Installation Commands

Repackaging Score

Repackaging Tips

Comments

0 Comments

Submit a Comment Cancel reply

Free Download

Recent App Tips

Recent Comments

Upcoming Events

Event Details

Event Details

Covered Topics

Time

Location

Organizer

Event Details

Event Details

Time

Location

Organizer

Upcoming Courses

Event Details

Event Details

DELIVERY APPROACH: 5 day remotely delivered instructor-led live class

COURSE OBJECTIVES

COURSE PREREQUISITES

COURSE CURRICULUM

Time

Location

Register Here!

Organizer

Event Details

Event Details

DELIVERY APPROACH: 5 day remotely delivered instructor-led live class

COURSE OBJECTIVES

COURSE PREREQUISITES

Time

Location

Register Here!

Organizer

Event Details

Event Details

DELIVERY APPROACH: 5 day remotely delivered instructor-led live class

COURSE OBJECTIVES

COURSE PREREQUISITES

COURSE CURRICULUM

Time

Location

Register Here!

Organizer

Event Details

Event Details

Prerequisites:

Syllabus

Time

Location

Register Here!

Organizer