Over the summer I went over various SQL server configurations that could work with/for our students in the labs (and also to be better informed when the inevitable questions would arise). I also wanted to be able to explore the wonderful new Integration and Reporting Services during the Fall term.
That's when I discovered that my Management Studio setup was lacking. At the time of initial setup, I was happy just to be able to connect to SQL server and move data between Access, SQL Server, MySQL etc. Of course I read that the Management Studio Express (SSMSE) would only connect to the DB engine. But one does not always remember such details when needed!
The problem is, the solution worked for some and not for others. Unfortunately, I was in the latter category.
I went through the following frustrating steps ("solutions") before (finally) following the ORIGINAL setup instruction!
When I simply stuck the CD and tried re-installing the tools, the setup comes back with the message, "Nothing to install" or something to that effect. Hmmm.
I then went through the Add/Remove process to remove SSMSE completely and then re-install the tools. I then get this lengthy message, "A component that you have specified in the ADD_LOCAL property is already installed. To upgrade..." Not good enough.
Looking through my installs, I noticed that I had SQL server 2000 and a few other related products. Removed them and tried to re-install. This didn't work either.
Tried renaming the tools folder and re-installing. No luck.
Ran the MS Cleanup utility:
http://support.microsoft.com/default.aspx/kb/290301. No luck
I finally went back to the original setup and noted the warning for edition change. I followed the instructions and started the setup from the cmd prompt with the "SKUUPGRADE=1" parameter. ("E:\setup.exe SKUUPGRADE=1"). The tools are in disc 2 if your software came in CDs.