winget-cli
winget-cli copied to clipboard
microsoft
winget upgrade of Microsoft.SQLServerManagementStudio from v19.3 to 20.0 fails
Brief description of your issue
Wanted to upgrade SQL Server Management Studio v19.3 to 20.0 through winget, executed:
winget list --upgrade-available --source=winget and realized the upgrade to 20.0 was available, so executed:
winget upgrade Microsoft.SQLServerManagementStudio and it looks like it upgraded the package, but when I open SQL Server Management Studio and check the version, it's still v19.3 instead of 20.0, when I run the upgrade command again I get:
No installed package found matching input criteria.
Steps to reproduce
winget list --upgrade-available --source=winget winget upgrade Microsoft.SQLServerManagementStudio
Expected behavior
SQL Server Management Studio successfully upgraded to 20.0
Actual behavior
SQL Server Management Studio is still v19.3 after upgrading the package through winget
Environment
Windows Package Manager v1.7.10661
Copyright (c) Microsoft Corporation. All rights reserved.
Windows: Windows.Desktop v10.0.19045.4170
System Architecture: X64
Package: Microsoft.DesktopAppInstaller v1.22.10661.0
Winget Directories
-------------------------------------------------------------------------------------------------------------------------------
Logs %LOCALAPPDATA%\Packages\Microsoft.DesktopAppInstaller_8wekyb3d8bbwe\LocalState\DiagOutputDir
User Settings %LOCALAPPDATA%\Packages\Microsoft.DesktopAppInstaller_8wekyb3d8bbwe\LocalState\settings.json
Portable Links Directory (User) %LOCALAPPDATA%\Microsoft\WinGet\Links
Portable Links Directory (Machine) C:\Program Files\WinGet\Links
Portable Package Root (User) %LOCALAPPDATA%\Microsoft\WinGet\Packages
Portable Package Root C:\Program Files\WinGet\Packages
Portable Package Root (x86) C:\Program Files (x86)\WinGet\Packages
Installer Downloads %USERPROFILE%\Downloads
Links
---------------------------------------------------------------------------
Privacy Statement https://aka.ms/winget-privacy
License Agreement https://aka.ms/winget-license
Third Party Notices https://aka.ms/winget-3rdPartyNotice
Homepage https://aka.ms/winget
Windows Store Terms https://www.microsoft.com/en-us/storedocs/terms-of-sale
Admin Setting State
--------------------------------------------------
LocalManifestFiles Disabled
BypassCertificatePinningForMicrosoftStore Disabled
InstallerHashOverride Disabled
LocalArchiveMalwareScanOverride Disabled
Hi I'm an AI powered bot that finds similar issues based off the issue title.
Please view the issues below to see if they solve your problem, and if the issue describes your problem please consider closing this one and thumbs upping the other issue to help us prioritize it. Thank you!
Open similar issues:
- installed SQLServerManagementStudio in both versions, winget command for SSMS is don't work (#3055), similarity score: 0.77
Closed similar issues:
- Improper versions being reported by "upgrade" - Sql Server Management Studio (#828), similarity score: 0.78
- After Upgrading SQL Server Management Studio winget see three of it's packages as out-of-date. (#2269), similarity score: 0.77
- Upgrade doesn't work for Microsoft.VisualStudio.2019.BuildTools (#1324), similarity score: 0.75
- Multiple same name packages appeared right after the package upgrade (#2152), similarity score: 0.75
Note: You can give me feedback by thumbs upping or thumbs downing this comment.
![github-actions[bot] avatar](https://avatars.githubusercontent.com/in/15368?v=4 "Published by a pub.dev verified publisher"){kind=small}
Can you run winget list "SQL Server"? This package is known to install side by side, causing the old version to still be detected as being outdated even though the newer version is also installed
I have the same issue (But I manually already upgraded to version 20). winget still shows there is an update:
winget update
Name Id Version Available Source
------------------------------------------------------------------------------------------------------------
Microsoft SQL Server Management Studio - 19.3 Microsoft.SQLServerManagementStudio 19.3 20.0 winget
1 upgrades available.
1 package(s) have version numbers that cannot be determined. Use --include-unknown to see all results.
winget list "SQL Server"
Name Id Version Available Source
------------------------------------------------------------------------------------------------------------------
Microsoft SQL Server 2019 LocalDB {36E492B8-CB83-4DA5-A5D2-D99A8E8228A1} 15.0.4153.1
Microsoft ODBC Driver 17 for SQL Server {57B9F896-DE52-4CFA-B7DE-9EFD00A1E020} 17.10.5.1
Microsoft System CLR Types for SQL Server 2019 Microsoft.CLRTypesSQLServer.2019 15.0.2000.5 winget
Microsoft OLE DB Driver for SQL Server {EBC362C3-E2BD-41A6-BC10-F07D52F1509E} 18.6.7.0
Microsoft SQL Server Management Studio - 20.0 Microsoft.SQLServerManagementStudio 20.0 winget
Microsoft SQL Server Management Studio - 19.3 Microsoft.SQLServerManagementStudio 19.3 20.0 winget
winget update --id Microsoft.SQLServerManagementStudio --exact --accept-source-agreements --silent --disable-interactivity --accept-package-agreements --force --include-unknown
No installed package found matching input criteria.
I can manually uninstall 19.3, but the idea was to use winget to do the upgrade not intervene manually.
We're doing some work for packages that install side-by-side. I'm hoping to get a build out in the next few days for WinGet 1.8-preview so users can test with the experimental feature.
We've been working on the side-by-side scenarios. You could try the latest release and enable the experimental feature on:
- https://github.com/microsoft/winget-cli/releases/tag/v1.8.924-preview
Please provide feedback at:
- https://github.com/microsoft/winget-cli/discussions/4281
If the software is meant to be installed side by side, maybe it needs its own ID and shouldn't be shown as an update?
