SQL Stuff

How To Uninstall an SQL Server Instance

How to uninstall an SQL Server Instance from a mulit-instance Database Server.

Step 1:
From the Database Server go to StartàRun, and type in appwiz.cpl.

Step 2:
Locate the Database Server product you would like to uninstall. In this case we are selecting ‘Microsoft SQL Server 2014 (64-bit)’, and click ‘Uninstall/Change’.

Step 3:
Click ‘Remove’.

Be patient while the uninstall process begins…

Step 4:
Select the Instance you wish to remove. In this case we are removing the SQL instance SQLSHARE09.
Click ‘Next’.

Step 5:
Select the Instance SQLSHARE09, and it’s services:

Database Engine Services
Reporting Services – Native

DO NOT select Shared Features.

Click ‘Next’.

Step 6:
Click ‘Remove’.

Step 7:
Click ‘Close’.

You are done.

To confirm…

Check the Configuration Manager, or check under Services.

SQL Server Configuration Manager:
Simply open up the ‘SQL Server Configuration Manager’, and ensure the SQL Server Instance SQLSHARE09 is nolonger listed.

The service name should not appear in the list. Here we see the service is missing therefore it has been successfully removed.

Services:
StartàRun: Services.msc

Look to see if the SQL Server (SQLSHARE09) Services is listed at all. All Database Services for SQLSHARE09 will not be present in the services list.

Advertisements

Categories: SQL Stuff

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 )

Twitter picture

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

Facebook photo

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

Google+ photo

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

Connecting to %s