Fail to install and unintall "Microsoft SQL Server Management Studio with Azure Data Studio"

Question

Fail to install and unintall "Microsoft SQL Server Management Studio with Azure Data Studio"

Li Ji 1

I tried to install SQL Server but failed many times, then checked online and tried some solutions, like uninstall it and then re-install again, however, I found that I can't even uninstall the "Microsoft SQL Server Management Studio with Azure Data Studio" for re-installing with screenshot for your reference. I tried the methods of changing the permissions in the registry, but I got the same error message when I tried to change them as shown below: " could not open key....."

Is there any other way that I can use SQL or any more suggestions?
(the Chinese in the screenshot just says there is a big error when install this and log file as attached for your reference too.)189223-ssms-setup-enu-20220401104730.log

3 answers

Your answer

Answer 1

Bjoern Peters 8,921

Make sure you'd downloaded the right package... there are two ... one for a fresh installation of SSMS and one for Upgrading
and make sure you execute the setup with administrative privileges. (execute as admin)

Li Ji 1 Reputation point

2022-04-01T15:49:07.76+00:00

Yeah, I did upgrade it and execute as admin....Is this the problem of SSMS or the SQL server?

Answer 2

Bjoern Peters 8,921

As your log file states that it can't install a package (due to deleting/updating reg-keys) due to missing privileges, this was the first suggestion that could be made, and depending on your environment, UAC can be a mess with installing SQL Server.

So everything worked and you are happy, or still having problems?

If everything is fine now, please mark my answer as helpful, to support others within the community.

Answer 3

YufeiShao-msft 7,146

Hi @Li Ji ,

SSMS can be installed standalone, it is the problem of your SSMS, although it looks like your SQL Server is also having problems

SQL Server Management Studio (SSMS) setup failed or requires restart
Try to uninstall the "Microsoft ODBC Driver 17 for SQL Server" before beginning the SSMS installation :
Close any related applications, including SSMS, Visual Studio, or SQL Profiler.
Go to Control Panel > Add/Remove Programs.
Locate the entry for "Microsoft ODBC Driver 17 for SQL Server" and uninstall. This step may require a reboot.
Begin the SSMS installation. The latest version is available here.

About 'Could not Open Key: UNKNOWN\Components……‘, you can refer to this artical: https://blog.sqlauthority.com/2018/04/21/sql-server-fix-error-1402-could-not-open-key-unknowncomponents-system-error-5-another-solution/

-------------

If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

YufeiShao-msft 7,146 Reputation points

2022-04-06T08:03:05.813+00:00

Could you please validate all the answers so far and provide any update?

If the reply above was helpful please mark as accepted answer so it can be helpful for other community members with same questions.

Regards
Li Ji 1 Reputation point

2022-04-06T13:50:28.317+00:00

Hi Yufeishao,

Thanks for the detailed information. I will check them probably later this week and will get back to you asap (I'm having a crazy week for my study these days).

Thanks for understanding:)

All the best
Li Ji 1 Reputation point

2022-04-08T22:01:17.3+00:00

Hi Yufeishao,

I just tried about the re-install method you mentioned, still doesn't work.

Also, I tried again to change the permission in my registry as mentioned on the link you shared about "Could not Open Key" (I tried before), but still cannot get the permission, which always told me "Access Denied". This is pretty werid....
Li Ji 1 Reputation point

2022-04-12T01:54:13.13+00:00

Hi Yufeishao,

I just got the problem of my SSMS solved by finding a way to change the registry and finally install it successfully.

However, as you mentioned above, I also have some problem with my SQL server. I got the error as shown below, but I have no idea about which key it refers to. May u please advice how I could deal with it?

TITLE: SQL Server Setup failure.

------------------------------

SQL Server Setup has encountered the following error:

An item with the same key has already been added..
YufeiShao-msft 7,146 Reputation points

2022-04-12T02:28:59.587+00:00

please share your errorlog for more information, usually in the Program Files\Microsoft SQL Server\MSSQL.n\MSSQL\LOG\ERRORLOG

Please cheak if the SQL Server exists, if yes, you may need to uninstall it first and then reinstall it
Li Ji 1 Reputation point

2022-04-12T14:39:21.403+00:00

I cannot find the errorlog that you mentioned. Just find some log files that might be helpful as attached.192288-summary-desktop-7e1im3g-20220412-101245.txt

With the error, I can not even find SQL server existing in my computer. I did delete all the relevant files and registry keys for reinstall, but still showed the same error. Thanks

192344-sqlsupport-cpu64-1.log 192359-detail.txt
YufeiShao-msft 7,146 Reputation points

2022-04-15T02:20:10.61+00:00
1.Anyway, if you need both SQL Server and SSMS, I would recommend you to download SQL Server first, here is a similar thread:https://stackoverflow.com/questions/52229292/any-solution-for-error-code-1603-in-sql-server-2017-installation, althougt SSMS is a seperate installation now, occasionally errors occur due to the order of installation

MSI Error: 1402 Could not open key: UNKNOWN\Components\9B5C016626D379147BA349922F64AEF2\E0DECD7172B5A3542B4B4E788B962BA8. Verify that you have sufficient access to that key, or contact your support personnel.

About this error, you can refer to this:https://blog.sqlauthority.com/2017/02/14/sql-server-fix-error-1402-not-open-key-unknowncomponents-system-error-5/

These are the bug reports I found, you can try to fix 1402 first, then try to fix 1603

Share via

Fail to install and unintall "Microsoft SQL Server Management Studio with Azure Data Studio"

3 answers

Your answer