SSMS While installing Microsoft SQL Server Management Studio with Azure Data Studio setup failed error code(0x800B0111)

Question

While installing the Microsoft SQL Server Management Studio with Azure Data Studio Getting failed as per below error.

Error:-
Setup Failed

Version 18.12.1

The certificate was explicitly marked as untrusted by the user by the user (0x800B0111). Also attached the screenshot for reference.

Installing on Server 2019 (64-bit) with admin privilege.

Answer 1

Try to repair corrupted Windows files using SFC tool.

Answer 2

Hi @Mohammad Amir
I found a similar problem you can check this link : https://social.msdn.microsoft.com/Forums/security/en-US/9fad8d58-09fc-4143-95ee-0538a9373818/ssms-install-error-code-a-certificate-was-explicitly-revoked-by-its-issuer-0x800b010c?forum=sqltools&prof=required
I hope this can solve your problem.

Answer 3

Thanks @Alberto Morillo @PandaPan-MSFT for helping for fixed the issue, after using SFC tools URL then run the below 3 command for fixed the windows corrupted file then able to installed the SSMS SQL application successfully.

Command:=

1) sfc /scannow
2) Dism /online /Cleanup-Image /Checkhealth
3) Dism /online /Cleanup-Image /ScanHealth

Thanks

Answer 4