Installing SQL Server 2008 Express Edition
I have been wanting to get back into developing my big project I did in my college years, which was basically a LAMP application. This time, I wanted to set it up as a WIMP environment (har har harrrr, wimp). All went pretty well until I tried to install SQL Server 2008 Express Edition.
Prerequisites
When I started the installation, I was informed that I needed .net 3.5 SP1. So I went and got it, rebooted my machine, then re-ran the installation. Then I was told I needed Windows Installer 4.5. Once again, I got the installation, rebooted, and started the installation. A third time, during the installation, I was notified that I needed PowerShell! Although the UI for showing me I needed PowerShell was much nicer, it was extremely annoying to have to run the installer three times and reboot my machine twice before I finally had all of the prerequisites.
Installing
My machine is running out of space on my C:\ drive, so I wanted to install on my D:\ drive. So I change the drive and find the following errors:
What the hell are these errors? I mean, I realize that when I told the installer to create a directory it may not have the attributes the installer wants, but can’t the installer set those attributes? And INSTANCESHAREDWOWDIR? Wow, that’s an ambiguous error. So I decide to bite the bullet and install in the default directory. I cancel out and low and behold!
The installation link has become disabled! So now I have to close the entire installer and reopen it, how fun! But wait, there’s more! When I attempt to reopen the installer, I get another friendly error!
I assume it has something to do with the eight setup processes that are running, consuming over 250MB of RAM
I finally get to run the installer, I give up and let it try to install on the C:\ drive, so finally I am at “Server Configuration” where I am told to enter my service accounts. Again, I get another error
For some reason it says I have invalid credentials, but let’s take a look at the install window. (My emphasis highlighted in the below picture)
Very nicely done SQL Server 2008. Tell me to click help for more information… WHEN THERE IS NO HELP LINK. Apparently I had to set up the account in the upper dialog, and not the lower one.
So now I’m just one step away from “ready to install”. My nightmare will be over! And guess what happens? You guessed it, ANOTHER ERROR!
Apparently, there was another prerequisite that I needed to install that it failed to tell me about!
In the end, I just ended up installing MySQL.
