Notes on SQL

Random articles from a puzzled DBA

Background

SQL Server Management Studio (SSMS) is now a separate installation, so it can be updated without any impact on the SQL Server engine. Updating the newer versions is as easy as you would expect but removing an older SSMS that was included as part of SQL Server requires a little bit of concentration.

Method

It isn’t difficult to remove SSMS 2012 but it is slightly unnerving, because you have to navigate through the uninstall/change wizard. I find it difficult to shake the feeling that I may have made the wrong selection, whereupon a critical part of SQL Server will be removed and I will have to prepare three envelopes.

Watch Out

If you’re using PowerShell within SQL Agent jobs, then you should check for this registry key:

HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\PowerShell\1\ShellIds\Microsoft.SqlServer.Management.PowerShell.sqlps110\ExecutionPolicy

The uninstallation process also appears to remove that and you may well see error messages from those jobs, along the lines of:

Cannot process command because of one or more missing mandatory parameters. ExecutionPolicy

After you have removed SSMS you can re-insert the key and the jobs should then behave as normal.

Launch the Uninstall/Change Wizard

Locate SQL Server, within the Control Panel ‘Uninstall or Change a program’

Uninstall/Change starting point
Starting the Uninstall/Change wizard

When the Add/Repair/Remove option appears, select ‘Remove’. Don’t forget that the Wizard will provide a summary of the actions it will take, before it actually executes. So you will have the chance to abandon this, without any impact upon the system.

Select the ‘Remove’ option

The Wizard will then take a few seconds to proceed to the next step, display the following message while it does.

After a short while it will execute the support rules check, that you normally see when installing SQL Server.

You usually see this when installing

Once completed, the wizard then wants to know which instance you want to process.

When I executed this, I selected an instance. However, there is a ‘Shared Component’ option too, which would have been more suitable. SSMS is a shared component, so the instance that you select is irrelevant – it will be removed from all instances that are listed on this screen.

Choose an instance or the shared components

Having made the selection, the Wizard then shows the components currently installed. We want to remove SSMS, so the option is ‘Management Tools – Basic’. The sub-selection of ‘Management Tools – Complete’ will be selected automatically.

Management Tools only!

Clicking ‘Next’ will take this Wizard to the summary screen. This is where you have the chance to check what you have requested. Up until this point no action has been taken by the Wizard – it was just requesting information, ready for the removal.

Although the dialog box is entitled ‘Ready to remove SQL Server 2012’, the summary shows that it is really just removing the Management Tools.

Check the actions are correct

Having checked that the options are correct, click ‘Remove’ to proceed with the removal.

The Wizard then shows the expected removal progress.

Removing selected components

Once completed, a summary of the actions completed are shown and a log file has been saved for further details.

All done

Confirming the Removal

On my systems I had a shortcut for running SSMS 2012. Clicking on this shortcut produces an error message, as that software is no longer available.

This version of SSMS is no longer available

And loading the only available SSMS (on my system) shows that it is version 18.4.

The newer version is the only version installed

Summary

Removing SSMS 2012 isn’t difficult, although slightly unnerving. We removed it because the newer versions of SSMS have more features and additional, Redgate’s SQL Prompt was warning that future versionjs would not support SSMS 2012.

Apart from the issue with the registry key, there appears to have been no problems from this action.

References

Uninstalling SSMS breaks PowerShell

Redgate SQL Prompt

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.

%d bloggers like this: