While writing an article for MSSQLTips.com, i installed SQL Server 2005 Dev Edition and SQL Server 2005 Express Edition on Windows 7. Dev Edition was with default instance name while Express Edition was named as SQLExpress on machine. After completion of article as a clean up process, it was required to uninstall the express edition.
During this process i noticed that for new DBAs uninstalling an instance out of multiple instances may be confusing if not aware of process. In add/remove programs utility, SQL Server instances are embedded in their versions rather than separate entry for each instance. SQL Server 2005 instances are included under Microsoft SQL Server 2005 entry while SQL Server 2008 instances are included under Microsoft SQL Server 2008 entry.
So here is how i uninstalled express edition and leaving the Dev edition only in SQL Server 2005 family.
- Click on Microsoft SQL Server 2005 entry
- On generated frame select SQL Server 2005 express instance to uninstall
- Make sure to leave the common components unchecked
Now click the Next button to continue with uninstall of selected instance of SQL Server 2005.