SSMS 18 Installation Error 0x80070654

Question

Hey everyone,

so, I tried installing both SQL Server 2019 and SSMS 18, and I got some error during installation. SQL Server 2019 setup went static for about an hour while stopping almost every process and I had to restart (It seems it installed correctly tho, but I only have 1 service related to SQL, SQL Server VSS Writer).
The problem is, when I tried installing SSMS 18, it completely crashed my PC (BSOD something about the kernel), and now I cant even uninstall / repair the program because I get an "Installation error. Can't open installation package, get it touch with the app developer to check if it's a windows installer valid package. ERROR 0x80070654 "

Here's the log and the error:

121972-ssms-setup-esn-20210810093414.log

Answer 1

App installers won't BSOD your machine as only kernel level software can do that. The BSOD tells you what driver/module failed and what happened. Generally it is indicative of a bad driver or HW failure.

As for the installer do you have a firewall enabled like Windows Defender? It appears that it is unable to download components from the Internet in order to install the app. While I don't generally have issues with Windows Defender some other firewall apps may be more aggressive.

Answer 2

I had windows defender enabled at that time, but I hadn't even thought about it, because, as you said, windows defender don't usually give any kind of problem

Answer 3

I reinstalled SQL with windows defender off and now it's been correctly installed. Now I have to find a way to completely uninstall SSMS manually

Answer 4

Hi @Sebastián Re ,

From your screenshot, your installation failed. You can try to turn firewall off and run as administrator when installing SSMS. Make sure that the language of the installation package is consistent with the OS. Of course, you can discard the old installation package and try downloading and installing again in any case.

https://learn.microsoft.com/en-us/sql/ssms/download-sql-server-management-studio-ssms?view=sql-server-ver15#ssms-system-requirements

Answer 5

Already tried that, with no luck. The installer detects that the program has already been installed on the pc, so it shows the "uninstall" and "repair" options. Both options give the same error as shown above. I need to find a way to FIRST uninstall completely ssms manually, and then try to reinstall it.