Monday, June 9, 2008

SQL Server 2005 Menu items don't show up...

If you install SQL Server 2005 after installing Visual Studio 2005 or 2008 (with SQL Server Express), you may have a successful installation which leaves "Microsoft SQL Server 2005 -> Configuration Tools" as the only menu option.

At the time of this writing, I could find only one article on the net which offered a suggestion, here:
http://articles.techrepublic.com.com/5100-10878_11-6141894.html

You can see from the article that it requires you to remove all SQL Server 2005 pieces...

This is not necessary. All that is truly needed is to navigate to the setup.exe on the installation media and run the following at the command line:

setup.exe SKUUPGRADE=1

This saved me some time, and hopefully it will help someone else out there!