This morning I found myself in need of the SQL Server management studio on a new box I built a few months ago. So far, I’ve only installed Visual Studio 2010 RC and the SQL Server 2008 Express that came with it.  I was first directed to use the Web Platform Installer which, while it is a great tool, didn’t provide any details with the installation ultimately failed.  After trying to run the installer as an administrator directly (outside the Web PI) I was warned that I needed to re-apply SQL Server 2008 Service Pack 1. No biggie, I hit run anyway.  Then the real problem.  The installer kept failing saying that it required .NET 3.5 with Service Pack 1.  Windows 7, as you may know, comes with .NET 3.5 SP 1 installed by default. Well, sort of. 

While Windows 7 basically has 3.5 SP 1 on it, it really has a comparable version of the .NET framework installed.  Most machines (pre-win7) with 3.5 SP 1 have a framework version of something like 3.5.30729.1 .  On Windows 7, the framework version is: 3.5.30729.4926.  If you look in the registry, under HKLM\Software\Microsoft\NET Framework Setup\NDP\v3.5\   you will find this version number, but also a key named SP.  On Windows 7 that value is zero (0). 

Solution, change the registry entry for the SP key from 0 to 1 (one) and then run the installer. Voila, installs with no problem.  Now I just need to reapply SP1 (well, after actually walking through the less-than-intuitive installer to apply the management studio) and I’m good to go. 

Hope this saves someone else some time. 

[Update 3/3/10: fixed registry key path]

Posted Mar 01 2010, 12:19 PM by matt-milner


René wrote re: Getting SQL Server 2008 Management Studio Express installed on Windows 7
on 03-03-2010 5:00 PM

Thank yiou very much, this helpt a lot. But you made a little typo which made me didn’t find this registry setting at first.

You typed : .NET Framework Setup

It should be : NET Framework Setup

Without the dot for NET!

matt-milner wrote re: Getting SQL Server 2008 Management Studio Express installed on Windows 7
on 03-03-2010 9:37 PM

Thanks Rene – I fixed the path in the post. Just used to typing that period when typing .NET.  🙂

This is seriously one thing that caused me massive heartburn. I mean seriously, me getting pissed off for two days for this thanks to a darn registry key :s