SQL Server Management Studio SSMS 18.0 General Availability release (GA) install fails
Requirement
I wish to install SSMS 18.0 GA (https://docs.microsoft.com/en-us/sql/ssms/download-sql-server-management-studio-ssms?view=sql-server-2017), on Windows 10 but get error:
enter image description here Uninstall Preview Attempt to uninstall 18.0 preview via Add/Remove programs: enter image description here Uninstall fails with:"The feature you are trying to use is on a network resource that is unavailable" "Click OK to try again, or enter an alternate path to a folder containing the installation package 'vs2017_isoshell_for_ssms.msi' in the box below"
Use source C:ProgramDataPackage Cache{D620DE9C-8A83-4BA5-83A8-E709A4150A47}v15.0.27248.2015redist vs2017_isoshell_for_ssms.msi does not exist on my machine. enter image description here Other fixes attempted
I attempted to remove via other means:
I have run MicrosoftProgram_Install_and_Uninstall.meta.diagcab from https://support.microsoft.com/en-us/help/17588/windows-fix-problems-that-block-programs-being-installed-or-removed And removed everything with SSMS or management studio in the name. After that, SSMS 18.0 preview still appears in add/remove programs and an uninstall gives the same error as above.
msiexec /x “{D620DE9C-8A83-4BA5-83A8-E709A4150A47}” brings up the same dialog so I cannot progress:
enter image description here
Reinstall SSMS 18.0 Public Preview 6 works fine from https://go.microsoft.com/fwlink/?linkid=2052501 Try and install SSMS 18 GA again and get a different error of: enter image description here
Remove SSMS 18 preview 6 via Add/Remove programs, and get the same error: enter image description here
Question How can I remove SSMS 18 preview? I don’t have vs2017_isoshell_for_ssms.msi, a web search for this file gives nothing and a re-install of the preview version does not provide it. How to uninstall SQL Server Management Studio?
It depends on how recent your install is, it may just be quicker to revert to a prior system restore point, so long as you have the feature enabled. They're pretty fast and pretty failsafe from my experience.
From the Recovery options in Windows 10 support article:
This option takes your PC back to an earlier point in time, called a system restore point. Restore points are generated when you install a new app or driver, and when you create a restore point manually. Restoring won’t affect your personal files, but it will remove apps, drivers, and updates installed after the restore point was made. In the search box on the taskbar, type control panel, and then choose it from the list of results In the Control Panel search box, type recovery.
Select Recovery > Open System Restore. In the Restore system files and setting box, select Next. Select the restore point that you want to use in the list of results, and then select Scan for affected programs. You'll see a list of items that will be deleted if you remove this restore point. If you're OK with the deletions, select Close > Next > Finish.
Notes If you don’t see the restore point that you want to use, select the Show more restore points check box to see more restore points. If you’re not seeing any restore points, it might be because system protection isn’t turned on. Here’s how to check: In the search box on the taskbar, type control panel, and then choose it from the list of results.In the Control Panel search box, type recovery. Select Recovery > Configure System Restore > Configure and see if the Turn on system protection option is selected. If the Turn on system protection option is not selected, system protection isn’t turned on and there aren't any restore points. In this scenario, you won't be able to recovery your PC using a system restore point and will need to use one of the other recovery options listed on this page. Here are the steps to uninstall SQL Server Management Studio: Windows 10 / 2016 +
- To begin the removal process, navigate to Settings from the Start menu and then choose Apps.
- Search for sql in the search box.
- SQL Server (Version) (Bit). ...
- Select Uninstall/Change.
- Select Remove on the SQL Server dialog pop-up to launch the SQL Server installation wizard.