So I needed to install a small compact SQL based database at several hundred locations. No problem, sounds like the perfect scenario for Microsoft's SQL Server compact Edition. There are no royalty fees, etc so I'm good to deploy and go. Easy enough right?
I go to Microsoft's website and attempt to find the product for download. Well I can't find it. So I punch it into Google which returns me the correct link to download the 3.5 SP1 edition.
I install that into my Virtual PC 2007 Windows XP image. No problem, installs just fine. But then I have to write some code to create a database and test some queries against it. Since I'm in the initial phase of design, I figure, I'll just install the SQL Management Studio in the XP image instead of coding a couple of lines in to mock-up app - I'll probably need it down the road for testing anyway (plus it will help my support staff also if issues arise). Well I don't want to go through installing SQL Express tools, etc. but you can't just download that from Microsoft, you need another Microsoft tool called the "Microsoft Web Platform Launcher" so I do that and it wants to install all this other crap, but it gives me a link to the SQL Management Studio as one of the options, so I just click on that link and download that manually.
I start the management installer and it goes through some gyrations and says you need the Microsoft Installer 4.5. So I download that, install it, restart.
Then I start the management installer again and it goes through the process again, then at the end it states I need PowerShell. So I can't find version 2.0 on Microsoft's site, so I use Google and it's the first one, so I download that and install it.
Then I start the SQL Management Installer for the 3rd time and it FINALLY goes through!
What a pain! Hey Redmond, do you guys ever use your own tools? This could have been really easy to handle!