Microsoft SQL Server Management Studio (SSMS) Guide

[arbk]

With the release of Microsoft SQL Server Management Studio 22, we have introduced an improved solution for patching, deployment, and uninstallation.
Users are no longer required to submit an installer manually, and automatic patching is now available.
However, this change breaks the existing PatchPro update chains, and they must be manually replaced by deleting the current configurations and publishing new ones.

PatchPro Configurations
PatchPro provides three configurations for SSMS:

1. Microsoft SQL Server Management Studio (Install:Only) (x64) (EXE)

2. Microsoft SQL Server Management Studio (Upgrade:Only) (x64) (EXE)

3. Uninstall Microsoft SQL Server Management Studio 21

Recommended Migration Process (SSMS 21 → SSMS 22)
If your systems are currently running SSMS 21, we recommend the following steps:

Publish all three configurations listed above.

1. Assign Uninstall Microsoft SQL Server Management Studio 21 to all systems you plan to upgrade.

2. Assign Microsoft SQL Server Management Studio (Install:Only) to install SSMS 22 onto all systems.

3. After all systems have been upgraded and SSMS 21 has been fully replaced by SSMS 22:

   • You can delete the assignments or the entire configurations.

   • Then assign Microsoft SQL Server Management Studio (Upgrade:Only) (x64) (EXE) to enable future automatic patching.

VulnDetect Notes

To upgrade from SSMS 21 → SSMS 22, it is necessary to uninstall SSMS 21 first.
We now provide uninstall jobs for all SSMS versions.

To complete the upgrade:

1. Create an uninstall job for SSMS 21 (or any previous version).

2. Create an install job for SSMS 22.

3. Once the uninstall/install job sequence has completed, your systems will be fully prepared for future automatic patching of SSMS 22.