question

SebastinRe-7732 avatar image
0 Votes"
SebastinRe-7732 asked SebastinRe-7732 commented

SSMS 18 Installation Error 0x80070654

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:

122002-imagen-2021-08-10-094534.png


121972-ssms-setup-esn-20210810093414.log


sql-server-general
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

SebastinRe-7732 avatar image
0 Votes"
SebastinRe-7732 answered SebastinRe-7732 commented

I tried matching languages (despite thinking it's kinda weird), running as admin, turning off firewall and redownloading the installer but, as I said, I have to first find a way to completely uninstall SSMS manually

· 5
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

I would first start by running the remove for SQL Server 2019 and then looking at the shared features to see if it shows up as installed there. If it does then remove from that setup program if possible.

If that doesn't work/isn't an option then refer to this post on how to manually remove SSMS so that the installer can run again.

0 Votes 0 ·

Starting with SQL Server 2016, SQL Server management studio is offered as a separate download and hence can be installed as a standalone application

This only applies if you have SQL server 2014 and below, wherein SSMS may have been installed as a shared feature during setup.

Sadly, I already checked that post before posting myself, and I didn't get any luck with that, as the last instruction is "uninstall SSMS", which I can not do properly with the uninstaller.

I even deleted all the keys related to SSMS in HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion\Uninstall\ and restarted afterwards, because last time I tried installing right after deleting the entries on regedit, but it always detects as if it's already installed.

What is even weirder is the fact that the program installs partially when I run the installer ( the folder weights about 630MB)

When I run the "repair" option twice, the installer stops inmediately and shows "a restart has been required". I tried restarting and selecting the repair option again, but it's a never-ending loop of "installation error 0x80070654" and then "a restart has been required"

0 Votes 0 ·

The installer doesn't really rely on the Uninstall key for determining what is installed. Installed packages and components are stored in a massive key under HKLM\Classes\Installer. Within here is the machine-level products, components, etc that are installed. In my experience when I had to manually clean something up was to search the registry for the product (e.g. SQL Server Management Studio). However some folks have had luck with the Cleanup tool from MS.

1 Vote 1 ·
Show more comments
SebastinRe-7732 avatar image
0 Votes"
SebastinRe-7732 answered SebastinRe-7732 commented

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.

· 2
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hey there,

I've already tried the answer of the second link you sent, with no luck.
And for the first one, I followed the steps and I get the exact same error as always, I'm not joking.

This is the screenshot of the message I got when I tried the command:

![![122624-image.png][1]][1]


0 Votes 0 ·
image.png (53.8 KiB)
Yufeishao-0810 avatar image
0 Votes"
Yufeishao-0810 answered Yufeishao-0810 edited

Hi @SebastinRe-7732,

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://docs.microsoft.com/en-us/sql/ssms/download-sql-server-management-studio-ssms?view=sql-server-ver15#ssms-system-requirements

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

SebastinRe-7732 avatar image
0 Votes"
SebastinRe-7732 answered

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

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

SebastinRe-7732 avatar image
0 Votes"
SebastinRe-7732 answered

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

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

cooldadtx avatar image
0 Votes"
cooldadtx answered

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.

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.