How to uninstall an SQL Server Instance from a mulit-instance Database Server.
From the Database Server go to StartàRun, and type in appwiz.cpl.
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’.
Be patient while the uninstall process begins…
Select the Instance you wish to remove. In this case we are removing the SQL instance SQLSHARE09.
Select the Instance SQLSHARE09, and it’s services:
Database Engine Services
Reporting Services – Native
DO NOT select Shared Features.
You are done.
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.
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.
Categories: SQL Stuff