The repair option actually brings up the window or UI prompt where you get options to repair and uninstall SSMS. Run the command SSMS-Setup-ENU.exe /repair Launch the command prompt as administrator.

Use the following steps to repair SSMS using command line. Repair SSMS using Command Line Repair SSMS using Command Line

/SSMSInstallRoot – specify the path to SSMS location.

/passive – displays minimal UI with no prompts.

You can find the SSMS setup help options by running the SSMS-Setup-ENU.exe /?. The SSMS-Setup executable actually provides additional switches. You can also repair SSMS using command line. Restart Computer to complete SSMS Repair SSMS Setup Help Switches Your computer must restart after you repair SSMS. Repair SQL Server Management StudioĪfter few minutes, the SSMS repair completes.

Close – Cancels the Repair SSMS or Uninstall process.Ĭlick Repair.

Uninstall – Select this option to uninstall SQL Server Management Studio.

Repair – Select this option to repair SQL Server Management Studio install.

You get three options when you uninstall SQL Server Management Studio.

Click Repair to begin the SSMS install repair.

From the list of programs, right click SQL Server Management Studio and click Uninstall.

On the computer, go to Control Panel > All Control Panel Items > Programs and Features.

Close the SSMS application(if it is running).

To repair SQL Server Management Studio (SSMS) How to Repair SQL Server Management Studio When you install SQL Server 2019 for ConfigMgr, you have to manually download and install SQL Server Management Studio. SCCM admins typically use SQL Server Management Studio to connect to SQL Server and access ConfigMgr database. SSMS provides tools to configure, monitor, and administer instances of SQL Server and databases.īeginning with SQL Server Management Studio (SSMS) 18.7, Azure Data Studio is automatically installed alongside SSMS. You can manage your SQL Server and even Azure SQL Database. SQL Server Management Studio (SSMS) is an integrated environment for managing SQL infrastructure. Microsoft has published a nice article on how to get diagnostic data after a SQL Server Management Studio (SSMS) crash. I have experienced the SSMS crash only once and that did not appear again when I restarted my machine. It’s very rare that you see SSMS crashing while you are using it. You repair SSMS when you notice that SQL Server Management Studio (SSMS) has stopped working or is crashing. In this post I will show you 2 ways to repair SQL Server Management Studio (SSMS).

Sql management studio