Friday, May 07, 2010

SQL Server 2008 R2 Install

Now that it’s gone to RTM I’ve just updated my development server to SQL Server 2008 R2 and hit an error that is a little weird.

The install was blocked because it thought I had the SQL Server 2005 Express Tools installed.  However this is a machine that has never had anything other that SQL Server 2008 on it.

Searching around on the internet I found a post on the sqldabtips.com blog that covered why this is the case. 

Basically the problem is that SQL Prompt and SQL Search from RedGate add a registry key (at least the version of SQL Search that I had installed did) that fools the installer.  Simply uninstalling SQL Search and hitting “re-run” in the SQL Server 2008 R2 installer solved the problem and allowed the upgrade to be applied.

No comments: