Can't install SQL 2008 R2 Express when SQL 2005 Tools are installed

This article applies to:

• Marshal Reporting Console 2.5 installation
• SQL 2008 R2 Express installer

Symptoms:

• SQL Server installation could not complete
• SQL System Configuration check reports: Sql2005SsmsExpressFacet (The SQL Server 2005 Express Tools are installed. To continue, remove the SQL Server 2005 Express Tools.)

Causes:

• SQL Server Management Studio 2005 (SSMS) or other SQL 2005 tools are installed
• Red Gate SQL Prompt is or was installed

Resolution:

• To resolve the issue, uninstall SSMS 2005 and then re-run the MRC or standalone SQL 2008 installer.
• If the Red Gate product was installed, you may also need to manually delete one of the following Registry keys (depending on operating system):
  • HKey_Local_Machine\Software\Microsoft\Microsoft SQL Server\90\Tools\ShellSEM
  • HKey_Local_Machine\Software\Wow6432Node\Microsoft\Microsoft SQL Server\90\Tools\ShellSEM