Cannot Install SQL Server Management Studio on Windows 10: Setup Failed Error

Question

I have been trying to install ssms for hours now. when i run the installer, i get a set up failed error. Through my own research I believe the issue lies within my Windows Installer. I am not able to start the service. I also had a separate issue with removing items through the control panel, which i believe is also caused by the Windows Installer not being able to be started. When I try manually start the service, I get Error:1053, which i believe is a timeout error. I have seen many people suggest opening the command prompt and running the command sfc /scannow. WhenI run this command it either gets stuck at 31% or nothing happens. Same thing when I run DISM /Online /Cleanup-Image /RestoreHealth. Any and all assistance is appreciated.

Answer 1

Hello Ethan lewis,

Thank you for posting in Q&A forum.

There could be several reasons why you are encountering this error while trying to install SQL Server Management Studio on Windows 10. Here are some troubleshooting steps you can try.

1.Check if your Windows 10 system meets the minimum system requirements for SQL Server Management Studio. You can find the system requirements on the Microsoft website.

2.Make sure that you have administrative privileges on your Windows 10 system.

3.Disable any antivirus or firewall software temporarily and try to install SQL Server Management Studio again.

4.Download the installation files again from the Microsoft website and try to install it again.

5.Try installing SQL Server Management Studio using the command line with administrative privileges. Open the command prompt as an administrator and navigate to the folder where the installation files are located. Then, run the command "setup.exe /q /ACTION=Install /FEATURES=SSMS /INSTANCENAME=MSSQLSERVER /IACCEPTSQLSERVERLICENSETERMS".

6.Check if you downloaded the correct SQL Server Management Studio (SSMS).

https://learn.microsoft.com/en-us/sql/ssms/download-sql-server-management-studio-ssms?view=sql-server-ver16

Other references you can troubleshoot the problem.

https://learn.microsoft.com/en-us/sql/ssms/troubleshoot/install-failed-requires-restart?view=sql-server-ver16

https://learn.microsoft.com/en-us/sql/database-engine/install-windows/repair-a-failed-sql-server-installation?view=sql-server-ver16

I hope the information above is helpful.

If you have any question or concern, please feel free to let us know.

Best Regards,
Daisy Zhou

============================================

If the Answer is helpful, please click "Accept Answer" and upvote it.