I did a SQL 2008 install today which reminded me I had written this a few months ago. My original intent was to write a series on SSMS 2008 but I got sidetracked by work, life, etc. and filed this away. There’s no sense in having put the effort into it and then let it go to waste, so for your reading pleasure…
When you're ready to install SSMS 2008 be prepared to set aside at least an hour and as many as three depending on the speed of your machine and how current you are on patches and updates. There is are also 1-2 reboots required to complete the install. This walkthrough covers a Developer edition install on a clean Windows XP SP3 configuration that's been patched with all critical updates available at the time on an HP nc8000 laptop.
Note: Click on each thumbnail to view a full size image.
The first thing you'll get when you run the installer is a warning that the .NET framework needs to be installed along with some other updates.
The setup needs to install .NET Framework 3.5 SP1 and wants to download 52 MB of files to do it. The files are actually on the DVD though, so setup moves right along to the installation. Install time: ~15 minutes, no reboot required.
After the .NET Framework I need to install a Hotfix for KB942288 which is really Windows Installer 4.5. No download required. Install time: ~2 minutes, plus a reboot.
If you've got Visual Studio 2008 installed you'll also be required to apply VS 2008 SP1....yet another download, install, and reboot. This download is not on the DVD so be prepared to take a coffee break while the download completes. Total install time for VS 2008 SP1 was about an hour on my laptop.
Finally after all the prerequisites are taken care of I can get to work on installing Management Studio. SQL 2008 uses an Installation Center with high level tasks on the left and subtasks on the right.
Choose Installation on the left, followed by "New SQL Server stand-alone installation or add features to an existing installation" on the right.
This launches another setup window which checks some more prerequisites (called Setup Support Rules)
Enter the product key. The MSDN version I used was pre-populated.
Accept that Microsoft will one day rule the world (aka License Terms)
Now watch the “Setup Support Files” progress. Install Time: ~5 minutes
Another setup support rules screen which checks more prerequisites.
Finally we’re at feature selection. There's now two kinds of installs for Management Tools: Basic, which installs only Management Studio, SQLCMD, and Powershell...and Complete, which adds support for Reporting Services, Analysis Services, and Integration Services plus Profiler and the Database Tuning Advisor. For this post I did a Complete install and Books Online.
Review the disk space requirements.
Decide whether or not you want to send Microsoft data about how your installation went.
Setup then checks to make sure the installation won’t be blocked by anything. I’m thinking this should have been checked earlier; I’d hate to have gotten this far only to be blocked by something else not already accounted for.
Finally an "Install" Button!
Now watch the installation progress. Take another coffee break, read your daily blogs, go to lunch...or be prepared to watch this one for a while.
Install Summary. Install Time: ~45 minutes
Installation wasn’t particularly painful or difficult, just time consuming. Set aside at least an hour or more to do this, and it’s probably best to do it at as an end of day or evening task when you don’t need to use your computer to do anything particularly important or otherwise work-related.