I have a distinct feeling of déjà vu. However, I know I’m not dreaming because I’ve written about installing SQL Server Management Studio before, but last time it was for SQL Server 2005. Why oh why is it so complicated to install this piece of software!?
This time I installed Visual Studio 2010 first, which in turn installed SQL Server 2008 Express. Of course I needed SQL Server Management Studio though, so I downloaded it from Microsoft and tried to install it. And of course, when I went through the installation wizard, the option to install Management Studio didn’t seem to be there. That’s when I start bashing my head against the keyboard and asking ‘why does this have to be so hard!’...
Anyway, after a little investigation and persistence, I figured it all out. I even managed to grab some screenshots so that I would NEVER forget how to do this ever again… and hopefully it will once again help others who may be having the same problems.
- Install Service Pack 1 for Microsoft SQL Server 2008 – you need Service Pack 1 or else you won’t even be shown the option to install Management Studio.
- Run the SQL Server Management Studio installer.
- Click on ‘Installation’ in the left menu.
- Click on ‘New SQL Server stand-alone installation or add features to an existing installation’.
- It will ask you to install ‘Setup Support files’ -yup, you have to install this in order to install other features, so go ahead and install it.
- Once it has finished installing the ‘Setup Support files’, the wizard should move you onto ‘Installation Type’. As counter-intuitive as it seems, choose the ‘Perform a new installation of SQL Server 2008’ option and click next.
- Now the wizard asks you to specify the edition of SQL Server 2008 to install. You’ll notice that both options given are greyed out – that’s what you want to see. Click next…
- ‘Feature Selection’ – brilliant. This is what you were aiming for. Here you should see a couple of different features that you can install, namely, ‘Management Tools – Basic’. Make sure it is checked then click next.
- Proceed through the next few dialogs, each of which ask you the standard installation questions like installation location, and sooner or later, you should see a nice screen telling you that it has successfully installed ‘Management Tools – Basic’. Success!!