As I mentioned in a previous post - I got a new machine. After repaving it with Windows XP and Service Pack 3 I started installing my favorite development tools starting with latest and greatest Visual Studio IDE. Unfortunately I should have RTFM'ed what what out on the web before I did this. Once I was done doing that I proceeded to install SQL 2005 only to be hit with a nasty error message about using SKUUPGRADE to change versions. The problem is that once you install VS 2008 - you will get some of the workstation components (such as osql and some other command line goodies). The problems with this is now I cannot install SSMS 2005.
Trying the SKUUPGRADE didn't help me - I am sure I did something wrong but found something that worked before I could dig deeper into what I was missing.
I found some good posts on how to go about fixing this - but I am a visual guy and sometimes I find pictures (to forgive the old cliche) are worth a 1000 words.
So here is a visual guide to fixing this nasty problem (and if you have not installed VS 2008 yet and are reading this - don't do what I did - just install SQL 2005 first and you should be okay).
What you will need...
1: SQL 2005 Disk you tried (but failed) to install the workstation components with.
2: Your computer - keyboard - mouse etc...
3: Your sanity (make sure you have this - if you don't, go for a walk or something and come back later when you have regained it).
4: No paste, duct tape, welders or any other tools are required for this exercise
Part One - Cleaning up the mess by removing the components added by VS 2008.
1: Open your control panel and go to add remove programs (START->Control Panel->Add Remove Programs).
2: Find SQL Server 2005 and click the "Change Button".
3: You will be presented with the following dialog - select the "Workstation Components" radio button as shown. Then click "Next".
4: The SQL Server Setup will start up again and you will be presented with the wizard startup dialog (I am not showing a picture of that for brevity). Click "Next" button to continue and it will proceed to scan your system. You will notice that there is a warning message for the Edition Change Check (just like when you tried to install it the first time around). You can ignore this too and click next.
5: You should see the following dialog if you did everything right so far, click the "Remove SQL Server" button - this will not remove the server components - just the one you selected in the above dialog (if you have been following along it should have been the workstation components that you selected).
You will be presented with a confirmation dialog next - Click the "Remove" Button and it will proceed to uninstall SQL Server's workstation components (in this case it will just be the client tools that got installed with VS 2008). You will also notice that it removes MSXML 6 (I am not sure why it needs to remove this too as I am pretty certain that the Server components use it as well) - it's okay - we are going to be reinstalling it back in after this part is done.
Part Two - Installing the Workstation components to get SSMS to install (as well all the other components we just removed back again).
Now that our mess has been cleaned up it's time to reinstall the components. Without leaving any of the Add / Remove programs area - we just click "Change" again. You will see the following.
Instead of picking an option in the radio button lists - we are going to click the "To install a new component, click here" link (I marked it in red in case it's not obvious). :)
Now it's will asking for the disk again. Click browse and browse to either one of these paths (this should go without saying but I am adding here for completeness).
for X86 folks go here...
<drive>:\SQL Server x86\Tools\Setup.exe
for X64 folks go here...
<drive>:\SQL Server x64\Tools\Setup.exe
Click Ok and the Standard SQL Server 2005 setup dialog will present itself - accept the EULA - click next and it will scan your system for settings again - once more you will see the Version Change warning rear it's ugly head. Ignore this and click "Next" once more.
Expand the client components node and tell it to install the pieces you want (or if you like to play with all this stuff - just left click and tell it to have all the features installed).
Click the next button.
Note: You can install the Documentation from here if you want - but the chances are good that they are outdated in your installer disk - to get the latest and greatest docs go to the following hyperlink once you are finished with this step.
http://www.microsoft.com/downloads/details.aspx?FamilyId=BE6A2C5D-00DF-4220-B133-29C1E0B6585F&displaylang=en
It should confirm your choices - click "Install" and off you go!
Once this is completed you should be back to normal with SSMS installed on your workstation once again.