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

Last Modified 3/29/2011.
https://support.trustwave.com/kb/KnowledgebaseArticle14064.aspx