«
»

Installing SQL Server 2008 Management Studio Express

I used to use SQL Server 2005 Express and recently upgraded to 2008.  SQL Management Studio 2005 won’t connect to 2008 – it gives an error, so I went looking for management studio express 2008, which I couldn’t find anywhere.  I then tried downloading SQL Server 2008 Express to dig it out from there, which does work, but requires several pre-requisites.  You might want to bear this in mind (and I might have missed something – let me know if I have)…

  1. Make sure you have .NET Framework 3.5SP1 installed
  2. Make sure you have Windows Installer 4.5 installed
  3. Make sure you have Windows Powershell installed
  4. Uninstall management studio 2005 if you have it installed
  5. Reboot (might not be necessary, but probably sensible)
  6. Download and run SQL Server 2008 Express With Tools
  7. Installation > New SQL Server stand-alone installation or add features to an existing installation
  8. follow through until you get to the features list
  9. Select Management Tools – Basic
  10. You’ll probably have to reboot again

That should be it.  You should be able to download everything that you need freely from Microsoft’s site (I usually find it easiest googling it – Microsoft’s search engine seems a bit rubbish).

No related posts.

Tags: , ,

This entry was posted on Wednesday, March 4th, 2009 at 10:39 am and is filed under Uncategorized. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.

Leave a Reply