[Package Issue]: Microsoft.SQLServerManagementStudio

[Matt-17]

Please confirm these before moving forward

• I have searched for my issue and not found a work-in-progress/duplicate/resolved issue.
• I have not been informed if the issue is resolved in a preview version of the winget client.

Category of the issue

Installation issue.

Brief description of your issue

winget update shows me an update for this package. I try to update this which is successful. Afterwards it's still the same version and an update is available.

PS C:\Windows\system32> winget update --all
Name                                          ID                                  Version Verfügbar Quelle
----------------------------------------------------------------------------------------------------------
Microsoft SQL Server Management Studio - 20.2 Microsoft.SQLServerManagementStudio 20.2    20.2.1    winget
1 Aktualisierungen verfügbar.

(1/1) Gefunden Microsoft SQL Server Management Studio [Microsoft.SQLServerManagementStudio] Version 20.2.1
Diese Anwendung wird von ihrem Besitzer an Sie lizenziert.
Microsoft ist nicht verantwortlich und erteilt keine Lizenzen für Pakete von Drittanbietern.
Download läuft https://download.microsoft.com/download/7519f0ff-997c-4f36-b5aa-9a51d47dd34c/SSMS-Setup-DEU.exe
  ██████████████████████████████   489 MB /  489 MB
Der Installer-Hash wurde erfolgreich überprüft
Paketinstallation wird gestartet...
Erfolgreich installiert

Mindestens 134 Paket verfügt über Versionsnummern, die nicht ermittelt werden können. Verwenden Sie „--include-unknown“, um alle Ergebnisse anzuzeigen.
PS C:\Windows\system32> winget update
Name                                          ID                                  Version Verfügbar Quelle
----------------------------------------------------------------------------------------------------------
Microsoft SQL Server Management Studio - 20.2 Microsoft.SQLServerManagementStudio 20.2    20.2.1    winget
1 Aktualisierungen verfügbar.

Steps to reproduce

Install Microsoft.SQLServerManagementStudio in Version 20.2. Try winget update and look for available updates afterwards.

Actual behavior

Update was not done successful.

Expected behavior

Update should be done and should be removed from available updates.

Environment

PS C:\Windows\system32> winget --info
Windows-Paket-Manager v1.10.390
Copyright (c) Microsoft Corporation. Alle Rechte vorbehalten.

Windows: Windows.Desktop v10.0.19045.5965
Systemarchitektur: X64
Paket: Microsoft.DesktopAppInstaller v1.25.390.0

WinGet-Verzeichnisse
-----------------------------------------------------------------------------------------------------------------------
Protokolle                                   %LOCALAPPDATA%\Packages\Microsoft.DesktopAppInstaller_8wekyb3d8bbwe\Local…
Benutzereinstellungen                        %LOCALAPPDATA%\Packages\Microsoft.DesktopAppInstaller_8wekyb3d8bbwe\Local…
Verzeichnis für portierbare Links (Benutzer) %LOCALAPPDATA%\Microsoft\WinGet\Links
Portables Linkverzeichnis (Computer)         C:\Program Files\WinGet\Links
Portierbarer Paketstamm (Benutzer)           %LOCALAPPDATA%\Microsoft\WinGet\Packages
Portierbarer Paketstamm                      C:\Program Files\WinGet\Packages
Portierbares Paketstamm (x86)                C:\Program Files (x86)\WinGet\Packages
Installationsprogrammdownloads               %USERPROFILE%\Downloads
Konfigurationsmodule                         %LOCALAPPDATA%\Microsoft\WinGet\Configuration\Modules

Links
-----------------------------------------------------------------------------------------
Datenschutzerklärung              https://aka.ms/winget-privacy
Lizenzvereinbarung                https://aka.ms/winget-license
Hinweise von Drittanbietern       https://aka.ms/winget-3rdPartyNotice
Startseite                        https://aka.ms/winget
Windows Store-Nutzungsbedingungen https://www.microsoft.com/en-us/storedocs/terms-of-sale

Administratoreinstellung                  Status
-----------------------------------------------------
LocalManifestFiles                        Deaktiviert
BypassCertificatePinningForMicrosoftStore Deaktiviert
InstallerHashOverride                     Deaktiviert
LocalArchiveMalwareScanOverride           Deaktiviert
ProxyCommandLineOptions                   Deaktiviert
DefaultProxy                              Deaktiviert
PS C:\Windows\system32>

Screenshots and Logs

No response

[Dragon1573]

Could you please try uninstall version v20.2 and then reinstall v20.2.1? Will it wipe your configurations?

It might also because SSMS will not upgrade Windows Registry.

Git diffs

diff --git a/manifests/m/Microsoft/SQLServerManagementStudio/20.2/Microsoft.SQLServerManagementStudio.installer.yaml b/manifests/m/Microsoft/SQLServerManagementStudio/20.2.1/Microsoft.SQLServerManagementStudio.installer.yaml
index bc9b768f5f6..1694ac65c58 100644
--- a/manifests/m/Microsoft/SQLServerManagementStudio/20.2/Microsoft.SQLServerManagementStudio.installer.yaml
+++ b/manifests/m/Microsoft/SQLServerManagementStudio/20.2.1/Microsoft.SQLServerManagementStudio.installer.yaml
@@ -1,6 +1,6 @@
 # yaml-language-server: $schema=https://aka.ms/winget-manifest.installer.1.6.0.schema.json
 PackageIdentifier: Microsoft.SQLServerManagementStudio
-PackageVersion: '20.2'
+PackageVersion: '20.2.1'
 Platform:
 - Windows.Desktop
 MinimumOSVersion: 10.0.0.0
@@ -12,127 +12,127 @@ InstallerSwitches:
   Custom: /norestart
 FileExtensions:
 - SQL
-ReleaseDate: 2024-07-09
+ReleaseDate: 2025-04-08
 Installers:
 - InstallerLocale: de-DE
   Architecture: x64
   InstallerType: burn
   Scope: machine
-  InstallerUrl: https://download.microsoft.com/download/9/b/e/9bee9f00-2ee2-429a-9462-c9bc1ce14c28/SSMS-Setup-DEU.exe
-  InstallerSha256: BABDFBAF6319C58C2C6506FDFBDCAF165603C7CE2B60565C8A7330BDCD3C1BB3
+  InstallerUrl: https://download.microsoft.com/download/7519f0ff-997c-4f36-b5aa-9a51d47dd34c/SSMS-Setup-DEU.exe
+  InstallerSha256: A297FAB7F73F196F4F2459118E5AA1494F0BC399AD8F9BB75A1D33EEF804F2F9
   AppsAndFeaturesEntries:
-  - DisplayName: Microsoft SQL Server Management Studio - 20.2
-    DisplayVersion: 20.2.30.0
-    ProductCode: '{02296613-32f3-470c-90e5-310a732bd7a0}'
+  - DisplayName: Microsoft SQL Server Management Studio - 20.2.1
+    DisplayVersion: 20.2.37.0
+    ProductCode: '{b44525d8-2abb-493e-8956-d6dc75cc1460}'
 - InstallerLocale: en-US
   Architecture: x64
   InstallerType: burn
   Scope: machine
-  InstallerUrl: https://download.microsoft.com/download/9/b/e/9bee9f00-2ee2-429a-9462-c9bc1ce14c28/SSMS-Setup-ENU.exe
-  InstallerSha256: 12DD3B24330AD074DBB71F28AD06EAAA9757BD5C9A750ADD5088C4DB54A7D4F6
+  InstallerUrl: https://download.microsoft.com/download/7519f0ff-997c-4f36-b5aa-9a51d47dd34c/SSMS-Setup-ENU.exe
+  InstallerSha256: 1B3A54A08A258C6768F4AF726CFE97123478AAF7E8EDA6503054D20E354638EF
   AppsAndFeaturesEntries:
-  - DisplayName: Microsoft SQL Server Management Studio - 20.2
-    DisplayVersion: 20.2.30.0
-    ProductCode: '{98566bce-3110-4bc9-b372-a014a6eb5b58}'
+  - DisplayName: Microsoft SQL Server Management Studio - 20.2.1
+    DisplayVersion: 20.2.37.0
+    ProductCode: '{22baa1c2-262f-4194-9cc7-84403b8e16f1}'
 - InstallerLocale: es-ES
   Architecture: x64
   InstallerType: burn
   Scope: machine
-  InstallerUrl: https://download.microsoft.com/download/9/b/e/9bee9f00-2ee2-429a-9462-c9bc1ce14c28/SSMS-Setup-ESN.exe
-  InstallerSha256: 063F52CB37FEF908F5B46C8EC02C51ED490EF1F92F5569B0193525E4D8D7F111
+  InstallerUrl: https://download.microsoft.com/download/7519f0ff-997c-4f36-b5aa-9a51d47dd34c/SSMS-Setup-ESN.exe
+  InstallerSha256: 6842487944B8B88337C5DDF21CF95DAECE7399DCED9CE373E098B1483F6392E8
   AppsAndFeaturesEntries:
-  - DisplayName: Microsoft SQL Server Management Studio - 20.2
-    DisplayVersion: 20.2.30.0
-    ProductCode: '{0a4a81fe-01f7-4bde-8fe0-b69adeae3873}'
+  - DisplayName: Microsoft SQL Server Management Studio - 20.2.1
+    DisplayVersion: 20.2.37.0
+    ProductCode: '{ef48d72d-6efd-4a02-a237-d16b498d254d}'
 - InstallerLocale: fr-FR
   Architecture: x64
   InstallerType: burn
   Scope: machine
-  InstallerUrl: https://download.microsoft.com/download/9/b/e/9bee9f00-2ee2-429a-9462-c9bc1ce14c28/SSMS-Setup-FRA.exe
-  InstallerSha256: 423E813C5F14E4F548B07C5A27A78A37D70D883CE987850590397B8C7A461A24
+  InstallerUrl: https://download.microsoft.com/download/7519f0ff-997c-4f36-b5aa-9a51d47dd34c/SSMS-Setup-FRA.exe
+  InstallerSha256: 52687FDE034B79E38168A3D7B7DDEA4D0E881842D594F43079D46636EE4D650C
   AppsAndFeaturesEntries:
-  - DisplayName: Microsoft SQL Server Management Studio - 20.2
-    DisplayVersion: 20.2.30.0
-    ProductCode: '{c56058b0-bda3-41a0-8144-c70f1a096f55}'
+  - DisplayName: Microsoft SQL Server Management Studio - 20.2.1
+    DisplayVersion: 20.2.37.0
+    ProductCode: '{afc15db5-206a-4e0d-a228-74cf73567b61}'
 - InstallerLocale: it-IT
   Architecture: x64
   InstallerType: burn
   Scope: machine
-  InstallerUrl: https://download.microsoft.com/download/9/b/e/9bee9f00-2ee2-429a-9462-c9bc1ce14c28/SSMS-Setup-ITA.exe
-  InstallerSha256: 8132E17E2903095EE79405098DE48D5755EF1D5E86B028424846793BCC76A868
+  InstallerUrl: https://download.microsoft.com/download/7519f0ff-997c-4f36-b5aa-9a51d47dd34c/SSMS-Setup-ITA.exe
+  InstallerSha256: 3879E56DC164E67D0D260E562926C438244B420DCE7C09205905C8356FAA1AB6
   AppsAndFeaturesEntries:
-  - DisplayName: Microsoft SQL Server Management Studio - 20.2
-    DisplayVersion: 20.2.30.0
-    ProductCode: '{cb4fc5fc-6318-4a4d-a7e9-244633cd1cb3}'
+  - DisplayName: Microsoft SQL Server Management Studio - 20.2.1
+    DisplayVersion: 20.2.37.0
+    ProductCode: '{e4f877b9-3937-48c4-a00b-d45311f5a029}'
 - InstallerLocale: ja-JP
   Architecture: x64
   InstallerType: burn
   Scope: machine
-  InstallerUrl: https://download.microsoft.com/download/9/b/e/9bee9f00-2ee2-429a-9462-c9bc1ce14c28/SSMS-Setup-JPN.exe
-  InstallerSha256: 32B61F4E661E19B66B094BD473C018CC99EDA15D353FBD748232FE293425BE01
+  InstallerUrl: https://download.microsoft.com/download/7519f0ff-997c-4f36-b5aa-9a51d47dd34c/SSMS-Setup-JPN.exe
+  InstallerSha256: 9E86398E6F905A201620698F2C5300115AFDD998867183C43C22F9F57D402C68
   AppsAndFeaturesEntries:
-  - DisplayName: Microsoft SQL Server Management Studio - 20.2
-    DisplayVersion: 20.2.30.0
-    ProductCode: '{e691bc66-89cc-41a9-ad1f-0080b27d0a93}'
+  - DisplayName: Microsoft SQL Server Management Studio - 20.2.1
+    DisplayVersion: 20.2.37.0
+    ProductCode: '{78090085-591e-4010-a457-9fb4759b8367}'
 - InstallerLocale: ko-KR
   Architecture: x64
   InstallerType: burn
   Scope: machine
-  InstallerUrl: https://download.microsoft.com/download/9/b/e/9bee9f00-2ee2-429a-9462-c9bc1ce14c28/SSMS-Setup-KOR.exe
-  InstallerSha256: A7D24A0B81959DD6B6E015FE11F628C8B014527C7852BBA09C208A82157C23DA
+  InstallerUrl: https://download.microsoft.com/download/7519f0ff-997c-4f36-b5aa-9a51d47dd34c/SSMS-Setup-KOR.exe
+  InstallerSha256: 13329A7FADFC80B3FAD3AF3FAA2DEAAA6D8594FEDD6FBB4C5032B00322AB6BF9
   AppsAndFeaturesEntries:
-  - DisplayName: Microsoft SQL Server Management Studio - 20.2
-    DisplayVersion: 20.2.30.0
-    ProductCode: '{b7912837-e34f-47e7-881a-783134b0cfd7}'
+  - DisplayName: Microsoft SQL Server Management Studio - 20.2.1
+    DisplayVersion: 20.2.37.0
+    ProductCode: '{1f6acf77-fe38-49ea-824d-0096f8cbe6ad}'
 - InstallerLocale: pt-BR
   Architecture: x64
   InstallerType: burn
   Scope: machine
-  InstallerUrl: https://download.microsoft.com/download/9/b/e/9bee9f00-2ee2-429a-9462-c9bc1ce14c28/SSMS-Setup-PTB.exe
-  InstallerSha256: FEB57EDF77310793DAA275D2A161E6306EF94A4ED80B568E49247953D1D0CCD5
+  InstallerUrl: https://download.microsoft.com/download/7519f0ff-997c-4f36-b5aa-9a51d47dd34c/SSMS-Setup-PTB.exe
+  InstallerSha256: FBF8BA018B13CF0F9FAB025BAD12628466E7A33680FD2DCA01F2DA6EF80D2EDF
   AppsAndFeaturesEntries:
-  - DisplayName: Microsoft SQL Server Management Studio - 20.2
-    DisplayVersion: 20.2.30.0
-    ProductCode: '{36c5b387-58b9-4ea9-9725-bbf0e54adb3a}'
+  - DisplayName: Microsoft SQL Server Management Studio - 20.2.1
+    DisplayVersion: 20.2.37.0
+    ProductCode: '{cec38ea1-6f8c-44bf-a46a-267a5aa18ef7}'
 - InstallerLocale: ru-RU
   Architecture: x64
   InstallerType: burn
   Scope: machine
-  InstallerUrl: https://download.microsoft.com/download/9/b/e/9bee9f00-2ee2-429a-9462-c9bc1ce14c28/SSMS-Setup-RUS.exe
-  InstallerSha256: 05F27C102488CA7BCFF7F3A224C16F54B0D5B61815D3F36AA41AFD643084D660
+  InstallerUrl: https://download.microsoft.com/download/7519f0ff-997c-4f36-b5aa-9a51d47dd34c/SSMS-Setup-RUS.exe
+  InstallerSha256: A99D099C45090A733D0462EEEE1836918C26E08C5B91C9617E519D325B35B03F
   AppsAndFeaturesEntries:
-  - DisplayName: Microsoft SQL Server Management Studio - 20.2
-    DisplayVersion: 20.2.30.0
-    ProductCode: '{e518a9ec-e8c5-4160-a2f8-045cb262265f}'
+  - DisplayName: Microsoft SQL Server Management Studio - 20.2.1
+    DisplayVersion: 20.2.37.0
+    ProductCode: '{0c95c357-1ddb-45c8-b50c-29d42582aefa}'
 - InstallerLocale: zh-CN
   Architecture: x64
   InstallerType: burn
   Scope: machine
-  InstallerUrl: https://download.microsoft.com/download/9/b/e/9bee9f00-2ee2-429a-9462-c9bc1ce14c28/SSMS-Setup-CHS.exe
-  InstallerSha256: 16ACCD406CA42BC24C75AA827E552364FCBB47375706513061857957733B607D
+  InstallerUrl: https://download.microsoft.com/download/7519f0ff-997c-4f36-b5aa-9a51d47dd34c/SSMS-Setup-CHS.exe
+  InstallerSha256: 7BA7522B6E57304ECAE6BD0ED3B12C3F959539243F1017D1E5E1CE2AA880446B
   AppsAndFeaturesEntries:
-  - DisplayName: Microsoft SQL Server Management Studio - 20.2
-    DisplayVersion: 20.2.30.0
-    ProductCode: '{f0d7043a-c159-49f5-a6de-c9395d1769e5}'
+  - DisplayName: Microsoft SQL Server Management Studio - 20.2.1
+    DisplayVersion: 20.2.37.0
+    ProductCode: '{82456591-1346-485b-afd5-ea521b4a6dcc}'
 - InstallerLocale: zh-HK
   Architecture: x64
   InstallerType: burn
   Scope: machine
-  InstallerUrl: https://download.microsoft.com/download/9/b/e/9bee9f00-2ee2-429a-9462-c9bc1ce14c28/SSMS-Setup-CHT.exe
-  InstallerSha256: D90B59F92DFDB6CF9AC2A8730DC323AF156ACFE075AB4D1E37A7B51C96ED5DDF
+  InstallerUrl: https://download.microsoft.com/download/7519f0ff-997c-4f36-b5aa-9a51d47dd34c/SSMS-Setup-CHT.exe
+  InstallerSha256: 680BDE74F4CC26434ABDD9A449C732E2831573307F6967D1CE1946F0E93915FF
   AppsAndFeaturesEntries:
-  - DisplayName: Microsoft SQL Server Management Studio - 20.2
-    DisplayVersion: 20.2.30.0
-    ProductCode: '{f871a43b-6faf-4ee8-afc1-69b7920c6129}'
+  - DisplayName: Microsoft SQL Server Management Studio - 20.2.1
+    DisplayVersion: 20.2.37.0
+    ProductCode: '{244bd01c-6354-42d0-b4b6-a8c32d846299}'
 - InstallerLocale: zh-TW
   Architecture: x64
   InstallerType: burn
   Scope: machine
-  InstallerUrl: https://download.microsoft.com/download/9/b/e/9bee9f00-2ee2-429a-9462-c9bc1ce14c28/SSMS-Setup-CHT.exe
-  InstallerSha256: D90B59F92DFDB6CF9AC2A8730DC323AF156ACFE075AB4D1E37A7B51C96ED5DDF
+  InstallerUrl: https://download.microsoft.com/download/7519f0ff-997c-4f36-b5aa-9a51d47dd34c/SSMS-Setup-CHT.exe
+  InstallerSha256: 680BDE74F4CC26434ABDD9A449C732E2831573307F6967D1CE1946F0E93915FF
   AppsAndFeaturesEntries:
-  - DisplayName: Microsoft SQL Server Management Studio - 20.2
-    DisplayVersion: 20.2.30.0
-    ProductCode: '{f871a43b-6faf-4ee8-afc1-69b7920c6129}'
+  - DisplayName: Microsoft SQL Server Management Studio - 20.2.1
+    DisplayVersion: 20.2.37.0
+    ProductCode: '{244bd01c-6354-42d0-b4b6-a8c32d846299}'
 ManifestType: installer
 ManifestVersion: 1.6.0