I tried to download and install the standalone version of SQL Server 2008 R2 Management Studio Express on my Windows 7 64bit development box that I use for SharePoint development, but no matter what I tried I couldn’t get it installed.
Then I vaguely remembered reading a blog article, a while back on the Microsoft Web Platform Installer 2.0, and wondered if this would help me. I [ googled |binged] and found Scott Hanselman’s blog article, WebPI20 and VSWebDeveloper2010Express. Well, and look at that – Scott had almost the same problem.
To reiterate:
- Download the Microsoft Web Platform Installer 2.0
- Select the Web Platform tab, the Customize link under the Database heading.
- Click the “SQL Server R2 Management Studio Express ” Option and click Install.
It took the installer about 20 minutes, and a reboot was necessary, but it works like a champ.
One thing I did notice is that the web installer was smart enough to figure out that I had SQL Server Express R2 and it should SQL Server 2008 R2 Management Studio Express, whereas Scott’s had SQL Server Express 2008 w/ SP1 installed, thus the web installer install the SQL Server 2008 Management Studio Express version.
Thanks, Scott – your blog is a great!
Tom
