Getting SQL Express Studio upgraded when upgrading SQL Server Express 2008

by zack.moore January 01, 2009 15:47

I've been running SQL Server Express 2005 and the Express Management Studio for all my DB development. Ever since SQL Server 2008 came out I've been thinking about upgrading and today I decided to. However, after I upgraded I noticed that my SQL Management Studio didn't upgrade. After a few minutes I couldn't figure it out so I did a web search and found that Luis Rocha had already figured out the solution to the problem.

You can read his solution here. Some of the screen shots weren't working when I read it and I think he mis-named one of the items to click on Step #4 but much thanks to him for figuring it out.

Essentially, the solution is to close the installation program after upgrading SQL Server. Then, re-run the installation program and select Installation->New SQL Server stand-alone installation or add features to an existing installation. When you are prompted for a new install or add features then select your current instance. Finally, on the feature tree you can select the features to add including the Management Studio.

Be the first to rate this post

  • Currently 0/5 Stars.
  • 1
  • 2
  • 3
  • 4
  • 5

Tags:

sql server

Comments

Comments are closed

Powered by BlogEngine.NET 1.4.5.0
Theme by Mads Kristensen | Modified by Mooglegiant


I've been doing software development since I was little and my dad first brough home an ATARI 800. I picked up PILOT and BASIC. Now I mostly write C# and ASP.NET, and about a dozen other languages and platforms. I also enjoy a bunch of outdoor sports including running and mountain biking. I am very happily married. I am currently working for a great Software and IT consulting company named SPINEN where I am a Senior Developer.


Copyright Zack Moore

TextBox