THE SQL Server Blog Spot on the Web

Welcome to SQLblog.com - The SQL Server blog spot on the web Sign in | |
in Search

Davide Mauri

A place for my thoughts and experiences on SQL Server, Business Intelligence and .NET

SQL Server 2008 R2 Installation and the Phantom of SQL Server 2005 Express

Today I’ve happy started to install SQL Server 2008R2 on my development machine, which has this software installed

  • Windows Server 2008 R2 Standard
  • SQL Server 2008 SP1 CU5
  • Visual Studio 2008 SP1
  • BOL October 2009
  • AdventuresWorks2008 Databases SR4
  • Visual Studio 2010 RTM

So, all the basic standard stuff.

SQL Server 2008 R2 installation went smooth ‘till somewhere in the middle, where the rule engine checks that software pre-requisite are satisfied before starting to copy files.

Here I had this @][@@[?!?! error:

“The SQL Server 2005 Express Tools are installed. To continue, remove the SQL Server 2005 Express Tools.”

Fun enough, I don’t have and I’ve never had SQL Server 2005 Express on my machine.

Armed with patience I analyzed the install log here

C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\yyyymmdd_hhmmss\Detail.txt

and I’ve found that the rule “Sql2005SsmsExpressFacet” is the one in charge of this check and it look for existance of the registry key

HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\90\Tools\ShellSEM (on x86)

HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\Microsoft\Microsoft SQL Server\90\Tools\ShellSEM (on x64)

In my registry I’ve found that key existsing, due to the installation of the uber-cool Red-Gate SQL Search.

I removed the registry key and here it is! SQL Server 2008 R2 is installing while I’m writing this post.

A note to Microsoft: can you please add more detailed information on the setup while such error happens. Just saying “you have SQL Server 2005 Express installed” is not enough. Please show us what the rule look for and why it has failed directly in the Detailed Report, so that we don’t have to spend time to look for the needle in the logs. Thanks! :)

PS

I did a side-by-side installation with the existing SQL Server 2008 instance.

Published Tuesday, May 04, 2010 10:44 AM by Davide Mauri
Filed under: , ,

Comment Notification

If you would like to receive an email when updates are made to this post, please register here

Subscribe to this post's comments using RSS

Comments

 

Charles Proctor said:

Had the same problem. Ditto on the MS "more detailed information".

Thanks for the fix!

May 4, 2010 8:48 AM
 

daveballantyne said:

May 5, 2010 2:06 AM
 

merrillaldrich said:

Same issue on my machine. Thanks for this tip!

May 26, 2010 2:08 PM
 

amemon said:

Thank you for sharing. It worked for me

September 29, 2010 9:21 AM
 

finally an answer said:

thanks, pulling my hair out - if i had hair

December 8, 2010 3:03 PM
 

Jay said:

Yes, it worked. Thanks for saving hours my time to figure it out.

March 24, 2011 10:13 AM
 

Simon said:

Thank you sir, #1 Google search result for good reason, fixed it for me too

April 20, 2011 2:21 PM
 

Andrew said:

Thx bro. I found this info on many other sites, but no one mention the x64 system option.

July 10, 2011 8:06 AM
 

Andy McMullan said:

Thanks for this - saved me a lot of hassle.  (In my case it was a SQL intellisense plugin, but just uninstalling it wasn't enough - I had to remove the ShellSEM registry key)

May 9, 2012 9:17 AM

Leave a Comment

(required) 
(required) 
Submit

About Davide Mauri

Davide Mauri - MCP, MCAD, MCDBA, MCT, MVP on SQL Server - has worked with SQL Server since version 6.5, and his interests cover the whole platform, from the Relational Engine to Analysis Services, from architecture definition to performance tuning. He also has a strong knowledge of XML, .NET and the Object Oriented Design principles, which allows him to have the correct vision and experience to handle development of complex business intelligence solutions. Having worked as a Microsoft Certified Teacher for many years, Davide is able to pass all his knowledge to his co-workers, allowing his team to deliver high-quality solutions. He currently works as a Mentor for SolidQ and can be found speaking in many Italian and internationals events.

This Blog

Syndication

Powered by Community Server (Commercial Edition), by Telligent Systems
  Privacy Statement